Foundation

Hi, I'm trying to get the French month name of the current date but I don't succeed :     datetext(local(today(), "GMT+01:00"), "MMMM"),    datetext(local(today(), "GMT+02:00"), "MMMM"),    Every timezone I'm testing returns "April", but I need "Avril". Am I using the bad timezone ? Central European Standard Time = GMT+1Central European Summer Time = GMT+2

Hi, I have a below requirement. Could someone please help me? 1. Customers claims come in an XML along with the required documents to Appian for further processing. 2.I need to have knowledge on how to read the xml and also, read the documents in Appian and save the overall information to appian DB. Thanks Faisal

Hi Everyone, I am facing an issue and I am not sure, What I am doing wrong. Here is my datasubset  { { record1: "21041001", nbr: "5DM874,C217668", recordname: {"test1", "test2"}, recordIds: {"75", "77"}, reportid: {}, selectedrecords: {}, selectedreports: {}, amount: 7.0, recordamount: {15, 15}, reportamount: {}, trecordId: 76 }, { { record2: "21041100", nbr: "5DM874,C217668", recordname: {"test3", "test4"}, recordIds: {"78", "79"}, reportid: {}, selectedrecords: {}, selectedreports: {}, amount: 7.0, recordamount: {15, 15}, reportamount: {}, trecordId: 88 } } I have an editable grid, which shows the record names in one of the column of grid from the above data subset and I ma trying to save the selected choices into "selectedrecords" parameter of above data subset using the following check box code. a!checkboxField( choiceLabels: fv!item.recordnames, choiceValues: fv!item.recordnames, value: fv!

Is it possible to have a data subset populate as a table in a Word Document (template) without using a plugin, but by using the OOTO Word Doc from Template smart service? If so, how do you configure that in the template?

Hi All, I am getting invalid cast error in process model, When i try to store data into DB getting error in Write to data store entity. How to fix this issue ?

Hi,  I have an interface with a selection grid in which multiple rows can be selected, these selected rows are saved into a ri of the CDT type. I have the requirement of capturing and storing all the unselected rows (the rows which were not selected) into a ri.  Any ways to do this?  TIA!!

how to pass updated meeting details from update meeting process  instance to a running send meeting process instance 

Hi I have a need to be able to select an XML file, and use fields in it to populate an interface. At the moment I have a simpe interface with a File Upload and a Rule Input of xmlData (Document) which the file upload saves to. I am then kicking off a process model on submit which runs a script task. I have activity class parameters for the fields I want and am running the following script on each one =xpathdocument(pv!xmlFile,"/Document/Fields/Field[@Name='Department']/@Value") Currently I just get an error on the process model when I debug: Script Task An error occurred while evaluating expression: =xpathdocument(pv!xmlFile,"/Document/Fields/Field[@Name='Department']/@Value") (Expression evaluation error at function 'xpathdocument': An error occurred while trying to parse the XML stream.) (Data Inputs) Does anyone know what the error is more specifically?  Am I on the right lines or is there a better way of doing this? 

I need to create a drop down button in the text box field. How to do that plz suggest me. Thanks in advance

Hi Team, We would like to implement website using Appian which is having Multilanguage capabilities.  The language selection should be defined by browser language. Additional languages should be configurable by additional translation files and will be added based on the utilization of the application. Currently there is something know as profile language which we are aware of which changes the Appian language  Can anyone please suggest any pointers. Regards Bihitak

Hi Team,  By mistake, I imported the wrong Appian package as an update to an existing one, Is there any way to get the old open task back?

Hello,  How I can sort this by ClientName ?

Hello community, I have a webapi that updates an instance of a process model by completing an open task. this task has a input for a main category, example {"fruit", "vegetable"} the task output: Based on input, (a decision rule is called with ac!category as a parameter).  example category("fruit), result: Apple, Banana, Orange is stored in a pv. I would like to pass the result / task output or the value of the pv as a result/response of the webapi. I tried to retrieve the result by calling an expression that gets the pv value from a process report, this doesn't work because the data is not updated yet.fv!processInfo doesn't apply here because it's not an start process api. (guess that's the reason, it doesn't work) How can I make this work? Kind Regards, Erik

Dear Community, I have a CDT by the name 'Fund' which contains a field 'amount' of type 'Number (Integer)'. Due to business reasons, now I have to change this field's type to 'Number (Decimal)' in this CDT. Which means in the backend, I have to change the datatype for this field from 'int(11)' to 'decimal(19,2)'. When I update the CDT by changing the field's data type, it creates a newer version of it. All the future process instances will reflect the newer version of CDT which is just fine. But in production, I have around 1000 process instances which has a user input task with this CDT as one of the inputs. This means all the live process instances before the deployment will continue to remain on the older version of the CDT which is 'Fund^1'. What is best / recommended / work around approach to handle the in-flight process instances in this scenario? Thanks, Arun

Hi I , have configure the Sent Receive Messages but they just stop to work. I don't think is the configuration it seems that I have conflict with it in the server, so I want to ask is there is a way by analyzing logs to see what is the issue. We are still on 18.1  with the last package for that version. BR,Natasa

Hi, I have a read only selection grid that contains records. I would like to select certain records and remove them from the grid, is this possible? How would I do it in the interface? Thanks

I have the Outputs tab of a Write to Data Store Entity setup where AC!StoredValues is stored as the process variable (PV) that I'm inputting. The data is successfully written into the DB, but the id is not saved back to the PV. I don't see a "Modify Variable" or similar activity being done after/during the Write to DSE action. As a workaround, I've made a custom output to store ac!StoredValues.id into a new pv!id. This works and I use a script to save it to the original PV. Am I missing something in my attempt to save the entire AC!StoredValues into my PV? Like does it need to be cast or only work with certain datatypes?

/*You have an array and you want to seperate by a batch of 3E.g Array: {"a", "b", "c", "d", "e", "f", "g", "h"}Expected output: { ["a", "b", "c"], [ "d", "e", "f"], ["g", "h"] }*/ a!localVariables( local!chunkSize: 3, local!startingList: { "a", "b", "c", "d", "e", "f", "g", "h" }, local!wholeListSize: length(local!startingList), local!numChunks: ceiling(local!wholeListSize / local!chunkSize), local!data: a!forEach( enumerate(local!numChunks), a!localVariables( local!currentStartIndex: fv!item * local!chunkSize + 1, /* note: this utilizes zero-index of fv!item */ local!currentIndices: enumerate(local!chunkSize) + local!currentStartIndex, /* this rule just unions the input array with itself and rejects null values */ reject( fn!isnull, index( local!startingList, local!currentIndices, null() ) )

Hi I have a related action with visibility set to true  but they are not showing up on non admin users. Do you know why this is the case?  thanks

Hi Guys, I am using Document Extraction (Google Vendor) to read data from Images present in PDF. However, Some of the Images in the PDF are titled (upside down or facing sideways). After the extraction gets completed, it is becoming very difficult for the users to see the data and click the correct field. The interface for document extraction is constant and I wanted to add a rotate button so that the users can rotate the image and click the correct field.  Is this approach feasible and yes please let me know the approach? Many thanks,

I am working to develop an application on Appian where I can send request links for third-party users where they can click on the link, fill a form, provide any supporting documents and give their approvals. I want to understand how the license structure would work in this case as these third party users would be external users to my organization and I only want to give them access (preferably just for filling the links via link) and not proper user login sessions. Please help

Hi , I have two Drop downs. I want to Select another Drop down value based on selection in different drop down. First DD will have choice label:("dev","engg","it") and choice value:(1,2,3) Second DD choice Label:  ("DevEnv","TestEnv","ProdEnv","Dev2","Dev3"), choice value :(1,2,3,4,5) Could someone help in giving me a easy solution. I am learning Appian. Thanks Faisal

I have 30 questions in a form out of which few are mandatory. If I miss any one of them and go for submit, I can get error message at the end of page (usually before submit button). It is very difficult to scroll up the page and find for the missing ques. Is there any way in where I can get an alert message in the center of the page/near the ques itself ? Please help ....

Hello all, Is it not possible to use a Rule Expression as the expression that defines the configuration of a Timer Event? We have an issue with setting up a timer based Exception Flow on a User Input task where the timer is defined as "Skip this node at the date and time specified by this expression" and the logic is implemented as a Rule Expression instead of writing it directly within the Timer event configuration. The issue that users see when the Task is loaded is "This task may have been deleted or completed by another assignee". However, when we copy the logic from the Rule Expression and paste it directly into the timer event configuration, then there is no such issue.

i everyone , i am pratik and i am trying to build one form where user can search the candidate from dropdown which is comes throw database using query rule. and on selection of that choice  i want to display the all information of that perticular person in read only component .  and after that i want to add some more component in interface and store that into other table . but when i refresh my page that time i get the below errors. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!integerField [line 42]: Invalid index (-2147483647) for list: valid range is 1..3 load( local!availableCandidates:rule!dms_query_demo(), local!selectedCandidate, local!selectedIndex, local!selectedTitle, a!formLayout( label: "Document Uploading page", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!dropdownField( label: "Class",