Foundation

When trying to upload a blank file getting a validation message  But, when replaced with a proper file, that validation message still shows  On testing the interface also, this validation message still persists. Only on, screen reload it goes. Need help regarding this.

Hi all, I'm having an issue with aggregation and i've not been able to find a good answer.I have a dataset that is made up off a number of collection of records. Something like id   groupid  value   updatedOn   1    1             xx        19/01/2021 10:002    1             xx        19/01/2021 10:003    1             xx        19/01/2021 10:00 4    2             xx        10/01/2021 10:005    2           xx        10/01/2021 10:006    2             xx        01/01/2021 10:00 7    2             xx      &nbs

How to maintain color codes for each iteration for different color in audit log

lets say I had a word "Appian"  now I need to covert into a list expecting a result like below( Letter - (Number of times that particular letter is being repeated in the given word)) A-2 p-2 i-1 n-1 Please let me know logic to achieve this

I want to bold a particular word in a text when using a a!richtextitem. when I use the "Style" as "strong", it's making the entire text bold.In my case, I only want a word to be bold as shown below. Can someone please help a!richTextDisplayField( value: { a!richTextItem( text: { "We recommend ABC method.",}, style: "PLAIN",) } )

Hi All, We have an application where we use application action to trigger the process model and am able to see the action on tempo(DEV environment). Whereas I couldnt see it on TEST environment even though am part of same group as in DEV environment.  Could you suggest any ways to troubleshoot this issue. I have Checked application security Checked process model security Additional Information: TEST is on latest version compared to DEV now. Thanks in advance

Hi all hope someone can help. I am working on an integration in a process model and I want to pass some variables to the integration step I am assigning a recordtype value to the inputs in the data tab all works for division for example where I assign pv!record.recordtypexxx.division but it doesn't work when I assign the relationship data for example departmentid has a value of =pv!record.recordtypexxx.relationshipxxx.fieldoftherelationship It seems that the relationship values are not being passed? If I create an interface to display the data everything is there as expected both in the main record type and the looked up data from the related record type is there and correct. So the relationship works. Then why when I call the relationship data in the inputs in the integration it doesn't pick it up??????

I have a CDT SOA_SUMMARY which is the parent of CDT SOA_ITEMS.In reconciliation the three columns (Bill Ref No., Bill Date, SOA Number) are merge into one. I cannot select or draw manually to configure the column and my workaround is to manually clean the data. Can you please help me to split the array of string using a script task and assign the values to designated column? It should be in a loop to iterate each row.

Hi There! As the following screen shot shows, I do not see the name of the process model the Subprocess node is configured to execute. It only impacts the display of the model name. If I right click the node and select Edit Sub-Process Model, it opens the correct process model. If I click the Refresh button on the setup tab, it correctly refreshes the list of parameters. I only noticed this behaviour recently. It is only in our DEV environment. I have tried clearing my browser cache, restarting the browser, using a different browser. I am a System Administrator and have the same application security as my peers. I am the only one experiencing this behaviour. Any ideas what is impacting my profile in this environment?

Hi, I have a user interface with a read only grid at the bottom with a button "ADD" on top right corner of the interface. Now, when the user clicks on "ADD" button, I would like to show the interface in a popup window, instead of showing in the same window. How can I achieve this. Any suggestions please.

Problem and Solution ---> Received this error when I tried to compare two variables values, one is of dictionary of data eg: { category: "vehicle", type: "car" }  and other list of dictionary data eg: {{ category: "vehicle", type: "car" }}. This double curly braces in the 2nd example introduced this error, when I tried to match the value with 1st example. Hence, made the change accordingly by adding append function to the 1st example. Used append like the below code.

Hi All, I have a scenario where a process model is updated by "Person A" and that process is started by "Person B". When i try to get pp!initiator and pp!designer, am getting "Person B" as value for both. As per my knowledge "Person A" should be pp!designer. Can anyone explain why this  happened? Thanks in Advance.

I have a process including Write To Data Store Entity node, I need to query saved data after a!startProcess success, I used a!queryRecordType to query data, but I have no result.

In the interface. I am getting error message for the below piece of code.  Error message : Expression evaluation error in rule 'sshs_startformquestions' at function a!cardLayout [line 48]: Cannot compare incompatible operands of type Null and type Number (Integer). Line: showWhen: { local!selected1 = 2 } It would be great if someone can help. 

