Foundation

todate function subtracting date with day minus one day

We are importing the SCIM User Management application provided by Appian on the market place:  [mention:f8e98d7fbd7245cbb0e4083fc4357870:f7d226abd59f475c9d224a79e3f0ec07]  The locale for that application is en_US. The locale for our Appian server is GB. We get the following error when trying to import:  Problems (1):processModel 0002e9c5-4ae7-8000-558d-3a4d983a4d98 "{en_US=SCIM Deactivate User}": An error occurred while creating processModel [uuid=0002e9c5-4ae7-8000-558d-3a4d983a4d98]: com.appiancorp.process.validation.ValidationException: Process Model is not valid. The process model must have a valid name in the site primary language: English (GB). (APNX-1-4071-007) How are we suppose to import applications if they are for a different locale? Thanks

My requirement is to know the process model status i.e. i wanted to know all the process models that are failed so that i can use them to trigger some api. As per current approach, process model either completed or failed with errors both are giving me status as 0. How can we create the difference. Please guide

Hi Team,Could you please check and suggest a solution for below issue?Expression evaluation error in rule 'appian_rule1' (called by another rule 'appian_rule2') at function a!queryRecordType: Cannot invoke "Object.getClass()" because "activeProcessCount" is null

Hi all, I am facing an issue related to data being refreshed in read-only grid. The issue is in my read-only grid, I have navigated to a different page say 21-30. But after certain interval i.e., 30 sec my grid page navigates back to 1-10 automatically. I have a configuration of refresh Interval of 30 sec in the read-only grid. Does the grid refresh configuration update only the grid data or it also impacts the current fv!pagingInfo of the grid? Reason to add refreshInterval was to update the grid data for user as soon as a new work item is created. BTW the data field is a recordtype which allows me to use certain other features of grid.

Hi, Can I have a button inside of a dropdown?  Thanks in advance

Hello, I would like to know if there's a way to detect the User abandoning a session. The issue is that there are User Input Tasks that I lock to specific users when they accept them. I have a problem with the case where the User exits the form not by clicking the "EXIT" button, but by just closing the browser tab, which leaves the process running until timeout and the task remains locked. Is there a way, other than the timer, to determine whether the User had abandoned a session on a form? Thank you.

Hello, I have a template of type .docx in which certain checkboxes must be shown as 'Checked' or 'Not checked' depending on the value of some variables. I also have to, in case X variable exists, I have to show a block of the document and not show it if it is empty. I was trying to use MS Word 2007 from template but although it takes the fields correctly with the ###, I don't know how to implement those "if()" conditionals and make it work. I have also been looking at the Docx from dynamic template smart service of the 'Advanced Document Templaiting' plugin but I am not sure how to do the XML part and if I could do those "if()" with it. Has anyone had this problem or some solution available?Thanks in advance

I am trying to create a dropdown menu in my application that looks and functions like the one in the attached image. I am unsure how to make the dropdown appear like this without dropdown component Can you please help me to achieve this

Hi I have parent process and a Subprocess "waiting queue". this sub process is configured as a MNI with configuration to "Move on after all instances are done". However, after each instance of sub process is executed the node following the MNI is executed and its not waiting for all instances of MNI to finish. Please have a look at the implementation below and let me know if anything is incorrect?   

Hi Everyone, We need to manually validate the accessibility of a few styled text editor components before enabling the document export. While this can be done using browser extensions or accessibility testing tools, the client wants to perform the check within Appian. I would appreciate any insights on whether there are any Appian community-supported plugins or reliable APIs that can help achieve this. Thanks!

Hi Team, has anyone Integrated Appian with Jira ?

I need to validate the checkboxes when the submit button is clicked, based on a specific condition. There are four checkboxes, and before submitting the form, the user must check at least one. However, instead of using FormLayout, I’ve created the form using CardLayout and local variables. I’m looking for suggestions on how to improve or streamline this approach.

In Case Management Studio, tasks can be routed based on decision in decision type tasks and using dependent. But I want to trigger/route from one task to other based on case field data. For example, if there is a case data field named "Amount", then I would like to route tasks based on the value of Amount filed. Is there any way to do this?

Hi, I have a subprocess, "waiting queue" ( which contains all automated nodes). This subprocess is configured to execute as MNI - Synchronously, with configuration "Move on when all instances are done" However, after each instance of this MNI is executed, the Node following the MNI Sub process is executed i.e. the node following MNI is executed as many number of times as the MNI instances. I want to wait till all instances of MNI is executed before moving forward. How to achieve it PFB screenshots        

Hi team, I have a grid from view and have record actions for time1, time 2, time 10 etc columns , so user can interact with the columns. now when we click on record action , i want to send input to the popup screen that time 1 is clicked. time1 to time 10 imagine "07:30" and more id name time 1 time 2 time 3 time5 time 10 1 abd recordAction recordAction recordAction recordAction recordAction 2 bcd recordAction recordAction recordAction recordAction recordAction

How can we allow certain users to view critical fields while restricting access for others, all within the same application and read-only interface? What’s the best approach to achieve this?

can be run by Open and monitor in new canvas Here using a Subprocess

I've config a summary page in record type, the interface be like rule!BCD_userDetails(userDetails: rv!record). But when I click on record link the summary page has no data populated, seems rv!record has no value in it

Hi Experts,  I have an issue with export data store entity to excel that  without changing any piece of code: Sometimes it is giving exact result in excel as expected Sometimes it is giving few duplicate rows at the bottom of the excel If I download few excel files from the same Page, few excel files seems perfect, few have duplicate rows at bottom I'm failing to fix it. Please help me with some suggestions and if is there any work around. Thank you in advance

Not sure where i went wrong, gets below error, i understand error says i cannot use rule inputs in a!save, any suggestions to fix it:

I'm trying to uploading an .sql file which we have blocked in an admin console. It will throw a validation message. Then I'm trying to upload valid file, But the validation message still displays Thank you in advance

How to add commas for large numeric digit(125000) in bar axis for column chart field?

I have an editable grid with an addRowLink, when I clicked the add row link, the grid somehow changed, like first column became wider and last column was narrowed, anyone knows why The only think I did in addRowLink is append a new item to current list

I am using a!recordsChatField(). When asking a question, I receive a response like "I apologize, but I am not able to provide information about changing a payroll vendor, as that is not related to the data provided for the RH Project Ref entity. As an AI assistant trained on this specific data, I can only respond to questions regarding the fields and information presented for this entity."  I'm assuming the reason for this response is because I need to aggregate the data in the record. Within Process HQ I can aggregate all the data in the record with the click of a button.  When using Copilot in Process HQ on the same record, I receive a proper response to the same question since the data is aggregated.  Can someone provide an example of how I can aggregate the record data within the  a!recordsChatField() component? Here's what I have so far: a!recordsChatField( label: "Chat", instructions: "Type in a question", suggestedQue