Increment the value of a Num field via automations.

Question

I'm&nbsp;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&nbsp;change the field at all.

kevinslider · Answer

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?&nbsp;

mattgraham · Answer

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.

kevinslider · Answer

Thank you, I need more automation examples like this. Id like to see the details.

Forum Discussion

Increment the value of a Num field via automations.

Related Content

Find and Replace Field Values

Using AND with Null values

Jinja If statement equals field value

Grabbing value between 2 fields

Incrementing a field values based off another field's content.