how to schedule a process model from database insert or update

Question

Hi Folks, 
 
 How can I schedule/ trigger my process model so that it will start on a row insert or update in da custom database table. 
 
 Regards, 
 Ghanashyam

GopalK · Answer

HI, you can configure triggers in your start node of the process model based on timer. There you would get multiple options to configure the timer.

Harshit Bumb (Appyzie) · Answer

Yes, you can schedule a process. Check in the properties of the Start node and there you can find the timer trigger.

Manish_Kumar · Answer

Hi Shyam, 
 you can configure a timer in a PM or if you have different type of process to trigger on different use case you will need more than a timer to server your use case. Once you make an entry to a DB (insert/update) , you can make 1 more entry on a new table which will decide to trigger which process or not ?. once you done this you can configure a timer to trigger a process which which check the entry and trigger the respective process.

Dave Lewis · Answer

The question is where is the data being written from? If it's being written from Appian itself, then have Appian kick off a process immediately after it does the write. If the data is coming from salesforce or similar, you can configure that system to call Appian API or send email to Appian to start a process when it does a write. 
 I agree that it's an anti-pattern to put business logic into your data container. The trigger doesn't need to be IN the database to be a trigger.