Process Modeling

Hello [emoticon:c4563cd7d5574777a71c318021cbbcc8], I was going through the product training videos from the Appian Academy and I came across this trick which I wanted to show you.  Scenario : Lets say we have a table whose primary key would be a foreign key to some other table (like an Order table whose primary key will be a foreign key to Order_Items table) In such scenario, when we insert the record in the first table (order table) , we need to extract the ID of the inserted row and we will use a script task to update the ID to the other table rows (Order_Items) In the script task we have couple of ways to update the foreign key as suggested in the below answers https://community.appian.com/discussions/f/process/25333/script-task-to-multiple-parameter-in-process-model https://community.appian.com/discussions/f/new-to-appian/24905/script-task-in-process-model/98510#98510 But the trick I found is, as below. It can be found in the community edition process name : AA New

Hi Community, I am just trying all scenarios related to send email smart servce though my environment. when I am doing start process for debugging first I am recieving an email. after that I added pv in the email body tried start process for debugging the process s completed but not recieved any email. Could you please help me. Thamks in Advance

How to attach a link in the email where it should open a document in appian.Im using email template not a plain text for the email body, Can someone elaborate the procedure which I need to follow. [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] 

Is there a way in a process model to add a node with an informative screen, that does NOT require any user input, and the process continues running immediately after displaying the screen to the user? For now i see two aproaches, but none of them are what I'm looking for The first one: A User Input Task with a form, and a timer, that makes the process continue after a specified amount of time. But that makes the process wait when there's no need to. Also after the timer runs out and the user clicks a button on the screen, an error appears, saying that the task no longer exists. Second one: Make the form return something when clicking a button, and continue after the output. The problem is that I want the process to run even when the user navigates away from the screen, or closes the tab, as to account for the user not clicking the button.The two approaches can be used simultaneously, but still I would rather not wait for neither user, nor the timer. I just want it to go to the

Earlier I remember using records updated in Output of Data in Write to Records after write it will append the ID to the same record data given as input. Not sure whats wrong now its only returning id and i dont have the data in it. its overwritten with only ID after write. So i cant have entire field data to continue for other tasks following it. Am I missing something or is it how it should behave in recent updates? I am using process start form and not user input task to map the details for inputs from forms to pv. 

Hi Everyone, Is there any option to import excel data into Difference Database tables, Pls let me know if any. Thanks, Nagesh.

export functionality I will be having 10,000 records so I don't want to export as a single Excel sheet I need to export dynamic sheets each sheet having 5,000 records only. So please give me some tips on how can we implement this scenario.

Hi,I have a process model where I have a value in a pv! variable. Now, I would like to send pv! variable value to the SAIL form from where I triggered the Process Model. Can someone give me a clue to do this. Thanks in advance.

Is there any way to get list of all process models having receive email event???

A process model is configured to archive after 7 days. Its instances are completed but they wont be archived till 7 days. Now the process model is configured to archive after 0 days. Now it will be archived the moment the process instance is completed. Will this change affect only the latest instances or it will affect the old completed instances as well??Thanks

I have a task in a process model that needs some user input. I also included cancel button as a way to "go back" and do the task later. I have mapped this cancel to a XOR and if cancel is true, the line loops back into the task:This produces two issues. The first one is I get notified again if I cancel because task is reassigned to me. The second issue is that for some time the task is not assigned to anyone. I have a list of tasks taken from a task report, where I have links to the tasks. When I click on the link this form opens and when I click the cancel button I get back to the list of tasks but the said task is not present anymore in the list. When I refresh the page however it appears again as it is assigned again.Is there a better solution?

Any two gates side by side in a process is okay ? What may be the issue? what is it called?

.

Hi All, While writing the  data to records via a pm , i am getting the below error  Unable to write to or delete from the source due to system error.Error Details: Incorrect date value: '292278994-08-17' for column    Can anyone guide me on this issue .. Thank You

