Foundation

Hi there, We have a requirement where we are calling  an API on tab out of field. If we have 20 fields 20 API calls will happen and in the payload we are every sending field. I know calling a integration in saveInto is asynchronous ,but loading will complete when all saveintos are executed.Is there any way to optimize it, because latency is very high (It is taking around 1 min to complete the loading). can we make it truly async like React or js based applications?

How to apply sort on the data that we get from  executestoredprocedure() while displaying on read only Grid?

Hi everyone, I have an interface which displays a list of documents (UI_ListOfDocument), and originally user need to choose one document in the list to preview it (UI_Preview  will be displayed accordingly showing that chosen document's content), then click back to the list to choose another document for preview.  The request is to create a pagination in the existing interface, so that user just needs to click the pagination buttons to see the next/ previous document preview. I already built the interface for the pagination, but was having trouble in linking the document to it to make it work.  Currently, all related document from the data table are queried using a!queryEntity(), and are saved in a local variable, including it's content.  If anyone has done this before, please leave an advise if possible. Thanks for your helps [emoticon:6d505171faa4497c85c5ca27290c555d]

Hi, Can anyone let me know the following regarding rdbms logs? I can see multiple rdbms logs created for a day, will these files merged before they are converted to .gz at 11:59 PM when exactly does the merging happen?

In the editable grid I want to add 2 rows on click of add row link, please help me out how to add dt ?

In an interface intially we didnt use this field for file upload and it displayed like below , all the upload buttons are greyed out. Later we used Disabled : false() for the same fileUpload and the out come is as below, upload button is enabled By default as it should be false and the upload should be enabled,but it was grayed out. Can anyone explain why it was like this

I have this stored procedure output where the column names are dynamic and may vary according to date range and the column names also have to be printed in the interface in Appian So can anyone help me with the way to print the field names in a dynamic way?

while trying to generate excel through smart node - EXPORT SQL to EXCEL,   i am getting the below error in process - The following error was raised by the Export to Excel function: Attempting to write a row[1] in the range [0,5] that is already written to disk.  And getting the below error in interface - {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An Error Has Occurred"}  

Hi Everyone, I have a read only grid which is connected to Pie chart. When I open the report it should show all the rows with the selected filter but it is empty as below. When I click on any slice in pie chart, the grid is displaying the respective rows  These are filter options I have used in my grid configuration Please help me how to all the rows with selected filter (isresigned)  in the read-only grid when opening the report. 

I ran into small copy and paste typo in Appian 22.3 docs. Don't know where to submit this, I know it's not really a question. Hope someone can route this to right team correct it.  https://docs.appian.com/suite/help/22.3/Oauth_connected_system.html  https://docs.appian.com/suite/help/22.3/oauth_client_credentials.htmlIn this case it think it should mention Client Credentials Grant instead of Authorization Code grant. 

Hi All I am currently working on version 22.3!! I have a use case wherein one of my current process is started when an external system sends email on the process model id i.e.: processmodel<id>@companydev.appiancloud.com( here dev represents the Appian environment). The requirement is that:The system can receive external mails using company's SMTP i.e. @company.com rather than @companydev.appiancloud.com.  Would like to know is there a way I can do this? I have read the the topic "Legacy configurations" in the link below but I am not able to understand what does reply-to-address means and will it even help me in my problem: https://docs.appian.com/suite/help/22.3/Sending_an_Email_Message_to_a_Process.html#starting-a-process-using-an-email Thanks in advance!!

I have a string "a,b,c" I want to convert that to array of string.

Hi everyone, I'm having above error message after using a!todatasubset(), my code is as below:  local!pagingInfo: a!pagingInfo( 1, 1, a!sortInfo( field: local!emailsRelatedToCase.id, ascending: false ) ), local!datasubset: todatasubset(local!emailsRelatedToCase,local!pagingInfo ), within that, local!emailsRelatedToCase stores data queried from a database to get email IDs and relatedCaseId, sentFrom, sentTo, dateTime for each email. Did anyone see this error before? Thanks a lot,

hi, I want to Complete the empty space to save space, what are the best practices?

I have a read-only grid which should show all the rows with filter (isResigned) when I open the report. Along with that I have pie-chart in the same report based on last working date. So, now when I click on pie chart the read-only grid should be updated based on my selection.  I am able to get the full report with filter isResigned but when I select the column the read only grid is not getting updated.

Hi, I have setup a timer to run "Daily" and "Every weekday" at 4 PM. This should trigger a email notification. But, I am receiving an email notification on every day at 5:30 AM EST.

a!localVariables( local!data:rule!VG_CRK_RT_get_all_srvc_nm(), local!exportDocId, local!errorMessage, local!flag:false(), a!formLayout( label: "", contents: { a!sectionLayout( label: "", contents: { a!radioButtonField( label: "Select Any Option", labelPosition: "ABOVE", instructions: "", helpTooltip: "Before Uploading, Download a file for service, to view latest data", choiceLabels: {"Download", "Upload"}, choiceValues: {false(),true()}, value: ri!isUpload, saveInto: {ri!isUpload}, required: true, choiceLayout: "STACKED", validations: {} ) } ), a!richTextDisplayField( labelPosition: "COLLAPSED", value: { "Before Uploading, Download a file for service, to view latest data" } ), a!dropdownField( label: "Service Name",

how to validate a text field which can be  A,B,C,D, Null, or groups of A,B,C,D (ex. ‘A,B,C’ with commas no space).

I have table by name abc which have columns id(pk),refId(FK),uniqueId,languageId,locationhere language Id is : id for languages ex: english =1 , french=2, hindi=3 etc unique id is: if say for refId(fk) there are 5 location then unique id is 1,2,3,4,5 for language id 1, unique id is 1,2,3,4,5 for language id 2, unique id is 1,2,3,4,5 for language id 3 etc so here my requirement is based on selection of ref Id I want to add location using grid but here challenge is user can allow to add location in all available languages and need to maintain uniqueid's same.one thing need to consider is unique Id should be the next number to existing unique id for that particular refId.Please do help, am struggling to implement it.                                                                        &

In a gridField() fed by record data, when you try to use the disableRowSelectionWhen param, record references fail to be evaluated. As an example, we were trying to disable row selection based on a date time in the record data. Originally we had it wrapped in a todate() so we could compare it to a date, but the logic was failing to disable the desired rows. Just for fun we removed the todate() around the record field reference, only to be smacked with an error about not being able to compare Null to a date. That's right, the record reference evaluated to Null. For more fun, we tried using fields that were not dates, and the same thing happened on integer fields, i.e. the record reference evaluated to Null. Has anyone else run into this? 

HI All,  I have SAIL form with summary details and  a grid.  i have a add card layout button above the grid which will open different process to add data. when Calling Process model using a!StartPRocessLink service under add button(card layout) from Parent Sail form which mostly read-only info. when i click on Add button , i receiving a message saying you would like to leave from this page., looks like its browser message.  navigate to chained forms/process model and once added data its expected to come back to same form. Please suggest how can i avoid such message, Thanks in advance.

how to redirect to site record page by using record link. a!linkField( links: a!recordLink( label: fv!row['recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type.fields.{986b4d5b-200e-4665-a365-33808cab1533}name'], recordType: 'recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type', identifier: fv!identifier, dashboard: "summary", openLinkIn: "NEW_TAB" ) )

only document id shown  is there any changes in Interface ?

How do i start a process from Email by assigning Receive message event by sending a mail to my process model UUID the process should start!