Process Modeling

For a parallel process flow, if I am sending a task to 2 users in a group, and if the 2nd user of the group approves the task before the first user does, the task of the first user is getting automatically assigned to the second user again. What could be the possible reason for this?  

Hi, I have the following use case: The client needs to approve or reject a batch of invoices, but that everything is done through email, and they are external users who will not have a user in appian, they do not want to enter the platform, but from the mail they have the option to approve or reject. What occurred to me was that from the mail call a webAPI and it executes the startprocess, according to the link (approve or reject) that the user selects. Is this possible? Can I run a POST type webAPI from an email link? If not possible, what other way could I implement in this use case? Thanks.

I have one rule which return date and time from now(). I have created PM and added one pv of date and time data type. In default value of pv, i am calling that rule. Now, if we not select parameter checkbox of PV. it is saving default value from rule but, if we select parameter check box then default value is blank. This is happing with only date and time data type. why, it is happing ?  

Hello, I'm new to Appian and I'm facing an issue in Appian Step-by-Step #11 Exercise specifically in the Request maintenance process model,  it gives me this error below :  Unable to write to the source due to system error.Error Details: Column 'VehicleID' cannot be null Even though I have given the vehicle a default value in the Request Maintenance Interface and have assigned it in the store additional values node as an output. Please let me know if you got some ideas to fix it. Thanks in Advance!

Hello, I'm new to Appian and I'm facing an issue with Exercise 10, I have completed all the Add New Vehicle process model successfully, except for the cancel condition because as shown below, I couldn't assign a value to the rule input cancel .. even though I have assigned it successfully in the Add New Vehicle Interface. Please let me know if I can do anything else to fix it. Thanks in advance!

Hi All, Recently got an inquiry for use case where users would like the ability to click a link provided in an email which will navigate them to either a Start Form or User Input so they can reach the necessary screen faster. Users recently want to streamline their emails and provide a link to the necessary page where users will perform the necessary action that is being notified in the email. Issue with this inquiry I believe is there is not possibility to do this outside of the start page URLs on the sites. Given there are about two dozen different forms they could be wanting to access through the email I can't think of a solution to provide a unique link for each one of these process models. Does anyone have a use case where they made this work or a useful plugin that may make this possible?

