Foundation

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-

Has anyone successfully installed Appian on a Mac that uses the M1 Chip (Apple Silicon)? Currently I am having an issue as the Dockerfiile is using centos7 which is created for Intel chips, and its resulting an error because of the M1.  Getting this error when doing a docker-compose build: failed to solve: rpc error: code = Unknown desc = failed to solve with frontend dockerfile.v0: failed to create LLB definition: no match for platform in manifest sha256:691c55aabb3c4e3b89b953dd2f022f7ea845e5443954767d321d5f5fa394e28c: not found Another example of the error: https://stackoverflow.com/questions/67911250/cant-build-docker-compose-on-m1-chipset  I know this is not an Appian issue but anyone that has been through the same thing and managed to find a solution would help a lot!

Hi, How to prevent running of truncate and delete query accidentally on database table. Is there any role and access setup can be done to prevent this considering having "System Admin" access in APPIAN. Regards Bihitak

So I would like the user to click a link or a button in a UX and that launches a process model. The process model will determine a url that needs to be opened in a new tab. I only want the process model to run when the user clicks the button or link.I have tried a!startprocess with success: but im not sure how to get the url opened in a new tab. It successfully runs the process but nothing else seems to happen.Trying various things on the OnSuccess. Httpreponse etc

Hi, I have a requirement, where invoice documents from multiple vendors will be sent to Appian as a single PDF (page number around 250 - 300) file. As the invoice documents for each vendor needs to be processed using IDP, we need to split the PDF document into multiple PDFs. The pages for each vendor invoice documents will not be static, it can vary depending upon the content on the documents.  Kindly share your thoughts on how to proceed with splitting the PDF file to send them further for processing. Regards, Deepak Devarajan   

Hi All, We are trying to display the tasks count in the navigation panel as dynamic label.It works as expected in web browser .But when we access the same from custom mobile app the tab name is not updating dynamically and it updates only after logout-login. Solutions tried: 1.We have tried to remove the count if the site is accessed from mobile device using a!isnativemobile() function .Which throw the error mentioned below 2.We have tried converting the label from external expression rule which didnt help much. Please suggest.

I want to use the function numprocessesforprocessmodelforstatus(id, status, includeSubProcessData), but I don't understand how to get the ID of the process model I want to reference. The documentation doesn't give an example that incorporates fetching the ID of a model, the example just says "numprocessesforprocessmodelforstatus(processModelId,"completed")" but doesn't explain how to get the id. The documentation has been giving me a headache since day one. If I look up "process model id" I get zero results in the documentation search.

{1,2,3}, {56,76,54,32}, {12,23,45,54,32,54}, {1,2,3,4,5,6,7}, {8,9,10,11,12,13,14,15} Please suggest how do this using foreach function get output like this,  "length of array 1 is 3" "length of array 2 is 4" "length of array 3 is 6" "length of array 4 is 7" "length of array 5 is 8"

Hi all, we've been confronted to a strange case. For a better understanding we've reproduced the behavior in a expression rule : if({ 1 } = 1, { 2, 3, 4 }, {}) returns 2. Obviously, comparing a list with an integer is the error here. But, then, the result should be either the empty list or null or an error message. For more fun, you can test : if({true, false, true},{2,4,6},{3,5,7}) In our mind, a type error should be returned. Regards.

Hi Everyone, I have a requirement where i can reuse local variable array. For Example a!localvariable( local!iterations:{1,2,3}, local!value, a!foreach( items:local!iterations, expression{ append( local!value, fv!index )})) The output i need is 1st Iteration 1 2nd Iteration 1 2 3rd Iteration 1 2 3 But the output the code is generating is 1st Iteration 1 2nd Iteration 2 3rd Iteration 3. I thought that local variable should be append with the value and  can use for next iteration but it is initializing every time with null value rather than appendvalue. Could you please help me to get the output i need Thanks In Advance!!!

Hi There, We have a requirement to show each detail on new line in Hierarchy Tree Component. Fo example in the below attachement when we hover the cursor each detail coming on new line since we used char(10).  However, we would need to show the same way on the node itself without hovering the cursor. Please let me know your thoughts on this. Thank you.

My process models were developed and tested when Primary (and the only) Locale was English (US) by default. I now need to change the Primary Locale to English (UK) - to get the dates appearing in correct format (as I am in New Zealand, and here we use date format as dd/mm/yyyy; and not the American mm/dd/yyyy format). When I change my Primary Locale to "English (UK)" - the date formats work well; but my Process Model names are showing as "???".  I do understand that somehow I need to redefine Process Model names in the new English (UK) language (which BTW seems strange, as the process model names would be exactly same in these two "languages" :-) ). However, I don't know how to do it. Are there any other properties that I need to update for the new locale? Any thoughts, for a proper solution to this?  Thank you in advance.

  this is my cdt  i dont know how can i delete a username for the usernames field  in the db.

Hi Everyone, I have two interfaces, interface 1 and Interface 2. The interface 2 is inside interface 1, interface 1 is having a button which is calling exp rule to call web service to update DB. Now when I click on button the interface 2 is not refreshing latest data. Could you please suggest how to achieve this?

Hi everyone,  One of the process models that I'm working on is using a Timer Event node, which is having a scheduled delay setting as shown below: (the constant returns 2 (integer)) I think the node supposes to delay for 2 minutes, then will activate the next node (Merge document) to run.  However, this Delay node has stuck there for much longer than 2 minutes, and when I check Process History, the node is Cancel.  The Merge Document node does not have any setting for Scheduling either I haven't worked with Timer Event before, and couldn't find the reason for this behaviour from documentation. Could anyone help me with this? Thanks a lot,

Hi All, I have a requirement where i have to add  validation on a text field and the validation is like + and three integer. please help me out with this. thanks. 

Hi, I have an interface and I would like to change the Parent folder for the interface to a different folder. Any idea how I can do this.