Process Modeling

Hi All, What is the best way to create multiple appian users from a list of usernames from the database (Each record has the necessary information for the user, name, last name, email etc) ? I'm just confused of how to set up the create user node for multiple users in this case. thanks in advance

Hello Guys there is a problem with my Process Model, Below is the Image of error in PM, 

Hi All, Currently we are able to configure custom DL email ID (eg: testmail.com) in tomcat server for Appian process alerts (Appian process alerts which we will receive when process got failed or error).But how to configure Subject (eg: PROD) in tomcat server, so that if any Appian process fails or error we will receive process alert with Subject displaying PROD. This will helpful to identify the Production environment process alerts. Please let us know if more details needed. Regards,Sandeep

Good day everyone,  I am new to Appian and working on a project. I have a database with the following tables: Employees (1:M) Document Status (M:1) Training Document. I am trying to make a form that allows managers to assign each employee to multiple training documents at the same time. So, I have a form like below with a checklist of all training documents (fetched through an expression rule)  When the form submits, I need the process model to write to the database multiple times to the document status CDT. For example, based on the picture above, there would need to be three entries to DB tracking status for each training document and employee. How should I set up the interface and/or process models. Any advice/suggestion would be greatly helpful!  Best,  Harsha Gurram

Hi there, Is there any to convert word to pdf file? If yes, can we merge that pdf file with other pdf file? Thanks

Hi Team,I have a CDT named PSC test which contains a  nested CDT called PSC test1(nested cdt column name :idf). In a process model script task I'm trying to make the PSC test1 as null and write into DSE. In a script task I'm mapping NULL to it, but while writing it getting error. I tried using cast(cdttype,null), null, emptycdttype. But no  improvement. Is there any solution for this?Thanks in advance!  [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05]  

I hope this email finds you well. I am currently working on a project involving the use of a process model to write records. While I understand that, by default, matching primary keys result in the overwriting of existing records, my specific objective is to partially overwrite data in the existing record and simultaneously create a new record with a different historical record type. Could you kindly provide guidance on the recommended approach or configuration to achieve this purpose? Thank you in advance for your time and support.

Hello everyone, I'm currently working on an interface in Appian, and I'm looking to implement a record action that allows users to customize the displayed columns in a grid. Ideally, the user would be presented with a checklist containing the column field names, enabling them to select the specific columns they want to see. The unchecked fields should then be hidden from the grid. Is this functionality achievable within Appian? I appreciate any insights or guidance you can provide. Thank you!

Hi All, Is it possible to send a form in an email and have the user fill it out in the email itself and submit from there without ever leaving the email received with the form?  thanks in advance

I am using write record smart service, sending record fields but not primary key as it is a auto generation. when I am trying to retrieve the primary key, the primary key is not updating in the pv variable. Can anyone helps why it is happening.

Hi All, is it possible to show the user input task in a specific site of the application or a link with no other tabs, I do not want to show Tempo itselft ( Like where it shows new,report etc).  Is this possible? Thanks in advance

I am a beginner with Appian. In the interface, I input values for each field of a record type and save them to process variables. In the process model, I want to reference the same record, subtract a specific field from the corresponding process variable, and perform the following actions: If the result is 0 or below, I want to send an email without changing the value.If the result is 1 or above, I want to save the calculated result in a process variable and send an email.Can you guide me on how to achieve this in Appian?

I am a beginner with Appian. In the interface, I input values for each field of a record type and save them to process variables. In the process model, I want to reference the same record, subtract a specific field from the corresponding process variable, and perform the following actions: If the result is 0 or below, I want to send an email without changing the value.If the result is 1 or above, I want to save the calculated result in a process variable and send an email.Can you guide me on how to achieve this in Appian?

I am a beginner with Appian. In the interface, I input values for each field of a record type and save them to process variables. In the process model, I want to reference the same record, subtract a specific field from the corresponding process variable, and perform the following actions: If the result is 0 or below, I want to send an email without changing the value.If the result is 1 or above, I want to save the calculated result in a process variable and send an email.Can you guide me on how to achieve this in Appian?

