Foundation

Hi All, I'm creating an application where I have a form with an add button on it. Using this button, I want to add a row into an editable grid with recently added data. Then, using the same form, I want to add the data in the same Editable Grid in the next row. Finally, if the user clicks the submit button, all the grid data is stored in the database. Adding a row to the grid when I click the add button here I am facing the problem

Hi, I have a requirement where I need to duplicate a particular section on clicking add button. In the section I have some text fields and clicking on the "Add" button the text fields should get duplicated where I have to enter new values in the field. Is it achievable? or is there any other method where I can duplicate the fields on clicking the button ?Please let me know Thanks

i am trying to save the selected data into some local variable but it was saving as id i need full data to be save in the local or RI this is my code: a!localVariables( local!items: { a!map(id: 1, firstName: "John"), a!map(id: 2, firstName: "Michael"), a!map(id: 3, firstName: "Mary") }, local!selectedReport, local!data, a!gridLayout( headerCells: { a!gridLayoutHeaderCell(label: "Summary"), a!gridLayoutHeaderCell(label: "Qty", align: "RIGHT"), }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 5), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), }, rows: a!forEach( items: local!items, expression: { a!gridRowLayout( id: fv!index, contents: { a!textField( /* Labels are not visible in grid cells but are necessary to meet accessibility requirements */ label: "summary " & fv!index, value: fv!item.firstName, readOnly: true ), a!integerField( value: fv!item.id, readOnly: true,

Hi everyone, I would create a note entry for my application in the record details page to create a history of the actions performed by a user who accesses the following interface. I created a manual action that allows you to write these notes in an anonymous field of the record. However what I want to create is a history of these notes: from the note entry screen in the screenshot I would like that every time a note is entered the old one is no longer selectable and a new line appears in the record detail screen under the appropriate section, as depicted in the screenshot. So the result has to be like this in the record details page. What the record call does is simply an override in a field of the selected record. Thanks everyone for the help. P.S: i don't want to simply write note in a box field in the interface: this information must be visible into 2 different sites, so i have to memorize this notes somewhere in the records

Hi All, I downloaded the health check report, in that report for description column for user input task i am getting below Description. 29 calls, 1.2MB max interface, 360 max component count, 84.6KB average interface, 296 average component count. .what is the exact meaning of this description Thanks in Advance.

Hi All, If i have  two tables where possible relationship can be configured, is it better to create view from both table OR create relationship to query data from both table? Thanks in advance

Though it's an extension to below thread: https://community.appian.com/discussions/f/user-interface/20858/merged-or-nested-column-headers-in-an-editable-grid I was trying to follow the approach in above thread to achieve grid format I have attached as image in this thread post. The above logic works good but there are lots of alignment issues when grid is viewed across different environment screen like wide desktop, mobile, etc. The column widths in read only grid changes on different screens which most of the times cross the limits of above cards, for example - I have one main header "A" under this I have two headers "AA", "AB" and one more main header "B", have only one under it  "BA", when I change screen to wide the width changes and unaligns. Mostly, I see columns which should only be under "A", some part of those columns move under "B" header. Also, with paging grid, it is getting diffic

Hi All, I am trying to update data from one table to other table using execute store procedure smart service but i am getting below error while executing smart service. (conn=8566693) Incorrect string value: '\xAC\xED\x00\x05ur...' for column. can any one suggest what it is referring for.   Thanks in Advance

Hello, I'm trying to parse a pdf that contains data in a table format and table data cells contain decimal values. However, some cells are blank and contain no data. When I use getpdftext() function to parse the data, the delimiter between 2 adjacent cells and between 2 cells with a missing cell value in between is always a <space>. Due to this, I'm unable to map the correct values to the correct column/header. Let me know if someone has an approach to resolving this issue. Thanks,

Hello! I have a Form with multiple input fields, this form works well when the users are using a PC, the problems start when they use Smartphones. If the users uses the phone in LandScape View: It all goes well: And then i tap in "Ofertar": But whe i use the smartphone in VerticalView: This happens: Then i tap "Ofertar": The value gets inverted its showing 999991 instead of 199999.

Hi everyone, I would like to know if files in appian folders are deleted by default (and if so, how often) or not. Also is it possible to change this time setting if there is? Is it possible to find any related documentation on this part? Thanks all in advance.

Multiple Excel formulas are not working. For example xlookup when used is not giving value in preview mode means data is not going to the database hence output also not generated properly.

Hi Champs, I want to have a card with Background color as shown in Below image. I tried achieving the same using tag field as I am unable to use card layout in grid column. But the issue is that all the tags are coming in diff width bases on the text size. I am unable to set fixed width for that which is not matching with UI design as shown below. Is there any other way I can achieve this apart from using tag component which will fulfil the use case as per UX framework? Regards, Ghanashyam

I added a tab component to an interface I was building and added 4 additional tabs to the 3 that come with it automatically. I had all 7 formatted the same and working perfectly fine as each was clicked. However, I discovered that I had missed a needed tab that meant to go in the 5th slot, so I added another tab, moved it up to the 5th spot in the component configuration section, and then went through that it along with the 3 that moved down were all updated and formatted correctly. Now however, when clicking through the tabs, only the first 4 tabs become selected and show their given information below it, the new tab along with the others that moved down the list are selectable now, clicking on them just updates the page but does not change the selected button. I've been through the code and everything looks as it should I think, does anyone have any thoughts why it wouldn't be working now? Coding for the tabs: a!localVariables( local!selectedTab: 1,

I have a dropdown field   called "Name" which has 3 values chintan, mantan and other when the user selects other, a text field will be visible in which he can fill the other name. the value entered in text field (other name)should get saved into name field  how can I achieve this?

I have a dynamic link in my code and I want to increment the link as soon as we click on that link icon and value should display below that icon. For Example: initially icon link value should be 0 and once I click on that icon link value should get updated to 1. Can you help me how to achieve this? a!localVariables( local!pagingInfoWell: a!pagingInfo( startIndex: 1, batchSize: 4, sort: a!sortInfo( field: 'recordType!{78f32b7c-4150-4c84-baf2-6b2d421a715d}RB Retro Note.fields.{5021c120-a5cf-4752-85fe-a3268542bc23}id', ascending: false() ) ), local!pagingInfoImproved: a!pagingInfo( startIndex: 1, batchSize: 4, sort: a!sortInfo( field: 'recordType!{78f32b7c-4150-4c84-baf2-6b2d421a715d}RB Retro Note.fields.{5021c120-a5cf-4752-85fe-a3268542bc23}id', ascending: false() ) ), local!refresh: a!refreshVariable( value: cons!RB_RETRO_REFRESH_COUNT, refreshAlways: true() ), local!retroNotesWell: a!refreshVariable(

Hi! I want to display in a text field of an interface a value of another record. The fact is that, if I introduce it manually (ri!record1....), the field name appears correctly, but can´t be used in my process model (error). If I enter all manually, it works. What can be happening? The fields with arrows are introduced manually and work okay. The others dont even though they appear

Hi, I'm very new to Appian and postgresql. I'm trying to explore how to connect these two and I came across "Create Connected System". Could someone please guide me in order to establish some sort of connectivity it'll be greatly appreciated. Sharing both here. 

I am trying to set up a related action that will allow me to add a new record, but copy all the attributes of the record that I am currently on. Currently I can only get it to update the current record. I think I need to remove the primary key that is present before writing the new record, but Im not sure. Example: I have a list of record type: vehicles. I want to be able to go to vehicle 1, click Copy, and then save, and it created vehicle 2.  vehicle 1 [ color: black year: 2019 ] vehicle 2 [ color: black year: 2019 ]

Hi,  I have a paragraph field. I need to hardcode a value, with the below code, the user can change the value. When I used the a!richtextdisplayfield, I was getting an error.  Can someone pls guide here.  a!paragraphField( label: "Rejection Comment",value: "REJECTION " & local!comment, saveInto:  local!comment,)

Hi,  I imported the SFTP plug-in from the app market, and while running this, I'm getting an error stating "An error occurred in executing an Activity Class". Here i. I have given the FT_coniguration code which  I wrote referring to the documentation. ={ hostname:"eu-central-1.sftpcloud.io", username:"ef87e78f37c646ca8056eabdce3f86e7",password:"cjunTmFzmlfuuANjI8Xt2afAzeuJ4mno",port:22, timeout:60, appianexternalKey:"secure-credentials-store"} ii. all the declared variable iii. this is the process model trying to retrieve the files from the server, adding a file, and trying to download the same file. But I'm getting errors at the rach phase of executions. can you please help me to resolve the errors and make the process model execute? Thanks in advance.

Hello, I have a requirement where I have to save the user state of the interface/page into DB and load it back when user comes back to that interface/page. For example, if the interface has tabs, then I want to save the active tab the user is looking at into DB and restart the interface with that tab selected when user comes back. This could be extended to the filters user has chosen, etc. This requirement came from a scenario where I have a dashboard with a table with startProcess links in each row, when user clicks on once row the startProcess opens up a form in the same tab. Once the user completes the work and comes back to dashboard, I want to maintain the state of the UI as it was when he/she triggered the startProcess. I could create required writeToDataStoreEntity and get page state queries. I found that these have to be used in every saveInto of the element whose state I want to store. This is cumbersome and bloats the expression in the interface. Another s

Hi! I have two records with different record actions in separated process models (create purchase order vs create invoice). In this case, I would like to be able to initiate the process of invoice creation based on the purchase order data (id, supplier, and other data passed automatically to the create invoice interface) My trouble here is that I need to do this from the summary view for each purchase order ID (until now I had a different action in each record view).  I was thinking about creating a button in the summary view, but I don´t know how to pass the variables in a correct way or the best practice here. Which options do you recommend? Creating a button and link it to the proccess model to create the invoice? Create a related action? My process steps would be something like this: 1) User clicks in the summary view of the purchase order 2) In the summary view, there should appear a button to make an invoice with the PO data 3) The data collected should flow to

We are looking for chat window to record/type it and  save for the particular case(on summary and other related action screens). Example: As like chatbot screen, but just to type the detailed description and click save it. Its more about log save window. Is there any functionality or interface that supports in Appian?

Hello All, We need to show the generated docs in the interface, and if there is any error in the document generation need to show an error to the user. Document creation takes time so we created the PM to generate the document and used the process report for the generate document process model. We are using queryProcessAnalytics in the interface with a refresh variable to check the "generate document" process status. We need to stop re-querying the queryProcessAnalytics if any error is received from the process report, used the below code to achieve this. local!processReportData: a!refreshVariable( value: if( true(), /*Some conditions*/ a!queryProcessAnalytics( report: <<process report>>, contextProcessModels: <<process model to be checked>> query: a!query( /*c1 - processStatus (1=Completed)c3 - process Idc6 - errorMessage*/ logicalExpression: a!queryLogicalExpression( operator: "AND", filters: a!queryFilter( field: &quot