Discussion Categories

How to find the wrong email address when we are fetching data from the DB? (I am fetching employe's Data from DB, after fetching the data I need to send the mail notification to those Employ's, but "I don't want to send the email notification whose gave me the wrong email format or wrong email in process model Also I need to find the invalid email id")  Can Anyone help me for this,

I want to display cards as rows and columns of each 15 displaying as a grid together. After this i want to apply condition to display the numbers in order and display the cards that numbers are divisible by 7 , 8 and 9 only without rearranging. I display the rows and columns using cards. Can some on help me please?

I want to make UI where two grid will be shown grid 1 will have all data and grid 2 will be initially empty. In grid 1 we have checkbox where we can select different row and when we click add button then all selected items will be transferred to the second grid and selected item will be deleted from grid 1.  

I have run the Appian Health Check recently.  I chose not to automatically upload results to the community.  After the check completed, I downloaded/extracted the zip file.   Per the documentation, an Appian Health Check summary sheet should be available.   As I review the contents of the zip file, I do not see a Summary sheet. What in the extract should I be looking for specifically? Thanks

Hi Community Team, I'm facing issue to store multiple values in Database, My task is to accomplish to add multiple comments in a interface section layout. I need to store them by saving them into Cdt.  User Scenario: For each comment it needs to generate new Primary Key.. Data need to be entered in a new row for each comment. Comments   Comment1 Remove Icon Comment2 Remove Icon comment 3 Remove Icon Add Icon to add new comment

I am trying to perform related action for a record but I am facing below issue  This issue happens for only particular record where as for other records it is working fine. Any help on this would be appreciated

Hi Community Team, Here, I'm using two Cdt's One parent table (Emoloyee Details) and one child table (Comments). I'm calling primary key in the parent table into the child table to fetch the values in the Child table.  I'm getting NULL instead of primary key of parent Cdt. Please help me out how to configure this error? Child PK                    Parent FK Comments_ID     Employee_ID  1                           NULL  2                            NULL  3                            NULL  4                             NULL  5                  &nbsp

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