Foundation

Objective: copy data from Process model properties and store the old data copy into same table(Multiple of updates done using interface) before new data update. I have "process start form" tab with - Update_Ticket_Interface This interface to update ticket on selecting table row Interface shows details to update ticket. Here, want to copy available data into a variable before form submit/update.  How to copy data from Process Model properties variable tab? Here, i am able to update only one record, not sure how to use process model to get copy of old data to store into same DB. i have process model as, Inputtask-startNode --> Write To Data Store Node -->End node In below screenshot, i There are two variables, PTS_TicketTest(For record Update-working) & PrevData(ForRecordOldDataCopy-GettingNull) PrevData tried to store in another Write To Data Store but getting null data, as PrevData didn't get data. Please let me know if any clarity needed. 

Hello,I'm using Export Data Entity to CSV smart service. This gives me CSV output and the CSV has a column named TransId, this column/field is a varchar in Appian.It may contain text and/or sometimes just integer numbers more than 11 digits.The problem here is when the value of this column is more than 11 digits then CSV by default shows value in a scientific format like 1.12233E+13 until the cell of the CSV is formatted to Integer.Is there a way to get the value correctly by default?(This smart service does not have input to take template unlike 'Export CDT to Excel' smart service).

Hi, I have an application developed in angular and java and have around 6 work flows, i want to implement workflows in appian without distrubing angular ui and java,  is this possible in appian , if possible how can u achieve.

I have a customer requirement to allow the users of the application to individually control which columns of information they see on the screen for a given interface. The application will have a default column sequence and that's what every user gets initially. Then each user will have the ability to: Reorder the columns Hide columns from the display Add columns back into the grid that were previously hidden Reset the grid back to the default columns in sequence Anyone have some example code to try and deal with this situation? I'm open to any approaches.

Is it possible to pass the username in a link to site so that the user does not have to key it in, and just provide the password ? 

