Foundation

Hi , My process was getting errored out at Parse XLSX file node saying  Error: An error occurred while evaluating expression: Output:rule!s_CRDoc(pv!changeRequestFile_doc) (Expression evaluation error in rule 'c_doc' at function 'readexcelsheetpaging' [line 8]: com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence.) (Data Outputs)

So I have an interface that is saving two array of CDTs the idea I was having is that it would store each iteration of the array into its own respective row for the array example: {[uuid:1, fkuuid: ab32, date: today], [uuid:2, fkuuid: cd43, date: tomorrow]}. In the database there would be a row for UUID 1 and a row for UUID 2 but when I execute the write to data store entry I only get uuid 1. To push this even further I am doing this two times for separate tables and its only putting 1 entry into 1 table.  If there is any more information that is needed let me know! Any Ideas on how to get it to save all the information in the array of cdt to each of its separate rows?

When should we re-deploy an application vs. using a patch?

Hi, Is there a function available to retrieve only direct members from a group. The a!groupMembers function returns both direct and rule based members when "direct=true" is passed, but I am looking for a way to specifically obtain just direct members. Thank you 

I have used validation while creating a new entry in the grid which shows a message in case of duplicacy in entered field. But when I use the same validation in the update related action , it shows the duplicacy message  as soon as we click on update, even before actually updating it. How to resolve this? I want validation to occur when i enter the data, not when I it automatically loads the data

I am trying to create nested CDT . As part of that one of the CDT needs to be created multiple times. I tried to use forEach in type! but it's throwing me below error.  Expression evaluation error: Syntax error. Details: Expression evaluation error at function a!localVariables parameter 2 [line 7]: Keyword and non-keyword arguments must not be mixed. Used in: {urn:uk:aviva:appian:eow:createdocumentstoreanddistribute}EOW_coverLetterDetails.. Please find below code for reference, -- a!localVariables( local!customerNomineeDetails: {{Forename:"name1",Surname:"surname1",PercentageAmount:"45"}, {Forename:"name2",Surname:"surname2",PercentageAmount:"40"}, {Forename:"name3",Surname:"surname3",PercentageAmount:"45"} }, local!requestBody: 'type!{urn:uk:aviva:appian:eow:createdocumentstoreanddistribute}EOW_coverLetterDetails'( xcdBeneficiariesIndicator: "N", xcdCOBSchemeName: &quot

Hi everyone! [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05] and I will be going live at 11:00AM Eastern to talk all thing Appian Records while building an app using the PokéAPI! Join us live to build with us and ask all your burning Records questions. Here is the see attachmentApp Information Packet that will provide you information on getting set up to build along with us and give you ideas for additional functionality you can build out. We can also use this thread as a "show & tell" if anyone would like to share what they've built!

I've been experiencing this since a couple hours. every time i submit a user input task in one process model it throws this error even though the  process model  that is giving me this error hasn't  been  modified since yesterday   and everything was working fine. 

Hi, I have a readonly grid and loading the data using RecordType.  When select any row selected, I am storing into a local variable of specific type. When I try to load the value of firstname like below, it was not loading any thing into the textfield. Can someone advise what went wrong.

once submit button is clicked .. a diologue box /pop box should open iwth cancel and submit button  ..  consist of dropdown "Yes " "NO"if user selects yes then user picker field should open ,, So how shud i achieve this in appian.. through record action or some other way ?

can we show any icon after label ... with caption

Hello, I have a record type with n number of values. The serial number is also saved. For eg, there is an editable grid. with the serial number as 1,2,3,4. Now i can delete any row and hence the serial number should get updated.   How to do this in saveinto of that delete button? I tried using foreach, but im doing some syntax error. Can you tell me any alternative?

Hi,  I have Process Model with user Input Task, I am assigning task For Task Approver if that task Approver Not Approve that task In 24 hours, that task was automatically Approved After 24 Hours. How I can  achieve this  Thanks  Prashanth  

