Foundation

Hi, i have a adress CDT with all the address fields and Address_Type(Values:"HOME_ADDRESS","MAILING_ADDRESS","EMPLOYER_ADDRESS"). now is it a good design if I can capture all the address in one local variable local!allAddress(map type) and map outside the Interface. or is it okay to construct AddressType inside the interface and taking out as RI.

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 everyone, I have a requirement where I should be able to grey out the weekends for the user while selecting any date on a date field. Also, they have some list of standard specific dates where the calender should be greyed out. Can anyone help me how I can achieve this? Thanks!!

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

Would be nice to have the Indeterminate state  on column heading on selectable grids where only some of the rows have been selected /resized-image/__size/640x480/__key/communityserver-discussions-components-files/13/Screenshot-2024_2D00_10_2D00_18-at-11.08.00_2F20_a.m_2E00_.png

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 want to know the internal mechanism of local variable refreshing in an interface. When a local variable is refreshing, what is the underlying logic of the behavior? Is all code re-executed? Can you give me a conclusion and provide a demo to prove the conclusion.

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?

am getting this warning

Hi, sometimes I have to go back to the basic rules of Appian. I have an editable grid with REQUIRED fields to show in a page of a Site. To make this validation work, I have to put the interface in a start form of a process and then add this process in a site page as Action, otherwise it won't work. Is that correct? Thank you

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, I have a process for parsing data, and in one of the nodes, I'm checking whether the respective alert exists for a specific event. The script task has one output, which uses a QR rule to retrieve the alert based on the event's alert ID. The retrieved alert is then stored in another variable. The QR rule returns a single alert, which works as expected in all other environments, but in production, the result is null in the process model. This issue has also occurred with other processes using the same rule and having multiple outputs, but when we split the logic into two subtasks, it worked fine. However, for this process, the problem persists. Could you suggest what might be causing this issue?

I am creating a practice application that takes in a pet's owner, and the pets that the owner has. Because the owner can have more than one pet, I have created an editable grid that passes the input pets in to a rule input that stores them as a "list of recordType!w0428pv pet". I would like to be able to use the write records smart service to take that list and input it in to the database as individual records but I'm not sure if that is possible or the right way to go about doing this. I believe the process variable is storing the array of pets correctly, as it looks correct in the preview on the design page. Any advice would be greatly appreciated! 

Hi everyone, I hope you can help me with something that is driving me crazy. For some scenarios it works and for others it doesn't, but basically I have an interface where the only thing I do is show database information. I went from validating nulls in the following way, {} then to "" and finally null() but the error was always the same "Null? list must be used within a SAIL component" I attach an example of my code, I hope you can help me identify what the problem is. a!localVariables( local!newComment, local!dataVerification: if( a!isNullOrEmpty( ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.{82090d2d-4f09-4af2-9995-eda5781d1392}id'] ), "", rule!TTC_getVerificationByIdClient( idClient: ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.

hi  i would like to know if there is anyway to stop the scheduled process model during deployment

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?

Hi everyone, I hope you can help me with something that is driving me crazy. For some scenarios it works and for others it doesn't, but basically I have an interface where the only thing I do is show database information. I went from validating nulls in the following way, {} then to "" and finally null() but the error was always the same "Null?list must be used within a SAIL component." I attach an example of my code, I hope you can help me identify what the problem is. a!localVariables( local!newComment, local!dataVerification: if( a!isNullOrEmpty( ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.{82090d2d-4f09-4af2-9995-eda5781d1392}id'] ), "", rule!TTC_getVerificationByIdClient( idClient: ri!recordRequest['recordType!{f3693eb2-ffb2-4407-814e-681b44ba8ef5}TTC Request.relationships.{42fd7ed7-d716-49c6-b449-e1fa839b532a}client.fields.{

local!selectedSystemType: if( a!isNotNullOrEmpty( local!dataFeed['recordType!{fcce7d6a-d964-4fb7-bc9c-610a5333f0ee}EILM Inventory Data Feed.fields.{785adc35-6266-4c30-abbe-eca44c05c93d}systemTypeCode'] ), local!dataFeed['recordType!{fcce7d6a-d964-4fb7-bc9c-610a5333f0ee}EILM Inventory Data Feed.fields.{785adc35-6266-4c30-abbe-eca44c05c93d}systemTypeCode'], null() ), a!buttonWidget( label: cons!SHARED_BUTTON_LABEL_NEXT, icon: cons!SHARED_BUTTON_ICON_NEXT, saveInto: if( a!isNullOrEmpty(local!selectedSystemType), {}, a!save(local!currentDataFeedStep, local!currentDataFeedStep + 1) ), style: "SOLID", color: cons!SHARED_BUTTON_COLOR_NEXT, disabled: a!isNullOrEmpty( local!selectedSystemType ), showWhen: local!currentDataFeedStep < 3, validate: true() ),

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

Hi Team, The custom sender email functionality was working fine until last day in the environment. Suddenly it had stopped working and the send email node is getting errored, and error message says, "Failed to send email". Have anyone faced a similar issue, we have also observed that all the other mail functionality like process model is working fine. Please help us on this issue. Thanks.