Help

Automation with script to take specific field value + a #, and update same field to the new total

Topic Labels: Automations
1809 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Cole_Wedemeier
6 - Interface Innovator
6 - Interface Innovator

Hello!

I have a table in which a student’s “Start Date” is captured in a date field. There is then a # field that indicates the “# of weeks” the student is in the course. Then lastly is a formula field that takes the Start Date + # of weeks = Graduation Date.

A student is allowed to renew for an additional 12 weeks.

I would like to create an automation where the following occurs:

  1. Trigger = Record Meets Conditions
  2. Action = Run a script that would take the records current # of weeks + 12 and put that new total into the # of weeks field.

I simply cannot make heads or tails of scriptwriting to get something that works and am hoping someone else can assist. I feel like this is probably something very easy, and I really don’t want to add a few more fields along with messing with the original formula for Graduation Date, if I don’t have to :slightly_smiling_face:

2 Replies 2
augmented
10 - Mercury
10 - Mercury

Hi Cole. You actually don’t need a script, just another formula field (I hate field clutter too, but I keep stuff like that hidden anyway) that adds 12 to # of weeks. Then, in your action (update record), just set # of weeks to the new formula field. Make sense?

Hi,

add script step and set weeks as input variable

image

use “newWeeks” in next step (Update record or whatever)