my condition is like, when click on radio button it goes to next activity and radio button must be disappeared so i want to do only disappeared radio button when going to next how can i do that ?

Hi All, We are doing a POC in which the users can select the list of appian objects that they have modified on a particular day. We are planning to use a picker field which will give the Appian Objects as Suggestions so that the users can select the their objects. Just wanted to check if there is any function which would give the list of all the Appian Objects from a given application uuid or name? Thanks in Advance!

need

Hi, I have a question, a problem, they are asking me to do some tests with an XML, I have my instance in Appian and the client tells me that when they download an xml it does not let them open the xml in their browser, is there any relation with appian? or is it a configuration of the client's equipment. Thanks!

How to effectively prevent UI evaluation errors when choiceValues change?  In my project, we are commonly using a table holding reference data to be displayed in dropdown fields. The problem is, whenever these values change, the dropdowns get updated, but if a value has been removed or edited, but previously saved to the database, now we get a UI evaluation error saying that the value is not present in the choiceValues - which is understandable, of course. But how can we effectively guard against this sort of behavior? After an update like this, we usually face a billion errors when users (or developers) bring up an old record or old task, which had a value saved that is no longer present in a dropdown. Is there a good preventive measure for this sort of cases?

Hi Everyone, I have an interface where the data is populated from record type and in the interface there is one link field where I am passing the record type field and identifiers. I the record type I have added the summary interface which will get open on click of hyperlink. My issue is how can I pass rule inputs from interface to the record summary interface? Any suggestions are welcome!

Hi All, I have a requirement where I have to export the request to PDF. So to achieve this I am using "DOCX from dynamic template" smart service. Here I am facing 1 challenge, I have a Database table where I have data in below format(like grid), Section Name Clause Text Amendment Number date Sec1 Text1 1 18-01-2023 Sec2 Text2 2 18-01-2023   But in word, I want the above data as separate sections, like below format Sec1 Clause Text Text1 Amendment Number 1 Date 18-01-2023 Sec2 Clause Text Text2 Amendment Number 2 Date 18-01-2023 So please help me how to create dynamic sections based on the number of rows of data in word, I tried below one, but it is not working, throwing the error

How to transfer the data of excel file into mysql Database?

I have one array like {1,2,3,4,12,12}, I want a new sub array from 3rd index till end like {3,4,12,12}is there any rule or function?

Hello, I have an interface that needs to show default value in dropdown for my users when some options are specified (see example below)  { a!DropdownField( label: "Toto dropdown", choiceLabels: {"1", "2", "3"}, choiceValues: {1, 2, 3}, value: ri!toto ), a!DropdownField( label: "Tutu dropdown", choiceLabels: {"4", "5", "6"}, choiceValues: {1, 2, 3}, value: ri!tutu ), a!DropdownField( label: "Foo dropdown", choiceLabels: {"Test", "Test2"}, choiceValues: {140, 150}, value: if( and( isnull(ri!foo), a!isNotNullOrEmpty(ri!toto), a!isNotNullOrEmpty(ri!tutu) ), if( and(ri!toto = 1, ri!tutu = 2), 140, 150 ), ri!foo ), saveInto: ri!foo ) } This interface is embedded in a form component, when i submit this form and the default value of the "Foo dropdown" hasn&#3

Hi, Dropdown field is getting error, can anyone provide inputs to resolve. a!localVariables( local!refData: rule!EC_getReferenceData( appName: "EC", category: cons!EC_REFERENCE_CATEGORY[{ 2, 3, 4, 5 }] ), local!departmentList: rule!EC_filterRefData( refData: local!refData, category: cons!EC_REFERENCE_CATEGORY[2] ), local!Existing_Emp_ID: if( rule!APN_IsBlank( ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{5dd14089-6372-498b-bdd4-49221479de4c}id'] ), false(), true() ), local!Emp_Data: length( rule!EC_getEmployeeDetails( empRefId: ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{5dd14089-6372-498b-bdd4-49221479de4c}id'] ) ), local!EMP_Code: if( rule!APN_IsBlank( ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{5dd14089-6372-498b-bdd4-49221479de4c}id'] ), concat("EC" & local!Emp_Data + 1), ri!Employee['recordType!{13a37d27-9cf0-4b44-aa16-596960c2aeb6}EC Employee.fields.{190fbb44-7340-