Forum Discussion

MattGraham's avatar
MattGraham
Qrew Member
6 years ago

Increment the value of a Num field via automations.

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.
Quickbase Automations
Tables and fields

3 Replies

Sort By
  • KevinSlider's avatar
    KevinSlider
    Qrew Trainee
    6 years ago
    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? 

  • MattGraham's avatar
    MattGraham
    Qrew Member
    6 years ago
    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's avatar
      KevinSlider
      Qrew Trainee
      6 years ago
      Thank you, I need more automation examples like this. Id like to see the details.