Skip to main content
S
shubhamy0005
January 23, 2023
Solved

Update values in Appian

  • January 23, 2023
  • 2 replies
  • 0 views

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!

    Best answer by konduruc733182

    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.

    2 replies

    konduruc733182
    konduruc733182Answer
    January 23, 2023

    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.

      S
      shubhamy0005Author
      January 23, 2023

      Thanks Konduru, 

      This is helpful.

      Terms & ConditionsAccessibility statement