General

For a list of integers, I need to check the desired value by calling a service. I would like to stop calling the service, only I get the desired output. Any suggestions, please. 

Need to enable certain dates to be selectable based on the logged in user. So the dates to be enabled and disabled for each user and it should be dynamic based on certain business rules. Is it possible to achieve this in Appian?

SELECT * FROM TABLE_A A JOIN TABLE_B B ON A.ID=B.A_ID WHERE B.ROLE IN ('ROLE1','ROLE2') and B.IS_ACTIVE=1 The relationship between A and B is one-to-many, two conditions should be matched in one row I tried to do { queryfilter(Conditon1), queryfilter(Condition2) } But it returned record A with two record B that match one of the conditions each

Hello: We desiged a case with an Intake form but the requirements changed  and the user does not want/need to perform  the Intake .  We deleted the generated form , but that produced an error at the auto-generated page: CMGT_CB_CreateCase_FormSelector But the application stop to work . As a workarround we included this line manually --> equals: "ae1509bc-9463-4120-b2b2-ec428c17decc", then: #"ae1509bc-9463-4120-b2b2-ec428c17decc"( data: ri!data ), This interface has a warning at the top:  -> DO NOT MANUALLY MODIFY THIS INTERFACE. In other hand , when we create the case , we have a blank aditional step after the submit ( related to the page that it does not exist yet).  What steps shoudl we do to avoid the inclusion of this sail code into the autogenerated page and clean al the the intake form. 

Hello, I have an interface which uses a record grid to display a document repository. My documents are stored in SharePoint but the record data contains the SharePoint File IDs, file names and other metadata (the documents are not stored on Appian as there will be hundreds of thousands of documents to store).From this Interface, I want to give the user the ability to view and download documents. In order to do this, I have gone down the route of using an a!startProcess when clicking on a button.  In this process, I am running a loop which iterates through the selected documents, brings the document back from SharePoint, and zips the document together. In the onSuccess parameter of the a!startProcess smart service, I pass the zipped document back to the interface. from there, the user can use a downloadDocument link to download the zip file. The issue I am facing is that in order for the zipped document to be brought back, I must activity chain my process, and when downloading

Hi All,  I wanted to ask if there's a way to determine the peak and average number of user logins during a specific time period. This information is needed to help scale the infrastructure in an on-premise environment. Thanks in advance

Hello folks, I am generating PDF file on click of button. The issue is the text output in the PDF converted a hyphen to a number symbol.  For eg: "year-end" to "year#end" This will only happen if I copy and paste text along with hyphen. Can someone suggest?

I have a group, group type is business group, now I no longer need this group. How can I deprecate/remove it. It has been deployed to higher env like prod. I need to remove it from all env

Hi, I need to have a document upload form like this package import form, and have a validate button like inspect button, but I need to disable the import button before the document is validated successfully. I need to validate the document's content and format, so it's not just a validation for the size and type How can I do?

Everytime that I try to open links for learning paths and courses in Appian I need to login (which I already did) and when I put my credentials, I see this error message:

Hello, We have been using the PDF Doc From Template Smart Service for around 6 months now to generate dynamic documents. We create the templates using Adobe Acrobat Pro. All of the sudden, any file created in Adobe is outputting a <1kb file when using the SS. I have done troubleshooting all the way down to simply creating a blank PDF, saving, then running through the SS and I get the same result every time. I have tried multiple configurations using Save As > Optimized PDF with the same result as well. Can anyone shed some light on what my issue may be or provide some extra troubleshooting I can perform?

How do I get Odd numbers 1-100 ?

Hi All, Using Document Viewer I am able to view the regular PDF. One of my client requirement is they wanted to view the PDF Portfolio document through Appian. Is this possible in Appian? Can you guide me through this? Thanks in advance!

Hi Team, We have a requirement to build centralized Notification Management System. The system should support previews for all supported channels, such as email, SMS, push notifications, and in-app alerts. Appreciate your valuable input.  Thanks, Sinushree

