Discussion Categories

Hi, My Requirement is to update selected checkbox(Multiple selection checkbox) row data and status by selecting dropdown to the table. Firstly I am querying data from the table and By multiple selection trying to update the data to the table via Status. Steps: 1.I have multiple checkbox selection . 2. Once Checkbox selected ,which ever is selected as checkbox using Dropdown trying to update to the same table. But Attached code is not working ,if Someone Suggests for solution that would be more helpful.  a!localVariables( local!crAppDynamicChecklist_cdt: rule!CR_APP_QE_getDynamicChecklistByFilters( cif_int: ri!cif_int, sectionType_txt: cons!CR_APP_DYNAMIC_CHECKLIST_SECTION_TYPES[1] ), { a!gridField( data: local!crAppDynamicChecklist_cdt, columns: { a!gridColumn( label: cons!CR_APP_TXT_ACTIVE_COMPLETED_DOCUMENTS_LABELS[1], sortField: cons!CR_APP_TXT_ACTIVE_COMPLETED_DOCUMENTS_LABELS[1], value: joinarray(

I want to create a custom record field that converts a string timestamp field to date or datetime just to use it in user filters. I chose the real-time option but it seems something is wrong with that because when I tried with sync-time evaluation it works. This is the code:  datetime( left(ri!stringTimestamp, 4), mid(ri!stringTimestamp, 6, 2), mid(ri!stringTimestamp, 9, 2)) instead of ri!stringTimestamp I am using the respective record field

Hi, We are configuring SAML SSO in our client environment but after adding all the required information and saving the configuration I get this error when trying to access using SAML:  I have seen in the documentation that it could be related to the Authentication group, but the user for this test is a direct member of the Authentication group for the Idp, so it should work fine. Has anyone had this issue before and were able to solve it?  Thanks in advance.

Hi Everyone, I am trying to achieve multi selection checkbox but its not working as expected a!checkboxField( label: "", choiceLabels: cons!CR_TXT_CHOICE_LABELS_YES_NO[1], choiceValues: cons!CR_APP_INT_CHOICE_VALUES[1], value: if( contains( cons!CR_APP_INT_CHOICE_VALUES[1], tointeger(local!selectionFlag_int) ), tointeger(local!selectionFlag_int), null() ), saveInto: local!selectionFlag_int, align: "LEFT" ),Currently, If I select one checkbox it is selecting all checkbox ,But I want to select multi checkbox ,How would I achieve this, can anyone correct this code . Thanks in Advance.

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

I am using DOCX from dynamic template and able to generate document having multiple pages (generated dynamically and depends on the size of passing array.) For each entry I have a header and because of the data length, Header is not coming on top of each page for the same item content.(Required: Header to be displayed on the pages till the length of the content of the item) How can I make sure that header will always come on Top of every page of same item content and next header will start from next page always with new item content ? Is there anything we can configure in Dynamic template? I came across one solution: But this is again a lengthy process, So is there any other solution that can be tried apart from the screenshot attached?

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!!

Can I preview the excel documents in the document viewer field

Hi everyone, I have a simple process model with a single node configured as Write Records Smart Service. This process model is used to update the status of each record in a process variable which stores a list of multiple ABC Client records. The ABC Client Record has the following fields: clientid, name, status. In the corresponding Event History record I have a field for comments where I want to have the following information: "Status of " & recordType!ABC Client.fields.name & " was changed to " & recordType!ABC Client.fields.status but I don't know how to configure it properly. When I try to capture the event history for each of the records in the list separately, I encounter an issue with the standalone Write Events feature of the Write Records smart service. I can not find a way to individually reference items in the records list being updated (i.e. just like we do in the a!forEach function when

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. 

1. Current setup we are generating the JWT token using and external system key and the details we are stored in the Third-party credentials in Appian admin console, and we are using the JWT token to generate the token, and this approach works well. 2. Problem The external system key expires every six months. This requires manual updates to the key in the third-party credentials in the admin console. We have access to a Realtime API to retrieve the external system key dynamically. Is there a way to generate the JWT token without manually updating the third-party credentials every six months I need to build like this, I have a process first I will trigger the API to get the external system key and I will pass the key and i have to get the JWT token.

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

What security settings should be given to restrict support users to access only the process instance but should not have any access to the main object itself ?

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

Hello, I need to create rule that takes an array of dictionaries in input and if multiple of these elements have the same "id" value, I want to take only the first one in a separate list: ri!list: { {output: "OK, id: "abcd", description: "hello"}, {output: "OK", id: "abcd", description: "hi"}, {output: "OK", id: "yxz", description: "bye"}, {output: "OK", id: "yxz", description:"goodnight"}, {output: "OK", id: "opt", description: "ok"} } the output should be the following: local!output:  { {output: "OK, id: "abcd", description: "hello"}, {output: "OK", id: "yxz", description: "bye"}, {output: "OK", id: "opt", description: "ok"} }

Hello Appian Community, I have access to forum.appian.com, but I'm unable to access the License Management Application to request licenses. Specifically, I need to request both the k3.lic and k4.lic files for my Appian installation, but I cannot proceed due to this access issue. Can anyone guide me on: Alternative methods to request both licenses (if License Management Application access is restricted)? How to register a developer instance with Appian? Any insights or step-by-step guidance would be greatly appreciated! Thanks in advance for your help.

Hello, I have a use case where I need to download multiple documents from SharePoint. Currently, I need to do this in a process model and the only way I have found of doing this is by creating a loop within my process.  Unfortunately, I need to activity chain this process and by having this loop, I risk breaking the 50 node limit. My question is as follows: is there any way to download multiple documents from SharePoint using a single node within a process? Thank you

There is a database table where user can write into. I need to generate a dynamic template using the data from the table. Meaning I have a button or a link, whenever user click it, the latest template should be generated and downloaded. 2. And I want one of the column to be populated with a dropdown and user can only choose value from the dropdown, which also means the excel should be protected. Can we generate protected excel with only specified cells that can be edited How can I implement this?

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?

Hello, I am trying to add a document link to an interface. I found the a!documentDownloadLink function and it tells me to create a constant to point to my documents but I am a bit lost. This is an interface where a supervisor will approve or deny a request so the document link in the form should be attached to the specific request. What do I need to do in the cosntant to point specifically to that value? The value is store in my recordType as an integer and it is added to the record through an attachment component in a record action.  any help is appreciated

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 two tables with a one to many relationship, an owners table and a pets table which are connected via the Owner ID. The owner can have many pets. I am trying to add an action under the owner summary view for the user to be able to add a new pet that belongs to the owner but I am struggling with how to connect the two records. I have created a related action under owner that points to the add / update pet but I am struggling to connect the owner ID to the pet being added, any help would be greatly appreciated! 

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