I got error log when exporting app, indicate a PM got error ctx={from={processModel: id=xxxx, uuid=aaa-bbb-ccc} How to locate the PM by either id or uuid?

I have two different pm. Can I cancel one process model in the other process model. I used "Cancel Process" but it looks like it cannot work.

I am creating multiple employees through process model and I need to create folder for each employee I am using create folder smart service. Can anybody suggest how can i create multiple folder for multiple employee 

I got an error message in a Process Model that is running a script task to update on a recordType. Error writing to process variables (Invalid a1e14d1a-f90e-42c0-821e-33ec2665fafd: Cannot validate type, incorrect number of elements, Invalid c3c2a3f4-623c-4f0a-b2fc-d893215c2897: Cannot validate type... (Data Outputs) The individual is a foreign key being passed to the following. The first one: a1e14d1a-f90e-42c0-821e-33ec2665fafd is a phone number record. The second one: c3c2a3f4-623c-4f0a-b2fc-d893215c2897 is an email  record. if(rule!AF_RULE_General_isEmpty(pv!emails), {},repeat(count(pv!emails), pv!individual['recordType!{3d84f28c-0ab1-4452-aa14-6f0eaa2b6612}OLMS REC Individual.fields.{6942f6b1-21e5-418a-9944-1d58af72dba2}individualId'])) if(rule!AF_RULE_General_isEmpty(pv!phoneNumber),{},repeat(count(pv!phoneNumber), pv!individual['recordType!{3d84f28c-0ab1-4452-aa14-6f0eaa2b6612}OLMS REC Individual.fields.{6942f6b1-21e5-418a-9944-1d58af72dba2}individualId'])) What c

Hello there, I wanted to convert html to csv file and send CSV file in email. I have used "HTML Doc from Template" node and "Convert HTML to CSV" node. My CSV file has generated at backend folders but HTML file is going in email. How Can i send a CSV file in email? Please suggest. Thanks

HI Team, i  have active tasks which i am showing in task grid with query process analytics, My client have requirement like Once one task is submitted  the user need to automatically redirect to another task, Any suggestions on how can i do this, How i can handle the completed instance  task to move further and also user need to redirect to another task and also client is not looking out any activity chaining  interface which we have safelink  and use taskurl  Thanks, Udayasai

Hi Experts I have a Oracle DB table in which a column is of CLOB type. I need to migrate that data in maria DB I'm able to get data but unable to store the same data in mariaDB Table contains 2 columns : one is id and another is of type CLOB which is actually a string Help me to store the data in mariaDB Thanks in advance

I am looking for a way to store the task status Accepted in database as soon as user accepts the user input task assigned to him. We are not using database tasks and every assignment is done using out of the box Appian. How to achieve this using inbuilt appian Accept button on user input task?

I have two tables, Volunteer Requests and Speakers.  The Volunteer Request table collects requests from a website through an API to become a speaker.  The process model writes to the Request table the status of the Volunteer Request, (Approved or Not Approved), then writes the data to the Speaker table for those Volunteer Requests that are approved. When I process an approved Volunteer Request, the process throws an error at the XOR decision node. The error is, "An error occurred while evaluating expression: =pv!volunteerRecord['recordType!PMSO Volunteer Request.fields.volunteerStatusId']=2 (Expression evaluation error : Cannot compare incompatible operands of type Null and type Number (Integer).)" However, the Write Record smart service Update Request, does it's job perfectly and updates the volunteerStatusId in the pv to 2 for an approved Volunteer Request and writes the data to the database. The expression in the XOR decision node is: The field is an inte

Hi There,I'm trying to convert a HTML template to PDF via two smart services, i.e., 1. HTML from template 2. HTML to PDF,But while converting the orientation is changed, attaching screenshot for reference. please help with the issue.

Hi! Does anybody knows how can I capture the time when  a user accepts a task? and who accept it? when a user input task is assigned to a group of people... thanks!