I want to show customized confirm dialog box (instead of the Appian default "The Task Couldn't be submitted" message) whenever the user input task is timed out (in our case the exception timer we have kept for UI task is 20 mins). Also at present when the user clicks OK button in the default dialog box, then the page stays there and either the user have to press F5 to restart the process or have to click on any of the SITE tabs to come out of the screen. Instead, I have a requirement to come out of the current UI and the system should redirect the user to the page where the process was called from eg., if the process was a related action and one of the UI task timed out, on click of OK button the system should redirect the user to the page where the process was triggered i.e., record summary page.

Once i clicked on any left section like general , programetic i am getting out from task, if i see in process instance task is there only ,i how to resolve this ?

Hi guys, Encountered an interesting behaviour today in a workflow that encompasses a multitude of different process models. Each PM is a step in the process, and some steps are performed by different teams. E.g. Team A would perform a relevance check, then Team B would check if all is in order and either approve or send it back. What I noticed is that sometimes Team A will not receive an automated email by Appian with their task, although they are the assignee in Appian and can navigate to it from there. And it seems that it has to do with how Activity Chaining and the checkbox for "Override assignment for the next attended activity even if the current user is not an assignee" in the flow properties is set up? I tried to check the documentation for information / best practices in this regard, but didn't find anything pertaining to this problem. Would someone happen to know what the rules are and what pitfalls I should avoid when modelling such a workflow? Best,

Hi there. Sometimes there is a business scenario you need to make some actions more user friendly (quick). For example, if someone approves many tasks, you don't want him to open every task and click the approve (submit) option. I want to give the approver an option to submit from a site (not an input form). So I have in mind grid or list of his tasks and he can click "approve" or "reject" button in each line (instead of opening each task and click tehre). Is this possible in Appian?

Hi , I have a grid which fetches values through API call on clicking a button. I'm able to fetch the values when I click on that button in interface but not in Site. This interface is being called as an action in Process model and I have configured all the rule inputs in the Process model. Here in interface when I click on the Search Multi Agreement Activities I'm able to get values in below grid. . And in Site when I click on the button, its just showing the empty grid Can someone help me what could be the issue or what I missed here.

Hi, I am working on a task where the main function is importing excel data to the database. I need to create an interface where I upload the excel file and the file gets saved somewhere in the directory, I did this by simply adding a file upload section which contains this code:a!sectionLayout( label: "Upload Employee File", contents: { a!fileUploadField( label: "File Upload", labelPosition: "ABOVE", value: ri!document, saveInto: ri!document, target: cons!HR_EmployeeDataPointer, maxSelections: 1 ) } )Now, I need to create a process model where first I get the data from this uploaded file, query and match the data in the database and check if the employee exists and if it doesn't I need to update the database or leave it as it is if it exists. After these I need to show all the data in a grid in another interface.Besides the first interface I also created the expression rule to read through the excel file even though it's s

Hi all, I have a scenario where I have to send a multiple links in a Google chat in a single message Message format should be like this RequestNo ।। CreatedDate ।। Links 1।                          Date।     Click here And so on How to achieve this Thanks in Advance

"I am working with dependent tables, and it's already functioning in the interface. However, when starting debugging in the process model, it throws the following error: I believe this might be due to the variable in the 'Group' field, which comes from the interface as an integer variable but is presented as text in the user form. Could you guide me on how to handle the configuration of the node or the properties of the Process Model M to fix this error?" This is what I have in my node configuration These are the variables on my Process Model´s properties and this is my rule inputs on the interface Appreciate your comments. Regards,

Here in this model, you can see currently instance sits in Confirmation Screen user input task, but from user screen, this wasn't opened and process got closed showing "Action Completed" banner. I've activity chaining all the way till this node. What could be the possible reason for it? Please advise. Also, for this node, there are two instances at the same time, though the assignee is pp!initiator.

Hi!  I read it isn´t possible to create an any type variable in a process. This is my use case, I hope you can help me: I need to pass a process an array of cdt, but it could be different types of cdt, and the process, depending of the cdt type writes on a different table. Any idea is welcomed, thanks!