Skip to main content

Update Record Automation


Forum|alt.badge.img+4

Hello,

I was hoping that somebody could tell me what I have set up wrong in this update record automation. Every time it runs I get an error message emailed to me. I have included three screenshots, one for the trigger, one for the find records action and one for the record update action. Any help I could get would be most appreciated.

7 replies

RockyCCChong
Forum|alt.badge.img+10
  • Known Participant
  • 28 replies
  • August 12, 2024

What's the error message?


Forum|alt.badge.img+4
  • Author
  • Participating Frequently
  • 5 replies
  • August 12, 2024

The record does not exist


RockyCCChong
Forum|alt.badge.img+10
  • Known Participant
  • 28 replies
  • August 12, 2024

I think this should be (Airtable record ID) and not a list. 


Forum|alt.badge.img+4
  • Author
  • Participating Frequently
  • 5 replies
  • August 12, 2024
RockyCCChong wrote:

I think this should be (Airtable record ID) and not a list. 


I thought so too, but it only lets me select List of Airtable record ID if I use the Find Records step. I had read somewhere that I didn't need it and when I took it out, then I could select just Airtable record ID, but it returned the same error.


Sistema_Aotearo
Forum|alt.badge.img+18

It's looking for the EXACT Record ID. Inserting the list won't work as it won't find a record that's a string.

Use the advanced logic, Repeating Action. You can use the find records step as a list. Then move your update record step into the repeating section. Chang it's Record ID configuration to read from the repeating logic.

 

Hope this helps.


RockyCCChong
Forum|alt.badge.img+10
  • Known Participant
  • 28 replies
  • August 13, 2024
thursday_pools wrote:

I thought so too, but it only lets me select List of Airtable record ID if I use the Find Records step. I had read somewhere that I didn't need it and when I took it out, then I could select just Airtable record ID, but it returned the same error.


I mean like this, within the Update records step. 


TheTimeSavingCo
Forum|alt.badge.img+28

Could you provide screenshots of the relevant tables and talk abit about the business use case here?  Understanding what you're trying to do and seeing how your base is set up will be very helpful in troubleshooting


Reply