Discussion Categories

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

Hi All, I have made some changes in interface (adding another interface having grid values) .I have tested by passing inputs in the interface changes that I made are visible but they are not loading into process model . How can I get them into process model

I am trying to achieve a functionality where a user upload an excel then added a function to check the format of the excel file whether it matches with cdt or not. if matches, then user can proceed otherwise a hidden section layout will appear with a warning and download option for correct excel sample format but i am getting error in readexcelsheetpaging() as it shows null value error for document parameter.i try to fix it by using if condition and it solves the null error but now when i try to upload an excel file it shows other error "Interface Definition: Expression evaluation error at function 'readexcelsheetpaging' [line 2]: com.appiancorp.suiteapi.content.exceptions.InvalidContentException: Invalid Content ID".a!localVariables( local!excelFormatFromFile: readexcelsheetpaging( excelDocument: if( isnull(ri!excelFile), cons!SD_EXCELFILE, ri!excelFile ), sheetNumber: 0, paginginfo: a!pagingInfo(1, 1), numberOfColumns: 11 ).

Hi Team, I was facing some issue while querying and performing larger data such as approx 1M+ data at a time. Considered I'm querying data from approx 5 table using some filter to reduce some search results and storing in seperate variable with the help of index() function. Even I'm having more data and I'm performing approximate n time (rare case n^2 times) as looping so Appian expression rule was failing shows as one pop up with please try later in the code such approx 502, 504. Is there any limit in Appian hold particular level of data or no such limit? Anyone has any idea is there any better way to handle this larger case of data... Thanks and Regards, Vigneshkumar Radhakrishnan

Hi , How can I overcome  this error. Expression evaluation error : Cannot compare incompatible operands of type List of Variant and type Number (Integer)..index(ri!approval,"meetingId",{})=ri!meetingID //ri! approval type is on etable and array is enabled,whereas meeting id is number

I want to verify an excel file after uploading, whether the order of columns in excel file matches with CDT. for example, I have fields like PhysicsMarks,ChemistryMarks as second and third column respectively in excel file and want to ensure that this order of column matches with my cdt like if my cdt have 2nd and 3rd column as PhysicsMarks and ChemistryMarks. How can i achieve this function?

Hi All, I am creating Process Models, Process Metrics, Task Metrics Reports in the Appian. and then I am fetchiing the data from the report in the process models and using it. My query is what is the data retention period of those reports in Appian. Like how old data it could have and how can we configure this. ? and is it something manages by the APPIAN DB itself or managed by the organisation. if by the organisation than where we can find that configuraiton.. Thanks

I want a form to be popup upon click of button in UI (a form will be there to enter details and open click on button a new form needs to be displayed)