Discussion Categories

When there is prolonged user inactivity, a popup comes from Appian stating that session is about to expire. We are not able to click on any of them. The screen freezes until we refresh the browser.  I am looking for guidance if anyone has encountered this in their projects. Any pointers are appreciated.

Hi Community Team,  I need to set validations for 3 date field components. The following use cases are as follows: Commonly No filed is null or empty. 1. Field Name: Joining date validations are : I must be able to select the date which is over past 100 years and also able to select the future date which is One year from today. 2. Field Name: Access Start date validations are : I must be able to select the date which is from join date or I must be able to select the date which is one month from today. 3. Field Name: Access End date validations are : I must be able to Validate the date which is from one year  from Access Start date. For each filed, If the validations were violated, it returns error message. Please help me out to solve this use case. open for suggestions.

Hi All, I have a integration point in process and it is returning HTTP Response. I would like to know how to convert HTTP Response to CDT . in HTTP Response there is body attribute which i want to convert directly to CDT if possible. I have already created a CDT with the same structure. Example : body={coord={lon=-83.1801, lat=42.3349}, weather={id=501, main=Rain, description=moderate rain, icon=10d}, base=stations, main={temp=20.35, feels_like=20.84, temp_min=18.83, temp_max=21.73, pressure=1017, humidity=92}, visibility=10000, wind={speed=3.09, deg=80}, rain={1h=1.5}, clouds={all=90}, dt=1626440173, sys={type=2, id=2009516, country=US, sunrise=1626430214, sunset=1626484018}, timezone=-14400, id=0, name=Dearborn, cod=200} Thanks, Gaurav

Hi  I am able to extract the document from fillable field in pdf by following the tutorial in forum. I tried to select handwritten notes by holding shift button and select the word but it didn't work for me.  Please guide me to get the tutorial available for handwritten notes. Also is there anything which i have to take care for handwritten notes different than the fillable pdf. 1. I tried to select the work by holding the shift button 2. Preferred vendor - Appian Please guide. Thanks in advance

Can I get a solution for which will be responsible for taking inputs from appian in json format and handing over it to UI(react js or javascript or html) and taking the response from UI and giving response back to appian which needs to display the UI in appian designer, is this possible in appian designer if so can you please provide me the solution?

This query is simple enoughtselect noteId , miscMattersMainId , createdOn, createdBy , note from PLSM_note Those are the only fields in the table and only two records in PLSM_note,  This is being executed against the pre-defined data source that comes with Appian with almost no load on the server.For reference, when I run this same query in the loud Database/MyPHPAdmin I get Showing rows 0 - 2 (3 total, Query took 0.0003 seconds.)So what's going on as it's taking more than five minutes to complete the execution?

hi Community, i have a use case for creating 4 dynamic user filters whose data source is record type itself .now the challenge is that all the filters should be configured in such a way that if one filter has a selected value the other three filters should display data based on the first selected filter value please suggest a possible way to do it

Hi, local!initProvidersSegment.ServiceLocation.Addresses is my CDT where Addresses is a list of array. In the grid selection i have selection value in local!selection i want to find local!selection in Addresses except one field in local!selection.Action field which is updated and CDT values remains untouched.. Suggest an expression.

Hi, I am trying to make use of record type in my application since we have a requirement to display the data in a list and take action for each row or view each row in a dialog box. My Business case is like i would receive a json file as input to my process model and i am using a CDT to map the fields of the input json. It consists of various segments and each segment is a list of values which is supposed to be displayed in appian interface to the clerk and take action on each segment rows. Kindly suggest an approach so that i can start building my application. As i read through the record type and its example implementation i predict it will meet my requirement. The only hurdle i am facing is when configuring recordtype source if i use process model all the active instances of the process model are getting mapped as list rather i want to have only the particular instance in current context's PV which is having list of records to be formed as list and as data source.Kindly sugges

Hello,I'm trying to create a POST method WebAPI that waits for its process model to end.I need to receive a JSON data type, process this data, and return an XML generated with the process model as the WebAPI response, is it possible to process the JSON information received and make the WebAPI wait for the process model to end ?I know that by the own definition of this method, the process model runs asynchronously, but I don't know any other way of approaching this case.Any idea will be welcome.Thanks in advance !

Hello,  It seems the documentation for the RPA Actions is limited and I would like to know which Action should be used when the need is the robot to update Excel File,  For example I guess one of the following two will be:  Initialization with URL or Initialization with File Parameter Let's assume the file is located on disk C:\Exce\ what parameter should be passed to any of these two actions in order the robot to open the excel and start filling in data after that ?

i have to provide a link, once they click on that link the document has to be downloaded. for this i need to give 2 paramater 1. unituq id(we already have) 2. document id(we already have) can anyone help me with this?

Hello team, i would like to use an expression rule in timer to define the day when a PM will run based on the values in DB. Every month the cut off day for processes is different and its defined in the DB. The expression rule which i call inside the timer is: =rule!ICH_getCutOffDataByFilters(    year: year(today()),    month: month(today())).day, and it simple calculate the cut off day for current month. But when i publish the PM i am receiving the following error message: ERROR:EVAL:@reason=Expression is invalid (1 token(s) remain after parsing) Any advice please? Thanks

