Skip to main content
shubhamy0005
Known Participant
Jan 23, 2023 10:36 AM UTC
Solved

Update values in Appian

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!

    konduruc733182
    konduruc733182Answer
    Inspiring
    Jan 23, 2023 10:44 AM UTC

    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.

    View in thread

    2 replies

    konduruc733182
    konduruc733182Answer
    Inspiring
    Jan 23, 2023 10:44 AM UTC

    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.

      shubhamy0005Author
      Known Participant
      Jan 23, 2023 12:05 PM UTC

      Thanks Konduru, 

      This is helpful.

      Terms & ConditionsAccessibility statement