General

hi,  I have a local variable "array of object" , I need to update value "seenBy" for one field in all array objects, a!flatten(a!forEach( items: local!msg, expression: { a!save(fv!item.id,fv!item.id), a!save(fv!item.isDeleted,fv!item.isDeleted), a!save(fv!item.createdBy,fv!item.createdBy), a!save(fv!item.messageText,fv!item.messageText), a!save(fv!item.convId,fv!item.convId), a!save(fv!item.createdOn,fv!item.createdOn), a!save(fv!item.seenby,concat(fv!item.seenBy, concat(tostring(loggedInUser()) , ",") ), ), } ) ), a!startProcess( processModel: cons!COM_Write_AllMsg_SeenBy, processParameters: { allmsg: ri!allmsg, } ), but the issue is :-  "An error occurred while trying to write to the data store [chatDS]. No values have been written. Details: Could no

Hi, I am trying to use an xpath as shwon below in fitnesse for appian script and it doesnt work, any help is greatly appreciated |click on button|xpath=//button[text()='Modeling']||toggle box |xpath=//*[div[text()='SomeState']

Hi All , I have a Date and Time field in my CDT (type DATE in the Oracle database). This field has a date and a time. I create a query entity rule with the filter: a!queryFilter(field: "recertificationDate",operator: "=",value: ri!recertificationDate,applyWhen: not(rule!APN_isBlank(ri!recertificationDate))) In the database, I have records with the date and time of 4/15/2019 4:05 PM but when I test my rule with ri!recertificationDate = 4/15/2019 4:05 PM, the rule is returning NO records. Any ideas why this is happening?

Hi All, We have just upgraded to Appian 20.4. I am not sure if the issue due to this but facing very strange scenario when using todate() function in an expression. todate("08/01/2021")<=todate(null)  --> this expression ideally should return false, but instead returning true. It was working as expected earlier. Please advise. Thanks and Regards, Diksha

What is the best way people have found to convert 6 Jan 2021 21:19:42 GMT text into date and time?

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.

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 ? 

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

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

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..

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 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.

Hi Guys , getting readexcelsheet function error at interface level , need your suggestion to resolve, Interface Definition: Expression evaluation error at function 'readexcelsheet' [line 41]: Thanks

I'm using ADT and generating several templates and then converting multiple PDFs into a single PDF document using merge PDF plugins. During this process, pagination is not consistent across. Eg:- 1st ADT to PDF has 5 pages and they are named 1, 2, 3, 4 and 5 2nd ADT to PDF has 3 pages and they are named 1, 2 and 3 When merging the PDFs, a single PDF is generated as expected however the pagination is not continuous i.e., 1,2,3,4,5,6,7,8. Instead it shows as 1,2,3,4,5,1,23 Is there a way to fix this issue? Is there a plugin that can take a single PDF document and apply pagination to it. Appreciate your suggestions!!!