Help

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

Solved
Jump to Solution
2935 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Quentin_Debray
5 - Automation Enthusiast
5 - Automation Enthusiast

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:

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Create the formula field in the grid view.

See Solution in Thread

6 Replies 6

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”.

image

kuovonne
18 - Pluto
18 - Pluto

Create the formula field in the grid view.

Quentin_Debray
5 - Automation Enthusiast
5 - Automation Enthusiast

image

yes that’s what I did

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!