why there is no user context in an expression in a node output

I would like to force logout a user without user interaction. I know that Appian has Session timeout, but I would like to logout a user on a specific workflow (after 30 sec) without disturbing Appian default session timeout settings.

I have a form where user can upload document, I can see the documentId and the document name in localvariable in the form, but when I try to resolve the document content, like using excelreadcellsbynumber. But it feels like the document content is not available, does it mean the document is actually not uploaded at the moment. Since this form is a startform of process A, I try to use startProcess in this form to initiate another process B, but it seems the document is not available in process B as well. Can anyone explain if there is a rule that document content will only be available after submit this form

i have this {a!map(memberId: "test ui "), a!map(holdReason: "test ui "), a!map(description: "test ui "), a!map(summary: "test ui ")} wants an out put like a!map( memberId: "test ui ", holdReason: "test ui ", description: "test ui ", summary: "test ui " )is this possible ??

We deal with sensitive documents and for the sake of security, we are looking for a way to upload docs directly from Appian UI to S3 instead of temporarily saving it in Appian folder and deleting it later. 

Hello everyone, I’m working with an interface grid that is prepopulated with different documents. There's also an "Add New" button that allows users to upload additional documents to the grid. Requirement: Users should be able to upload new documents. They should also have the ability to replace the prepopulated documents with new ones if they find an issue. When a document is re-uploaded (i.e., replaced), the old document should be replaced with new one, and not saved. Essentially, we want to fully replace the old document with the new one. I’ve read in previous posts that the target attribute on the a!fileUploadField component, when set to a folder, creates a new document in that folder. If set to a document, it’s supposed to replace the existing document by creating a new version. However, I’m encountering issues with this approach. Here’s the code I’m using: a!fileUploadField( target: if(

The excel sheet contains some blank rows to divide the sections which I can't change, how can I skip these blank rows when reading from excel sheet. I see this readexcelsheet() function in other post seems it can decide which row to start, is it deprecated?

we are using chartcolumn in our application. Can we increase the X axis and Y axis labels. currently appian provide XAxis Style, YAxis style options are "NONE" and "STANDARD". please let me know if we can make these labels bold and italic/underlined. Thanks

Hi all, We're running out of disk space on our cloud environment. Appian Support has identified that the main culprits are our Knowledge Centers. They can't however identify which specific Knowledge Centers are the largest. We have over a hundred though so it may just be an accumulation of them all. But anyway, I need to find all their individual sizes and am hoping someone knows how to do this without manually checking each Knowledge Center's properties? An option I'm trying is:  a!localVariables( local!knowledgeCenter: cons!ABC_KNOWLEDGE_CENTER_PROPERTIES, a!forEach( items: local!knowledgeCenter, expression: { creator: knowledgecenter(fv!item, "creator"), dateCreated: knowledgecenter(fv!item, "dateCreated"), description: knowledgecenter(fv!item, "description"), id: knowledgecenter(fv!item, "id"), name: knowledgecenter(fv!item, "name"), numberOfDocuments: knowledgecenter(fv!item, "numberOfDocuments"), size

I'm looking for some best ideas to support read only access to prod. I'm leaning towards create dev/qa as basic user and add to designers group and view only application specific groups then remove designers from DB Editors which allows dev to access both DB and designer in read only mode. Any drawbacks or any articles/ ideas to do it in different way? Appreciate your time! Thanks

I would like to be able to select entities on case creation that can be associated with my case, but it appears that I do not have access to the interface that facilitates associating entities that is outlined in the CMS Guidance document: see attachment/cfs-file/__key/communityserver-discussions-components-files/11/Case-Management-Studio-_2D00_-Common-Customization-and-Configuration-Guidance-24.3.pdf (Page 17, Step 2 of the section "Associate entities on case creation".) Is there anything users can do to gain access to this document, or is it possible to perhaps implement this interface yourself? Does this interface support selection of multiple entities for association with a case, and if not, could I potentially extend it to allow this functionality?