I have a read-only grid in interface A, and one of the columns populates more than one value. The functionality also includes an expander and each value is linked to its respective record. Below is the code for that particular column. I would like to replicate this functionality in an existing interface B. My concern is that the interface B I am working in has a Paging Grid / Text Column and Interface A has a read-only grid/grid column.  Interface A column code: a!gridColumn( label: "Transit Agency", sortField: "transit_agency_name", value: a!localVariables( local!rowTransitAgencies: index( local!vanpoolTransitAgencies, wherecontains( fv!row.vanpool_id, index( local!vanpoolTransitAgencies, "vanpool_id", {} ) ), {} ), local!rowTrasitAgencyCount: count(local!rowTransitAgencies), local!showPartial: if(local!rowTrasitAgencyCount > 1, true, false), if( local!showPartial, a!richTextDisplayField( value: { a!richTextItem( text: left(fv!row.transit_agency_n

Is there any function to show pop-up in interface ?

I have a Payment screen where lot of calculations are done on the basis of some input and logic. The payment amount can not have more than 2 decimal precision. It is getting handled on UI .But while doing calculation some times values are giving exponential value or some invalid value which should not be the output. How to handle that, Should round function should be used or not. ?

I have two drop down filter and from  date and to date field . I need to configure search button so that based on it data come in grid. Can someone help with this. Data is coming from database and have configured the grid but the search button is not working. Can someone help or provide relevant link. Thanks

hi,  I'm looking for something to refresh variable every one secound,  I was try "a!refreshVariable()", but it dose not make refresh less than 30 secound

Hello All, I have 2 table, All fields from Table2 automatically populated from Table1  but if any changes made in Table2 fields the data should Display in Table2. Can Anyone help me with? Thanks in Advance

Interface Definition: Expression evaluation error at function a!gridField [line 167]: Only list arguments are allowed need quick suggestion !

Hello, News, Tasks tab of Tempo not displaying data . can you suggest any solution to over come Thanks in Advance..

Hi All, I am able to update one entry of a ticket. In process model, I have update Form view with populated data; i need to store copy as old version i.e. before submit/save using process model as per below screenshot, How to achieve this? Finally, i want to get list of all updates done previously for a given ticket number and show in table grid view. I guess before submit/save i need to add some node.to insert data before save data Thanks, Deepak

Hello, We are looking for Appian developers (Contract to hire). We are IT Consulting company and Appian partner located in Houston, Texas. If you are interested, please message me with your contact information. Thank you Tomas Fischer

Hi all, We want to import an excel/csv file from the file system in the same machine in which Appian runs. Do we need a plugin for that? We can use SFTP services or any other plugin but I wanted to know if Appian offers somethign out of the box. When I look at the excel tools that we have in place they expect that the file is already in the Appian internal DMS. what I have seen so far is that we can use collab filesystem utilities or SFTP utilities. It seems that Appian does not offer something out of the box yet. I am tempted to use the collab filesystem utilities because as far as I know the SFTP utilities require a SFTP client installed in the machine. Any recommendation?

Hello community, I have a problem with multipleDropdownField component that should show the list of options depending on the list of selected items in another multipleDropdownField. Then based on selection data should be displayed in Grid. Can someone help the code.

Hi, I have created a view to display it in read only grid.  There is huge amount of data that needs to be retrieved and displayed. But when am writing simple query to fetch data am getting error: a!queryEntity( entity: cons!AB_DE_V_DD, query: a!query( pagingInfo: if( rule!APN_isEmpty( ri!pagingInfo ), a!pagingInfo( startIndex: 1, batchSize: 50 ), ri!pagingInfo ) ) ) Error: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Can someone help to sort this issue. Note: When am using filter to retrieve data, am not getting any error

I tried to hide some components inside interface when the user logged in from a phone, and test it usnig appian mobile application, but it still show the components while the user is using the mobile applcation

We are in need to use mobile push notifications notifications on certain events, but the issue is that we are on on-premise environment and Mobile push notifications are only available on Appian Cloud. Is there any suggestions or other ways to achieve the mobile push notifications service in self-hosted or on-premise ?

I am using below logic to convert and display  Source  location ID to Source Location name in Read only grid but when am using same logic while downloading Excel sheet. Its providing me  Source location ID instead of Source Location name. Is there any way how i can get Source Location name in Excel Sheet. a!gridColumn( label: "Source Location", sortField: "SourceLocation", value: { rule!ABC_DE_getLocationNameBasedOnLocationId( locationId: fv!row.collectionfromlocationid ) },

Hi All, Objective: Get History details of selected Ticket Number from table row. Process Model: Step1: Get & Show latest Ticket Number details data step2: Store the Old ticket data and changed data into Single table(can be two tables),so that there will be two/more entries for same ticket. Need Process model and its related script/ steps guidance on above requirement. I have already built process model to achieve step1 above and able to update one  ticket, but addin one more updated  entry for history   seems difficult Please let me know if required input information is not clear. Thanks, Deepak

I have two sections in the same form as- Section 1. Shows Ticket details on form with on selecting table row from a table(achieved this) section 2. shows updates history for selected ticket.(Not sure how to do using process model design ?) I have a process model used in record type having table to show tickets list and update a single ticket details when selected, which is working fine, he I have single CDT mapped to DB. How to achieve section 2 is my challenge? Here, on loading form having data populated need to store copy of record before submitting and update entry in the same table(can use two table if needed) Can be multiple rows to show ticket history in table below- 

Hi Everyone, Can somebody please help me with the below query, In my project, we are currently working on Private Network and we are slowly planning to implement Appian Cloud instance in our project. We have decided to connect the Appian cloud using Saas service. However, we wanted the dedicated Appian cloud instance to be only accessed from our private network. i.e. the dedicated Appian Cloud URL should not be accessed from any other network. Also, we wanted to know how does Appian Saas validates the connection made from our network. i.e. in terms of Appian RPA, if the bot installed in the system (Private network) communicates with the Appian server, how does the Saas service validates the communication. Please let me know. Many thanks.

i want to use temasysField() in  premise, but it dose not show any thing in the interface.