Process Modeling

Lets say you have a form with a textbox name. The form populates from a DB tableA. What is the recommended way of saving it into DB tableB? I experimented with the following: 1. a!pickerFieldUsers( label: "Name", labelPosition: "ABOVE", value: if(isnull(ri!tableB.firstlastname), ri!tableA.requestaddedby, ri!tableB.firstlastname), saveInto: ri!tableB.firstlastname, readOnly: true, validations: {} ) 2. putting   a!save(ri!record.requestdateadded, now()), in the submit button etc. Another idea was to keep the same rule input and handle it at "Write to DSE" in the process.

Hello all,  So I have a process, where the stakeholder wants to handle a feature more restrictively.  So before starting a process prompt a new question. ( I already have an interface working fine, but with the new requirements should  I create a new one with the questions ?) What you would like to amend?  ( I already have an interface working fine, but with the new requirements should  I create a new one with the questions ?) Distribution Fee amount only (->only Distribution Fee should be editable)  -> process works the same as before, BUT once approved and processed by Documentation the task does NOT go back to other team in the end anymore KID, Target Market, Cost&Charges only (->only these fields should be editable) -> process works the same as before, BUT once approved and processed by Documentation the task does NOT go back to the other team in the end anymore  Others (might include the above on

I have created template that contain Appian input structure ( ###sample### ) to replaced by the the smart service "MS Word 2007 Doc from Template" but it read some fields and give this  as in the figure in others what is the issue ?

I have this dictionary that I want to extract values from depending on one of its values: a!localVariables( local!myDictionary: { { user : { info :{ { name: {codeValue: 1, nameValue: "engineer"}, type : { codeValue: "role", nameValue: "role" } }, { name: {codeValue: "s101", nameValue: "science"}, type : { codeValue: "dept", nameValue: "dept" } } } } }, { user: { {},{} } } }, local!tempResults: //maybe too much going on index( if(isnull(property(local!myDictionary.user,"info",null)),"",local!myDictionary.user.info) ,if(isnull(property(local!myDictionary.user,"info",null)),"",wherecontains("role",touniformstring(local!myDictionary.user.info.type.nameValue))),""), local!tempResults ) I'm wanting to return either the 'codeValue' or 'nameValue' from 'name' (ie.1,engineer,s101,science), depending if the &#39

I have a requirement where I have to export form data to excel. I am using excel template to populate data in specified cells using "cell keys" and "cell values" but data is not coming properly. Expected Output should look like- column C,D,E are coming up additionally. Could anyone help me how to correct this. Below is the current configuration: CDT- pv!cdt, cell values- {  "B2",  "B3",  "B4",  "B5"} cell values-{pv!cdt.f1,pv!cdt.f2,pv!cdt.f3,pv!cdt.f4} Document_name_to_create- "Form Fields" Document_save_directory-cons!Folder Excel_base_template- cons!excelTemplate Include_header_row-false sheet_number-0 Starting_cell-"B1"

Hi, I was trying to get Employee related data by executing a stored procedure with the help of "Execute Stored Procedure" smart service in a process model. To get the data, in "Output" tab of Data I have selected a variable as Target variable and type of which is employee CDT. There is a section with the name "Expression". What should I write at "Expression"? Because at the time of publishing it is showing error as follows:   The Output tab: Can any one please let me know what should I write at Expression box, so that I can get the employee data which is returned by the store procedure at Appian end?

My question is, if it is possible to go through a process node twice. Here is an example (I understand this could be designed better with a subprocess etc). The process initially saves data from the form into the TravelRequest DB table. If there is a comment it saves it to the Comments DB table. Later the Supervisor adds another comment through a user input task.  Looking at the process details I can see it does not go through the gateway a second time. Kind regards,

Hello! I have a requirment to have a complex gateway connected to 15 tasks star some  those tasks, finish them, then end the process. I am trying to figure out how have a gateway that goes forward only when the handful of tasks started complete. Here is a few examples. Process starts with a parameter of "Billing". My complex gateway starts tasks 5, 6, 8, 10, 11, & 12. Those tasks finish.  Meeting at some kind of end gateway.  Gateway somehow knows i want to proceed and the flow goes to the end node.(this is the part i need help with) Process starts with a parameter of "QA". My complex gateway starts tasks 4, 5. Those tasks finish.  Meeting at some kind of end gateway.  Gateway somehow knows i want to proceed and the flow goes to the end node. How do I make a gateway to deal with these incoming flows?  AND gates would wait for all 15 every time, complex doesn't work because the paths that need to complete are different so

Hello, I have a similar question to: https://community.appian.com/discussions/f/rules/21530/getting-one-property-value-from-dictionary-based-upon-another-property-value. But instead of returning true/false, I need it to match it against a string value on match condition: a!localVariables( local!myDictionary: { { item: 1, active: "A", description: "Widget", color: "Green"}, { item: 2, active:"B", description: "another", color: "red"} }, local!tempResults: if(fn!index(local!myDictionary,"active","") = "A" ,"yes","no"), reject(fn!isnull, local!tempResults) ) The index returns the "A", but when I do a condition against it (if statement), nothing returns. I want the string "Green" returned if it matches "A". IT says it doesn't match it.

Hi All, Is there any way that we can configure a default password for all the users created by create users smart service . Thanks in advance

I have a form, which is filled out by the Employee and then send as a task to the supervisor to review. As I understand the ID is generated in the table, therefore this information is not available intially when the user inputs the data. What therefore happens on the second write to DSE is that it creates a completely new record, with the status change as the difference as that is something i manually change in the DSE.  What I would need, is to provide the second Write to DSE with record ID that the first "Write to DSE" created in the DB. How can this be done? ------------------------------------------------------------------------------------------ I looked at the reference app, because there the process creates a new vehicle maintainance and records it. However I have not found how this ID is retrieved. A script task is created: which calls a expression rule.

Online Course | Learning at Appian In the video it is stated that if you save at the top-level, all fields are updated, which implies that if you save at the level of specific fields only those fields will be saved. Is this true? I found out, instead null values are being inserted.

Hi team, Could anyone please explain me to implement the site in process model. An example would be highly appreciated?  Thank you in advance! Regards, Shubham Kumar

How can we give a relative path in the end point of a web api which starts a process model. For example the end-point of web api should be test/data/getfiles

Is it possible to move a existing process conector from one corner (see picture (1)) to another (2)? Currently I have to delete the 2 connectors and recreate them. Kind regards,

Hi All, i know that PV is used to carry through out the process and AC within the node. But, i can't understand which are PV. is it only the rule inputs in interface can be PV or how it is used practically. and on what purpose we configure input nodes and and when we configure input. also what is the impact of save into. please answer.

I would like to know if the following scenario is possible within Appian, and if so how to accomplish it efficiently: I would like to establish a set of process models that each perform a certain function.  I would like to make an interface that my users can use to create a template and order those process models however they like, then save that sequence for later use by themselves and others. Finally, I would like those users to be able to run that sequence of process models on demand. Is this possible, and what would be the best way to accomplish it without resorting to crafting a new master process model every time? 

Hi,  I cannot Send Email from "Process Initiator", "Process Designer" and "Custom Sender" However, sending from "Process Model" or "Process" is working fine. please help. Thanks,

Hi All, We have developed an Process Model to export the data from SQL to Excel , which comes in multiple sheets, the data is exported as expected, but only last sheet column names are highlighted in Bold, How can i make all the sheets column names as bold. Warm Regards Vineeth

Hi, I have an integration that calls the target database through APIGEE. I have CDT of array which is array So the integration need to be called n number of times in parallel using MNI. I see the request sent to APIGEE for all the 11 records (test data had 11 records) available in the CDT sent at the same time but the response received by appian is taking more time even though APIGEE sent the response back under a second for all the 11 requests. Below are the apigee and appian logs. The duration increases for each thread in appian which seems strange when apigee sent the response in less than a second. APIGEE log: Request 1 till 11 received at 9:52:08 AM Response 1 till 11 sent in 300 micro seconds at the max making it a response sent in less than a second Appian process nodes Request         Started             Completed             Duration Request 11   

Hi team, please I hope that in the next release the engineer team will add again the selection of the process variable, task properties and activities class in the new expression editor because for designer is very useful to select instead of writing them and in addition this behaviour go in the opposite direction of the low-code and drag-and-drop message. As an example selecting the pv name directly instead of writing pv! and try to remember the correct pv name is more faster and easy

Hi Everyone, Currently there are a total of 100 columns in a table and I am using export data store entity to excel smart service to export data into excel. Since we cannot export more than 50 columns, I am using 3 sheets in same excel to get export data. Is there any other way to export entire 100 columns data into excel without splitting them. Thanks

Hi, I would have a theorical question : Let's say I have a very complex process that count 60 nodes, and the latter can not reach the end because of the 50 nodes limit. Let's admit that 30 first nodes car be executed in parallel with the 30 remaing nodes. Does the limit of 50 nodes will occur nevertheless?  (using an AND gateway for the 2 paths)

Hi All, I am currently using Export from Datastore entity to Excel Smart service.  There are a total of 100 columns in the table and I am splitting approximately 30 columns into each sheet, making upto 3 sheets of data in same excel file. Uses 3 smart services for exporting data into 3 sheets of same excel. In first two sheets, column header is in plain format, But in third sheet column header is showing up as bold. I am unable to find out why one sheet is showing bold header. Can anyone help me how to make the column headers in all 3 sheets into same styling format (Either plain or Bold). NOTE: I am not using any predefined template to update, the new document generated by 1st Export from Datastore entity to Excel Smart service is used to update in the next smart service. The data gets updated in the another sheet, not in the sheet which already has the data. Thanks

Hello, I have a use case where we need to store the email directly on a service like S3, without parsing. I'm trying to come up with a solution for this and I was wondering if the Receive Message Event allows capturing the .msg file to store it. Our use case will imply some kind of parsing (e.g, body, from, etc.) but we also need to come up with something that allows us to store the raw data. I already explored some options in AppMarket but couldn't come up with a clear solution for this. The event only seems to allow some kind of manipulation with the data and that's OK for us, but we also need the raw information. What can we use to achieve this solution? Kind regards