Greetings, I am having an issue with a!exportDataStoreEntityToExcel() but I do not have an issue with a!exportDataStoreEntityToCsv(). They use the same inputs. I have uploaded a screenshot of the error message on the interface. I checked the tomcat-stdout log file and it says java.nullpointerexception. We are using a View on a PostgreSQL database. I am not too positive but it might have stopped working after manually erasing some rows in the tables for the View. We optimally want the Excel one working. Does somebody know what is wrong or have a similar issue? a!buttonWidget( label: "Generate Export of SFNS Orders", tooltip: "Export Available for Product Creators", /* tooltip: if(local!productCreatorUserStatus = true, null, "Export Available for Product Creators"),*/ saveInto: { a!exportDataStoreEntityToExcel( entity: cons!PMT_DSE_VIEW_SFNS_VIEW_ORDER_GRID, selection: { a!querySelection(

Hi everyone, here is my interface a!startprocess in this interface always return the same result even if I update cusNum parameter still same value and here is my process model: when i run the process model: here is the call integration data outputs :

Hi Experts, We got a specific scenario from our client where we have to keep our process waiting until a time provided by user matches with the server time. So from the UI user is providing date in one field as &quot; MM/DD/YYYY&quot; and time in a different field as &quot;HH:MM:SS&quot; and timezone in another field.The process node must only gets triggered or move to next node only when time provided by user matches with the server time.I&#39;m using below code but its not working as expected a!localVariables( local!split: split(ri!endSearchTime, ":"), local!day: day(ri!endSearchDate), local!month: month(ri!endSearchDate), local!year: year(ri!endSearchDate), local!endSearchDateTime:datetime( local!year, local!month, local!day, local!split[1], local!split[2], local!split[3] ), todatetime( if( local!endSearchDateTime - ((gmt(local!endSearchDateTime) - local!endSearchDateTime) - rule!TEST_ER_TimeZoneOffset(ri!endTimeZone)) < now(), now

I have a Process Model that creates a record. That record has a field &quot;record types&quot;, which can be A, B, or C. Based on which record type is selected, I would like to create a record from a related table with additional inputs. I have tried following this documentation:&nbsp;https://docs.appian.com/suite/help/23.1/Write_Records_Smart_Service.html#create-records-and-related-records,&nbsp;but there is a lot that it leaves out.&nbsp;Here is an example. If the Record Type is A, the process forks down to &quot;Create A record&quot;.My problem is creating the A record. The A table has a 1-1 relationship with the Record table.Some specific questions I have are:What should&nbsp;the process variables be set up like for this?&nbsp;How should the &quot;Create A record&quot; Data section be set up for this process?Both tables have Auto Incrementing IDs, is any additional setup needed for this on the actual Appian platform? If so, what?Are there any additional services or processes needed

Hello, Does anyone know how can I populate the&nbsp;node input &quot;Custom Cell Values&quot; on the smart service &quot;Export Data Store Entity to Excel&quot; with the result from the query that is performed on this node ? So basically, a query is performed on the DSE, then on the same node is it possible to map an existing template on specific cells with the result of that query?&nbsp; The same can be accomplished with plug-in &quot;Export CDT To Excel&quot;, considering an existing template and populating specific cells with CDT values. So, since this one is deprecated and Appian advices to not use this plug-in, how can we accomplish the same with this smart service ? Any ideas ? Thank you in advance

Hi, I have the below scenario. I have a master table to which I have to save the data initially. Later if any of the child tables have data then I need to store into respective tables. Also, I have to save the master table autogenerated key column into the child tables. Can someone advise, if I have to use any specific smart services to achieve this. Thanks in advance.

We are trying to get an excel document from a SQL Query and we are getting the following error:&nbsp; Export SQL To Excel An error occurred in executing an Activity Class. We tried to rewrite the SQL sentences using quotes but it keeps failing the same way. SQL Sentence:&nbsp;SELECT `ORDER_BY` AS `EMPLEADO`, `PLATO`, `IS_PAN` AS `PAN`FROM `SL_ORDERS` INNER JOIN `SL_LUNCH` ON `SL_ORDERS`.`LUNCH_ID`=`SL_LUNCH`.`ID`WHERE `SL_ORDERS`.`ID` IN (&#39;1&#39;, &#39;2&#39;) AND `SL_ORDERS`.`DIA_SEMANA`=&#39;1&#39;We know the problem is from the SQL sentence because if we put a typical Select * table without anything else works, so everything else is fine in the input section.

Import excel to Database smart service not including any rows where row is less than batch size.i am uploading an excel with 121965 rows in it with batch size 1000.now the problem is Appian is only considering 121000 rows and excluding last 965 rows. can anybody help?

Hi techie,&nbsp; I&#39;m getting following error while using writeToMultipleDataStoreEntities.&nbsp; Input Parameters - Entity - cons!DSE,Data - Record Type_______________________________________________________________ While I&#39;m using writeToDataStoreEntity with same parameters&nbsp; then I&#39;m not getting any error.

I&#39;m facing&nbsp;two issues:1. Warning is coming&nbsp;in process instance - Some referenced items could not be found. Please check the model and correct any problems.2. Action Complete banner flashes out..

I need to convert an excel document to the PDF, does anyone know&nbsp;how to do that ? Thanks in advance.&nbsp;

Hello, I have a problem in process model when trying to send email. I needed to implement functionality as follows:&nbsp; User needs to be on interface and enter email in textbox on which he wants to send email. After he clicks on the button email with document should be sent. User should then get information if email was sent or not on interface. For this I am using a!startProcess function on interface to start process model to send email. I have configured output message with all nodes having activity chaining at the end of the process model.&nbsp; Message is returned when email is successfully sent, but when email that user enters does not exist I have a problem. In many cases, process will break on send e-mail node if user enters email that does not exist.&nbsp; For instance I enter email ttestttttteee@gmail.com and process will break. But, if I enter email&nbsp;ttestttttteee@gmail.comm process model will continue and email will be sent. The problem is in email text after @ sign.

Hi all,&nbsp; when i want to save data in UI and then page&nbsp;jump out。 but i check the whole pm, chain every node and no error and the whole workflow in pm is fine .but just jump out . Below is my design.(just a mock) after i click save button in&nbsp; UI and run the yellow part ,then the page will jump out. BUt if click save but dont run yellow part ,the page will keep. the yellow part is a sub process model to save data into db. all sub process model node chain. any idea for this? looks like yellow part is root cause.

Hi, I have observed many a times that in a script task with multiple inputs or outputs, that have some complex operations like queries, each input/output of the script task is stored in certain&nbsp;pv!. During execution only few pv! hold values and rest remain null, but if I use two script tasks instead of one and split the work among both the script tasks it works as expected. What could be the issue, is there any limit on processing a script task?

Hello Everyone, I am getting a multiple instance of the task name,how to fix this issue? Thanks in advance,

Hi All, How can we achieve DocuSign or Adobe Sign over email. we have a use case, where a mail will be sent to an user, and the user has to sign the document to confirm the receive of the mail.&nbsp; We are using On-Prem version 22.1. Thanks in advance. Warm Regards Vineeth

Hi All, Is it possible to Zip a folder with multiple files and share the same to SAP. we are using on-prem version 22.1. Thanks in advance. Warm Regards Vineeth

Dear Team, Am using a!startProcessLink(),When User Click on Edit just am popule all values which we are passing through&nbsp;a!startProcessLink().But in interface am not getting values for a particular CDT.Getting two values out 13 columns.&nbsp; Sample Code: local!Billinfdetails:getting values from expression rule a!startProcessLink( processModel:Cons!ProcessModal, processParameters:{ billingDetails:local!Billinfdetails } ) when am mapping this&nbsp;billing Details&nbsp;to ruleInput in Interface&nbsp;not able to get the all values&nbsp;getting two columns values only. Can please help on this any one )

Hello, I see in a log file named &quot;db_PX...&quot; a lot of error :&nbsp;[Activity Chaining] Could not chain to attended activity.&nbsp; No attended activity with compatible assignment was found.&quot; but the related process seem working fine and I do not see any specific. The process is called by a webAPI and the result of the process is returned as result by the WebAPI. The process is very simple. The sub process called is Have you already received a similar warning ? I suspect the complex gateway. Regards Jean-Alain