Foundation

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

Hi! I was creating a PO interface and I want two of the fields to appear automatically: 1) Field 1: NomProv (supplier name) - In this case, I have a record type in which a "NomProv" value (and also, the NIF number, an extra field) is assigned to each username ("usuario"). It is an static record, and I want it to make relations between the fields, and obtain the "NomProv" for each username ("usuario") To obtain the nomProv for each user logged in,  I created the following rule expression: In this case, I´m logged in as carlos.paz.pelaez@pwc.com, so it returns the value "Proveedor 2" as a test output (works fine for me) But the fact is that I want to pass this test output ("Proveedor 2") to a field in my interface so that the user cannot change it. But I dont know how to pass the rule expression output to the text field! Also, I tried to pass the value as a local variable, but it is not allowed: 2) Field 2: NIF -

I am trying to show HTML data in rich text editor but the html we are receiving from api has some hidden tags with visibility: hidden. I know that hidden items still take up space in the layout but the content is hidden. Rich text editor is not hiding those elements or tags. The data and elements inside those hidden tags are still visible in editor. Any possible way to resolve this? Also, how to make rich text editor open hyperlinks in another tab rather than in same editor window?

I'm having this issue while trying to search anything at the "all objects" search box. I don't know why this is happening only in the development environment. Can someone help me ?

Hi,  I would like to know how I can append data inside multidimensional/record or record relationship array ? Please check the example bellow append( local!sections, 'type!{urn:com:appian:types:SN}SN_DATA'(id: null) ),

Hi! I´m trying to make a simple record filter of a dropdown list, which contains a list of text. To make the dropdown, I point to a constant which contains a text array with the name of the suppliers: But the fact is that, when I try to make a simple filter, it doesn´t work. If I put a text value, nothing appears. If I try with an expression ("Proveedor 1") I have the following error: I think it´s because of the list, because the filters work properly in individual text fields. What can I do to fix it?

Hi Team, How to send an email from outlook to start a process model in Appian ? and how many ways we can achieve this ? Thanks in Advance

I am implementing a gridRowLayout. Inside the gridRowLayout I am implementing a fileUpload field.  So that I can add a new row dynamically and for each row I can upload 1 document. But the demand here is ... I cant upload same files again and again (i.e. I cant upload same files in different rows) . But I am not quite sure how to do the validation for it. Can anyone help me with this ?  This validation I have added for fileName. But as you see I could upload same files. I need validation to say that File Already Uploaded. Is there a way to do this validation ?

We have a unique user request that the user wants to submit change request to an approver group without having to close the interface and click another start process link in the read only grid. Currently the process model has a Process Start form that the user can edit changes. Here is the issue they want to send the changes to an approver group while keeping the interface page open to use a dropdown to select another entity and submit a request multiple times. Basically he users want to be able to submit change request and not have to keep going back in to the interface page from a link each time.