Hi All, We are using "Receive files over FTP" smart service to fetch files from a FTP folder and save it in Appian. However, we are not able to fetch the file & smart service is getting completed without any error. Could you please help us understand what is the exact parameter values we need to pass? External System Key: Added username & password in third party credential store in Admin console. There a key got generated (although the test connection is failing). We are using the key in the External System Key parameter as a string (eg. "externl_key"). Use Per User Credential: False Server Host Name: Text value, shared by external system Server Port: Number value, shared by external system Remote File URL: URL of the file appending the actual file name with extension

While using the Merge Pdf smart service i am getting the below error. Error com.appiancrop.util.BundleUtils - Cannot retrieve the value for key "Contents.error.userMsg" from the bundle. Error com.appiancrop.util.BundleUtils - Cannot retrieve the value for key "Contents.error.alertMsg" from the bundle. com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[contents.error.userMsg=???contents.error.userMsg???] alertMsg[contents.error.alertMsg=???contents.error.alertMsg???] Any suggestion would be helpful.. Thanks, Ram

Can anyone help me how can i integrate gmail with appian so i can see all the unread emails in appian?  There is this gmail connected system plugin in appian market. but its not working.. is there any other way i can do that ?                                                                  Below is the error i get when i m using the gmail connected system .  and this is the Gmail connected system I use.

Hi, I am facing one challenge w.r.t CDT data. I am passing a CDT from process model to interface and mapping CDT data to interface and displaying to the user. User updates the data in interface and CDT gets updated in interface. When we do hard browser refresh the saved values of CDT are getting cleared. Suggest a way apart from save draft option available in task form to save values of the CDT in interface or process model.

Hi, Im new to using reject function.  Now im using the reject function in a process model in a script task  In the input : I am calculating a map which looks like this :  {    id : <>,    account : <account_cdt(id, name, hold_code)>  } Now in the output tab I want to use reject function to reject all those accounts who have hold codes null ... but then my requirement is that the ID should remain in the output I am using reject function like this :  reject( fn!isnull(_),     a!forEach(           items : ac!map,           expression : {                  id : fv!item.id,                  holdCodes : index(index(fv!item, "account"), "hold_code")           }    ) ) Now I know this wont work, but can anyone suggest me how to make it

Hi Techies, We have a requirement where we want to show a particular site page when a particular user logs in. We have provided the site page url directly to the users but the problem is they want to see different site page for different users on log in. Is there any way we can change the default page that opens after logging in for different set of users? Thanks

Hello Everyone, I am trying to append data into a nested cdt in the order i enter data in the tabs, but unable to do so. Currently i am saving the data like this saveInto:{local!info,a!save(ri!userData.UserInfo.field1,append(ri!userData.UserInfo.field1,local!info)) I have a big multi section form and each section has multiple tabs. The section (form) i am working has 4 tabs and each tab has almost same fields. I have a rule input called users data which is of the type usersData cdt. usersData cdt has nested cdt's. My use case is - users should be able to enter data in multiple tabs in the form and after entering the data it should be appended into one of the nested cdt's of the rule input. The nested cdt is an array. I want the data from tabs to be saved in the order user enters them. Ex - Tab 1 - Fields A, B, C                                              &nb

I have a read only grid with select boxes enabled creating something like thisAlmost everyone says that you should used delete from data store entities to handle record deleting. However, this page https://docs.appian.com/suite/help/23.1/Custom_Data_Types.html says that most of the time you should not use CDT but CDTs are required for DSE.Where can I find a step by step walk though that does not use CDTs or DSEs to delete multiple records from a read only grid?

Is there a way to get editable grid to page through the entire data set similar to 'read-only grid'?  I have 10K records and each record needs to be classified based on a list of categories.  Right now, the entire 10K records are being shown. Thanks.

Hi, I am creating an application in Spanish and when creating a User Filter for a Record Type of type Date Range I have the problem that the date selection calendars are in English and I want them in Spanish, is there any way to change it?

I have this querydelete from PLSM_note where noteId in (fn!substitute(fn!joinarray(ac!selectedRecordIds, ";"),";",","))as shown in the below image. This query should translate to: delete from PLSM_note where noteId in (1,2,4,50)A) This is all on a single rowB) This is a single queryWhat's the solution to this?

Dear Team, Could someone help me to understand the below issue please. I am trying to fetch the total count of the records from DB view. When I give fetchTotalCount=true it's throwing an error 'Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data. Details: Unexpected error executing query'. If I change the fetchTotalCount=false, it's working fine. Sample  code is below: a!queryEntity( entity: cons!DB_VIEWS_DSE, query: a!query( selection: a!querySelection( columns: a!queryColumn( field: "id" ) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1, sort: { a!sortInfo(field: "id", ascending: false()) } ) ), fetchtotalcount: true )