Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Problem with automated updating field

Topic Labels: Automations
Solved
Jump to Solution
161 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I need to update field iloscZetonow to 5 each week. Where is the mistake?

Zrzut ekranu 2022-07-3 o 23.49.13

Zrzut ekranu 2022-07-3 o 23.50.32

1 Solution

Accepted Solutions

Looks like your Record ID field is set up incorrectly. You need to be passing the ID of the record you want to update into it, and it should look something like this:

Screenshot 2022-07-04 at 11.07.32 AM

To get the specific record ID of each record, add a new formula field into your table with the formula RECORD_ID()

See Solution in Thread

2 Replies 2

Looks like your Record ID field is set up incorrectly. You need to be passing the ID of the record you want to update into it, and it should look something like this:

Screenshot 2022-07-04 at 11.07.32 AM

To get the specific record ID of each record, add a new formula field into your table with the formula RECORD_ID()

In addition to @Adam_TheTimeSavingCo’s point above, are you trying to update one record every week, or every record in the table once a week?

The “Update Record” step is singular, it will only update one record at a time. If every record needs to be updated to a defined value every week, consider if using a Formula field would work.