Discussion Categories

Hello, I'm trying to figure out how we can set up alerts based on the metrics in our Health Cloud Metrics reports. For example, we're able to see the CPU Utilization metrics to the servers that are hosted in Appian. How can we set up an alarm/notification to alert my team when it hits a 90% threshold?

a!recordFilterList( name: "Employee Name", options: a!forEach( items: local!data, expression: a!recordFilterListOption( id: fv!index, name: rule!CMN_PLATTS_GetUserFullName(fv!item.employeeName), filter: a!queryFilter( field: 'recordType!{c3db295c-a167-41fc-84b6-90d578db6968}Employee.fields.{employeeName}employeeName', operator: "=", value: fv!item.employeeName ) ) ), allowMultipleSelections: true() )

Hello, ALL. Can someone Just give me a step-by-step about How to insert data into a DB from a site? I Just trying during ALL the day nd dont know How to do.

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

Hi , I have list of arrays coming from foreach, now i want unique elements for the list of arrays. for example localvariables( local!arrays:foreach( items:{5,6,7}, expresssion:enumerate(fv!item)+1 ) local!arrays ). form this output,  i want unique elements from the list of arrays. can anyone help me in this? intersection is working only for separate arrays stored in each local variable but not for arrays executed in foreach.

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.

The main question is about how Appian cache the data when you relate a record type to database tables. Also does this cache mechanism provided when you relate a record type to database views. 

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

Hi Guys Is it possible to run mulitple instances of Write Records smart service as a single transaction, i.e. if one of the instances fails, all updates made by previous instances are rolled back? According to docs, Records can only be updated for one record type at a time (https://docs.appian.com/suite/help/23.1/Write_Records_Smart_Service.html) So say I have a record type representing a bank account. And I have a process model to transfer money from one account to another. The high-level steps are: 1) Update balance of account 1 (deduct the amount) 2) Update balance of account 2 (add the amount) If step 2 fails, account 1 will be charged, but nothing will be added to account 2. If there is no option to run the 2 actions as a transaction, what is the best practice for handling such cases?

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, When I try to export the entire application code, we are encountering the below error. Not sure what might have caused the issue. Any advises, please. group 99 _e-0000c90c-c915-8000-4e54-011a94011e94_199: The data for group [id=99 _e-0000c90c-c915-8000-4e54-011a94011e94_199] could not be retrieved for export. Cause: Insufficient permission (APNX-1-4071-002)

Hello, I am new to Appian. I have a user input form and a pre-populated database. What I want to achieve here is, after the user submits the form, in the process model, both sides of the data will be checked, and if the data matches, the process model will generate a specific document including those data Thank you in advance

Hi, all! I just prepared my site to get data nd put It inside a ri! to send to a table at DB, i tested at model process and just worked good, but when I try to do on the site give the follow problem. Can someone help? I really need make it works.

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"

local!excelFormatFromFile: readexcelsheetpaging( excelDocument: ri!excelFile, sheetNumber: 0, paginginfo: a!pagingInfo(1,1), numberOfColumns: 11 ).data.values[1] Hi, How can i achieve same result using index function instead of using ".data.values[1]"

Hi everyone,  I need to export the data contained in a Read Only grid with variable Data Source, therefore I cannot use the default Export functionality available for Record and entity based grids. My grid can have two sources of data, one being the default columns I have on the report on which it is based and/or one or more columns that users can select with a UI we made. The grid then can have a mix of Report and Database data source. I tried the exportProcessReportToExcel function, but it only works with the data and columns set on the report. I'm looking for a way to export to Excel the whole content of the grid, whether it is an OTB function or a plugin. Thank you very much in advance. 

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. 

Hi All,I have multiple individual excel files and i have a requirement that each file should be made aa a sheets in a  new single excel file.is there any plug-in/way to achieve this ? Thanks in Advance,SSP

Hi All, We are using  PDF from Single DOCX (with Fonts)  to conver a word into a PDF , After conversion it gives a extra solid lines randomly which is not there in the actual template Template :  Document: Thanks In Advance

Hi, Values are loading into process variable of process model but they are not visible in the form .How can I get them into the form Many thanks in advance