Discussion Categories

Hello. I have a process where i want to monitor status of a Record and to save the details about each step with timestamp. Lets say i have 3 statuses: Id 1 "it started" Id 2 "first mail" Id 3 "second mail" And I have Record type "History" with columns Id(primary key), status id, timestamp. I want this Record type to save the data like: Id1, status id1, 23.12.2022 12:55:00 Id1, status id2, 23.12.2022 12:57:00 Id1, status id3, 23.12.2022 12:59:00 Id2, status id1, 23.12.2022 13:01:00 And so on... So i can see the precise time when each step occured without overwriting Id1 with last status3 (and only showing this last status on database/Record type). How can I achieve this? Currently I'm saving the status id with Script task, but dont know where to tell Process Model that I want to save each step separately. And as i complete the process IT only shows last status on database. Help will be much appreciated.

Hi All, I am able to see the user which is already selected previously in the pickerFieldUsers, how to hide/prevent the users' which already selected from pickerFieldUsers ? Thank You

Hi Everyone, Is there any plugin or approach to display the Realtime notification to logged in user in Appian. Example: Use case is, whenever the case created and assigned to any logged in member, should see the desktop/web notification saying case assigned to you. In Realtime users they opened the homepage,they would like to know whenever the case is assigned to particular person through desktop/web notification, so they act immediately. Otherwise, users need to keep on refresh the home screen. We thought below two approaches but see the couple disadvantages. 1. When the case is created, can send an email to user and user can enable the outlook desktop notification feature but at this movement we would not increase the emails.  2. Add the refresh interval to get the data but it is not that much of user focus. Alway need to focus on the screen. Could you please help us is there any other approach/plugins. Thanks In Advance!!

Hi All, I am adding and fetching data from database through integration object and displaying it to the interface. First time when add button is clicked it gets displayed on to the interface and when second time I click on add the data gets added to DB but its not refreshing to interface. I have used the refresh variable in the interface as well. Can anyone please help help me.

