Skip to main content
Solved

Resetting fields on a "shift duties" board daily with 'update record'

  • April 22, 2025
  • 4 replies
  • 83 views

Forum|alt.badge.img+3

Hello, I was hoping to get some guidance on what I’m doing wrong in regards to updating the “completed by” field on a salon “shift duties” board interface. My partner built the base/interface for her salon and has asked for help in making the automation work.

The goal would be to change the drop-down for each task to “not done” every night via a scheduled trigger.
I’ve found a few related topics and used those to guide me but I can’t seem to get past testing the actual record updating part.

If I utilize the list of record IDs from the ‘find records’ step, I end up with ‘ received invalid input’ errors.

My automation process:
Scheduled Trigger → Find Records (Where “Completed By” is any of [all options selected]) →  Repeating Action Group (Repeat for each in [List of records]) and →  Update Record (Record ID is list of all records found previously - “Completed By” field updated to “not done”)

A couple pics of my attempt:




I would love to know what I’m doing wrong! 😑

Pic of the interface for context:
 

 

Best answer by DisraeliGears01

I think the issue is your update action is still trying to impact your whole list rather than each item individually. Try changing the Record ID in the Update Record action to “Current Item in list” instead.

 

4 replies

DisraeliGears01
Forum|alt.badge.img+21
  • Genius
  • 301 replies
  • Answer
  • April 22, 2025

I think the issue is your update action is still trying to impact your whole list rather than each item individually. Try changing the Record ID in the Update Record action to “Current Item in list” instead.

 


Mike_AutomaticN
Forum|alt.badge.img+28

Hey ​@vivrance!

@DisraeliGears01’s answer above seems to be correct! Please let us know if that solves the issue. 
 

Othwrwise, feel free to schedule a call using this link and I’d be happy to take a look at it. 
 

Mike, Consultant @ Automatic Nation


TheTimeSavingCo
Forum|alt.badge.img+31

Does this look right?

If so, I’ve set it up here and you can compare it to your current set up


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 1 reply
  • April 23, 2025

Thank you everyone for the replies, ​@DisraeliGears01’s  advice was right on the mark. I used the selection “@ Airtable Record ID” from the ‘Current Item’ list and that did the trick. I tried doing a test immediately and somehow it missed the time it was set for, so I set it for overnight and it worked just fine!

Thanks again, y’all. Much appreciated!