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:
- Trigger = Record Meets Conditions
- 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