Increment the value of a Num field via automations.

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
I'm using a combination of webhooks and automations to fire off emails on a 48 hour schedule for certain records. I have a num field that defaults to 0 in this table and I am wanting to increment that number by one whenever this automation runs. Is this even possible? I've tried doing [Field Value] + 1 and it doesn't change the field at all.
Photo of Matt Graham

Matt Graham

  • 100 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
It seems like that would work. have you made certain the record in question has a value of 0? meaning you set all legacy data to 0? 

Photo of Matt Graham

Matt Graham

  • 100 Points 100 badge 2x thumb
If you set the new value as 1 + [Field] the field will set to 1. The reverse operation will set it to the value currently in the field. 

For now, I'm going to create a hidden calculated number field equal to [Field] +1 and copy the value over every time the automation runs. 
Photo of Slider

Slider

  • 1,292 Points 1k badge 2x thumb
Thank you, I need more automation examples like this. Id like to see the details.