Hi I am getting an error message below. Could you tell me how to solve it. ■the whole message displayed by the Configurator -----------------------------------------------------------[INFO] Scanning for projects...[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[WARNING] Could not transfer metadata org.codehaus.mojo/maven-metadata.xml from/to SERVER_ID (mnvk.appian.community/.../repo): authentication failed for mnvk.appian.community/.../maven-metadata.xml, status: 401 Unauthorized[INFO] Downloading from SERVER_ID: mnvk.appian.community/.../maven-metadata.xml[WARNING] Could not transfer metadata org.apache.maven.plugins:maven-archetype-plugin/maven-me

Hi,Can anyone tell the difference between Write to Data Store Entity Smart Service and a!writeToDataStoreEntity() function?? I am asking in the context of place of usage. As best practices, what are the specific places we can use the above mentioned? And is there a way to catch the error occuring while writing to DB using Write to Data store entity smart service???Thanks in advance

Hi, I have an excel file which looks like  that I am importing to my Appian DB through the smart service 'Import Excel to DB' and Ticket_Number is the primary key on my DB. It appears to me that the Smart service is sorting the primary key in ascending order (which I don't want).. I don't want to sort my data in either ascending or descending order. One solution is to create a separate primary key and prevent this from happening but is it possible to restrict the sorting in the smart service 'Import Excel to DB'. Is this a bug ?? or just that I am not aware of how to prevent my smart service to do any kind of sorting ? please help  thanks jaideep

WHEN I RUN THE PROCESS MODEL I GOT THIS ERROR , HOW CAN I RESOLVE THIS ERROR :.An error occurred while trying to write to the data store [K_EMPLOYEE_DETAILS_DSE].  No values have been written. Details: org.hibernate.exception.ConstraintViolationException: could not execute statement (APNX-1-4208-004) . CAN  ANY ONE PLEASE  TELL ME WHAT IS THE PROBLEM ?

Hi Everyone, I have the requirement to add multiple rows in editable grid and it should have a x icon for each row added before saving to remove that row. Can anyone please help me out. Many Thanks in advance!

Dear Team, I had a query, what steps need to be followed for deploying application from one cloud to whole new different cloud.

Hi Team, I am working on the history table of my Appian application. I created a new table in the database having a similar column of my application in addition of 3 new columns modifyby, modifyat, and operation(create/update/delete). I created a corresponding record type/data type as well. The entity mapping on the Datastore is also successfully done. Now while I am updating my code on create/update/delete interface to fetch the action history of my app, I am getting errors. This is the code:- buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", saveInto: { a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{b5d840ba-2408-425d-b829-510414356ac2}serialnumber']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{d7f705b2-c020-47c9-95c4-cbe0e6df18a2}addedby']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-94

Dear all, I'm finding a solution for a phone screen, when the user scrolls down then show an icon on the bottom right so when the user clicks on that icon the page scroll to the top .... ???

Hi all! For my application, I need to acquire the data type and length (and the number of decimals in case of a float) of all the fields from a single Record Type (and preferably the source fields as well). Now, as far as my knowledge goes there is no out-of-the-box solution for doing this. For acquiring the data types of a Record Type I have made the following solution:  /*Partly based on the solution provided in https://community.appian.com/discussions/f/general/23723/map-with-variable-key */ if( rule!isVoid(ri!record), /*use your void check expression here */ {}, a!localVariables( local!xml: toxml(ri!record), local!json: a!fromJson(a!toJson(ri!record)), local!keys: a!keys(local!json), local!types: extract( local!xml, cons!XML_FIND_TYPE_START_DELIMITER, cons!XML_FIND_TYPE_END_DELIMITER ), cast( typeof(a!map()), reduce( a!update, local!json, merge(local!keys, local!types) ) ) ) )

When converting docx to pdf using Arabic font, I want to prevent numbers to change to Hindi numbers.

Please forgive me if there is a way to do this already... I find cases where I have a fault in a process model during debugging. I track down the fault and fix it (either in the instance or in the process model itself) I then have to re-run the process  BUT Sometimes one wants to have a live run of an older version against a newer version rather than looking at the static comparison view in Versions SO I would like to be able to: go to my instances in Appian Designer Monitor view be able to right-click (or other method) to select a different version of the process model (i.e. either a previous or an updated version) run the same instance through  the newly selected process model 

Hi, We are creating performance test scripts in JMeter, after recording the flows and running them, the scripts run fine for 1 day however they fail after 1 day, on inspecting I came across several dynamic values like CacheKey, SaveInto and Context which change often.  Now the problem is there are several CacheKeys, SaveInto and Context in multiple responses before the requests where these values are used, how can I know which values to grab dynamically and use in the further requests.  Can anyone please help as this is a blocking issue! PS- I have already handled the appian csrf token and I am able to login successfully.

Hello, As I am new to Appian and try to evaluate the tool I would like to import some data from excel/ CSV to test drive a couple of ideas. I have found a plug-in that should be helpful in importing data: https://community.appian.com/b/appmarket/posts/excel-tools#. Though when clicking on download it says "This app is available to download for Appian Customers, Partners, and Employees. Please make sure to self-associate from your profile" I assume the free account doesn't make you a customer, though how can I get a sample data set in the platform to test drive. Regards, Wolter

Hi All, Trying to refresh using a refresh variable in grid. Facing issue with refresh. Please find below code and let me know if any changes are required. a!localVariables( local!refreshCounter: 0, local!startIndex: a!refreshVariable( value: 1, refreshOnVarChange: local!refreshCounter ), local!pagingInfo: a!pagingInfo(local!startIndex, 5), local!data: a!refreshVariable( value: rule!S_getAPI(), refreshOnVarChange: local!refreshCounter ), { a!buttonArrayLayout( a!buttonWidget( label: "Refresh", size: "SMALL", style: "SECONDARY", saveInto: { a!save( local!refreshCounter, local!refreshCounter + 1 ), } ) ), a!gridField( label: "Data", labelPosition: "ABOVE", data: local!data, columns: { a!gridColumn( label: "First Name", sortField: "firstName", value: fv!row.firstName ),

Hi I am trying to do 'Maven Setting' with Appian RPA Configurator. However, an error message below is poped up. ・Authentication Error!: Check that the provided console repository URL and the maven API key are valid. This means that the provided console repository URL and the maven API key I input  is incorrect, isn't it? Please let me know if there is a possible cause other than incorrect input of the value.

I've got a dictionary of values and I would like to either loop through it for a grid, or convert it to something I can loop through. How might I do that?  For example, I've got this dictionary: {A: 3.1, B: 2.2, C: 1.3} I'd like to have a table that is something like Name for the first column containing A, B, C and Value for the second column with the various numbers in there. I'd like to also record a similar in thing in the database. How can I do that? 

Hello everybody Someone could help me please?? I don't understand about engine, what it it? how it is working  regards

Hello! I'm currently having an issue where I make the selections in the dropdown, but when it saves to my DB it saves the first selection 2 times or 3 depending how many selections I make. Currently I'm using a local variable to save the selection. Any suggestions to make sure it saves correctly to the rule input? thanks in advance

Dear all, I need to change the phone number to send the SMS for multifactor authentication. Do you know how I can do it? Thanks in advance. Best Regards Patricia

Hi, I have to make a call to SQL Server stored procedure with input parameters and get the return value. I have gone through the below URL for required documentation. docs.appian.com/.../Execute_Stored_Procedure_Smart_Service.html I am using 21.4 version of Appian, but still, I don't see Execute Stored Procedure smart service in my list of smart services. Can someone advise on this please. Thank you