Hi Everyone,
I have a database field whose value needs to be reduced by 1 every day. Can anyone please suggest how to achieve this in Appian?
Thank you!
Discussion posts and replies are publicly visible
Hello shubhamy0005,
You can create a process model which runs every day. You can configure a timer in the start node and it will start everyday on the given time.
next to your start node you will need a script task where you will fetch the data and will reduce your value by 1. ie, pv!yourvalue-1 . Make sure you write a validation or rule to skip this step if your value is =0.
next to your script will be your write to data store entity or your write to records.
Thanks Konduru,
This is helpful.