HI , I have a jira integration requirement and need to call jira from appian  to create epic,story and read few data from jira. To handle integration errors and maintaining each jira int call before and after maintaining the logging in DB. Instead of having  the error handling and logging in each of every process model , thinking to have a common routing process based on dynamic parameter  it should that process  and  since error handling and logging db and email notifications are in common process no need to have in sub process alone. with this redundant code is reduced and can be used for any other workflow later since it is a common component. what is the best approach for this  Thanks Soujanya

Hello, I'm working right now on increase the performance of my project and I'm been searching what could I do, in the academy the suggestions are, to replace subprocess for Startprocess etc. Well, I have a few question that I could testing but i want to hear if anyone has this answers. 1: in a process model, if I put 3 script task with diferent action, does anyone knows if its better to put all in 1 script or is the same?  2: which is faster, put multiple nodes of smart service to Write no DSE or put 1 of Write to multipleDatastore? 3: I have seen multiple flows that do not need to wait for the previous node, is it viable to use the "AND" GATEWAY to execute multiple nodes at the same time and this shorten the time or has that affect the performance of the process?

Hi Guys,       I had some react Ui application I want to use it in the Appian interface how can I do that? without custom plugin is there any anyway? Many thanks in advance

Is there a way to use ReactJS UI components in Appian?

Hi there, right now in Appian what I know is that if we need to go to certain record, we have to keep clicking ">" until we get there.  Could anyone let me know how to implement the page drop down, so we can directly get to the record by choosing the page?   Regards, Lin

Hi All, I have multiple sections where the user can upload document and for each section we have "add document" button like below, I have to validate for document size if it is more than 10MB,and this validation is for add document button.I am not getting how to validate the document based on index using fv!files. Because of this,if user adds more than 10MB in 1st sec and adds less than 10 MB in 2nd sec,for both section it validates for "Add Document" button. Please help me how to resolve this.

Where to set reply-to in send email smart service?

Hi Appian People! I have this code that split the value inside the CDT. So for example I have a CTD: 'type!{urn:com:appian:types}T_Sample'(  name: "Person",   place: "City1,City2,City3"   ) When splitting the value, the output should be like this in an array form: Expected: ["Person"; "City1,City2, City3"] But the actual result I got is:  ["Person"; "City1"; "City2; "City3"] the place where split in different index where it shouldn't be. This is my current code local!splittedCDT:split( stripwith( tostring( ri!cdtVal ), "[] " ), "," ) local!updatedVal: a!forEach( items: local!splittedCDT, expression: replace(fv!item, 0, find("=", fv!item, 0), "") ), Is anyone could help me with this? Thank You ahead.

Can anyone please tell what does value column denotes for row 2 and 3 from the above image(Appian Health Check Report). In row two value is mentioned as 616383, Is that something related to total memory consumed or something else?

Hi, I am using a Navigation (Lightweight) pattern. When the user clicks on the left menu for example 2nd menu item, I am able to load the respective page. But, when I try to save the data on the 2nd menu item page, after saving it is loading the first menu item page. It is not staying in the same page. Any advises here please.

I have an interface with some dropdowns  The idea is the user selects a drop down which then informs the next drop down list.i.e. drop down one changes the list shown in dropdown two - thats fine and working well,The issue I appear to be having is getting the rule input value to change at the same time for the second drop down (values are expression rule driven) it appears to only update a step late for example if the user selects xyz and this is value of 27 then the ruleInput value will not update until the user changes the selected value to say abc with a value of 88 and then the rule input updates to 27!!! My real annoyance with this is the local variables show the correct values which means that for whatever reason this is not being pulled into the Rule Input at the same time!!!I have taken the time to reconstruct this issue without any specifics below: - Rule inputs: "dropOneRI" as in int"dropTwoRI" as an int"problem" as an int a!localVariab

I know that Appian may not be the best environment for this, but I'm wondering if this is possible. It is possible to create a simple shopping site using Appian? The table design is simple enough: CATEGORY- categoryId- name- description ITEMS- itemId- name- description- price LOOKUP_CATEGORY_ITEM- itemId- categoryId CUSTOMER- customerId- firstName- lastName- street1- street2- city- state- phone- email CART- customerId- itemId I've done this many times before in different languages/environments.This has MANY TO MANY, MANY TO ONE, aggregations and design/ui considerations with this project.I've deliberately ignored the payment portion/part of the project.