Solved

How to add 1 to a field when a record is updated

Hello world,

I’m new to airtable and to this community and I think that I need your help :pray:

I have a integer field (called “votes”) that is set to 1 when a record is created.
I have a checkbox field which is not filled by default.

I created this automation :
When record matches this criteria = Checkbox is filled
Then I want to update the record’s field “votes” by adding 1

But as it’s a integer field I can only “Add a number” :confused:

Can you advice me on what should I do please ?

Thanks :slightly_smiling_face:

Best answer by kuovonne

Create the formula field in the grid view.

+29

Welcome to the Airtable community!

Create a formula field that adds one to the integer field.
Then have the automation update the editable field with the formula result.

Welcome to the Airtable community!

Create a formula field that adds one to the integer field.
Then have the automation update the editable field with the formula result.

Thanks :winking_face:

That’s what I tried but the only thing I can do my field is “Add a number”.

+29

Create the formula field in the grid view.

yes that’s what I did

Create the formula field in the grid view.

I figured it out !!! :smiling_face:
I’m not sure it’s the best way but it still works
thanks :handshake:

I figured it out !!! :smiling_face:
I’m not sure it’s the best way but it still works
thanks :handshake:

Hi there! I'm also trying to set this up, could you please share how you got this to work?

Thanks!

Sign up