Foundation

let me know if somebdy knows the reason

I have a grid as below. The thing is it is populating the country(s) column wrongly. India should be in third row, Mexico should be 2nd row and Saudi Arabia and Bangladesh should be in first row. The data we are passing is stored in the local variables and rule input correctly. But something is going wrong with the code to populate the grid column value. The code for grid column to populate Country(s) is below. Please help me in storing the correct values in to the grid. a!gridTextColumn( label: "Country(s)", field: "country_txt", data: if( rule!APN_isBlank(index(local!gridData, "data", {})), {}, tostring( sorttextarray( stringArray: stripwith( split( index( index(local!gridData, "data", {}), "country_txt",

Hi all, Does anyone have good success with process model upgrades from an older version to the new version, and if yes are there any consideration to keep in mind for the upgrade, on what works, what doesnt work etc?

Hello, I am exporting a table on a button click and I want to give download link for the latest exported excel document. So when I click on "Generate Excel" button, It should export a table and then update the download link for the latest document. How can I achieve this on one interface.  Thanks in advance!

How can we call a link in buttonWidget?

A form has 5 rule inputs ,as follows: > 1cdt variable > 3 text variables > 1 integer variable According to best practices,how many process variables are required in the process model's user input task Options 1) 1 2) 3 3) 5 4) 6

Hi, I want to add a Safelink in buttonWidget, is there anyway to do this?

Hi All, Requirement:                     I have a use case where I have to get documents from target environment to source environment. Information:                     I have list of appian documents id in my source environment database. Approach: ->  I have developed a web api in target environment , it will return document based on appian document id. -> I have designed a process model , In which I am getting appian documents id from table and calling target webapi using integration object. It was working fine and getting documents as i expected. Inputs required : Which way is better among below two approaches. 1) Getting appian documents id's as a batches ,using MNI  and pass it to sub process having integration call logic  2) Looping approach . I don't have enough information about number of appian documents id's to process , Please share your

Hi All , Hope you doing  well.  "My scenario is that I worked on a Card layout. Within the Card layout, I have some text fields. Initially, the Card layout has a predefined color. My task is to change the color of the Card layout when any value is entered into the text field. Can anyone help me out?"

Hi All, What is the use of using a!save in save into of interface.Is there any clarification on this? Thanks

HI I'm getting an error while creating a form  Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!imageField [line 60]: The image at index 1 in an image gallery component [label=""] has an invalid value for "document". "document" must not be null. Please help me

Hi there, I've got a business needs where I have 2 records types (let's call them RT1 and RT2). RT1 has a one-to-many relationship with RT2 and I need to display a grid where my row would be RT1, in which the first 5 columns would be property of RT1 while the following columns would be dynamically added based on possible values of RT2, this mean the number of columns would be equal to the number of properties of RT1 + the number of possible values for RT2. This could give something like :  Name Color Brand Model Places Feat1 Feat2 Feat3 Feat4 Feat5 XYZ Blue Ford GT 2 1000 200 500 1500 600 ABC Red Mazda CX-9 7 2500 3000 What would be the best architecture to build that?

Hi All , I have a very strange scenario . I have created an Interface which shows Data in Editable Grid, I want to Export this Data into an Excel File. In order to Export the Excel File , I have created a Process Model which stores the required document into One Document Folder.Now, I want to have a link to download that particular file.I am able to do everything , While testing Interface , I am getting output of process variable ( i.e. the Exported Document) but when I am using that Interface in Site I am not getting output from Process Model.Here is the image of Process Model: a!startProcess( processModel: cons!MBUA_PM_EXPORTEXCEL, processParameters: { gridData: ri!excelData, }, onSuccess: a!save( ri!document, fv!processInfo.pv.exportedExcel ) )Here is the code which I have used for Starting this Process Model.

Hi, I am getting an error when I click on any dynamic link or button in my task (with no submit). I only have this error when I access the task from the mobile application, from the browser everything works correctly. The error is "An error was encountered while processing your request", and I don't know how to get more information about it, maybe in the STDOUT log? I have deleted any operation in saveInto for testing, and I still have the problem, It seems that it is simply by clicking Could someone explain to me what could be happening? Thanks and regards

I want to generate an XML file where each columns are created with different rules defined from multiple tables. How to achieve this?

Hi All, We have build an application wherein we have some DB calls happening on the main page and then there is a a!startProcessLink() action configured to modify any data. Everything is working correctly but as soon as a!startProcessLink() is completed, the main interface reloads causing every DB calls to re-execute. We know this can be handled properly via recordType but as per our requirement that is not the suitable option. Can anyone suggest how we can stop making these extra calls if possible? Thanks in advance

Hello everyone I noticed that  HTML to PDF smart service dose not  support Arabic language ? The PDF form Shown as the following page  is there any solution for that? or is there another plug-in that does support Arabic language for pdf? I also tried to use different Font types, all give the same problem! NOTE: I am using Advanced Rich Text for Tables and very large paragraph.

I have a table in particular sheet of excel file and the cell are all bordered for them till next 50 cells but when i try to read cell after 50 in that column it breaks just because of the below cells are not bordered. Can you please help me with the same excelreadcellsbynumber( excelDoc: ri!document, sheetNumber: { 2 }, columnNumbers: { 7 }, rowNumbers: { enumerate( 100 ) + 89 } ) Error: Expression evaluation error at function 'excelreadcellsbynumber' [line 36]: above expression breaks and the below one works  excelreadcellsbynumber( excelDoc: ri!document, sheetNumber: { 2 }, columnNumbers: { 7 }, rowNumbers: { enumerate(50 ) + 89 } ) only difference i can spot is the cells after 50 from cell line are all bordered. and when i border all those extra cells it starts working. Please suggest, if this is expected behavior or  am i doing something wrong

When a user adds a text value to a floating point field, Appian displays a validation message by default. However, when the user clicks the refresh button in the same UI, all validations should be cleared and the fields should be reset. Unfortunately, Appian's default validations are not refreshing properly in this scenario. Is there a solution to refresh the validations after clicking the button in the same UI, without using record actions?

is there any guidance for Associate developer interview i have passed certification of associate developer

Hi Champs, I have a portal having milestone section. I have a landing page and once user click the "Start Application button" in landing page, the milestone starts. In each of the page, I have a option to proceed next, back and cancel button. There are some mandatory fields in each of the pages without which the page won't proceed ahead and gives the validation message. It's working fine; but there is one issue. When I am cancelling the form, it's coming back to landing page and then when I am clicking next, automatically it's showing the mandatory field validation without even user clicking the next button. How can I reset it, so that it will only show the message when user click the next button only. Regards, Ghanashyam

Can we extract data from sail code to java code:Example : Sailcode present in xml file under definition tag <definition>a!localVariables( #"SYSTEM_SYSRULES_sectionLayout_v1"( contents:{ #"SYSTEM_SYSRULES_richTextDisplayField"( value: { #"SYSTEM_SYSRULES_richTextItem_v1"( text: "Click here to display Case(s) Information", link: #"SYSTEM_SYSRULES_safeLink"( label: "Company web site", uri: "">http://www.appian.com" ) ) } ) } ) )</definition>into java object to get data of text : "Click here to display case)s) information", link label :"Company web" , link uri :"http"//wwww.appian.com"

Hi while user trying to access the task was getting the UI error like below but i am accessing with service account i am not getting error like below checked the security of document and folder everything seems fine please suggest on this  Error Error Evaluating UI Expression Expression evaluation error [evaluation ID = c9b13:9d17a] in rule 'dm_attachmentreviewsection' (called by rule 'dm_executiontaskfor') at function 'document' [line 27]: User Does Not Have Rights to Perform this Operation 

Hello, 1.- I have a dynamic interface that show some data depending on rule input variables. 2.- In this interface I have a a!startProcessLink that execute a PMO with interfaces in it so the user is sent out of the first interface. 3.-Problem: When the PMO is finished the previous interface is shown with default values and I want to show it with the values it had before the PMO was executed. Is there any posiibility to solve this problem?

Is it possible to update the expiry time of an Appian task dynamically every time it is accessed? The initial expiry time should be set to 1 hour when the task is triggered, and the expiry time should reset to 1 hour every time the task screen is accessed?  I expect a smart service kind of a function to update the expiry time of a existing task which can help in the scenario. Your suggestions please.