- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 25, 2025 04:56 PM
Hi folks!
I have been stuck on an automation for a few days now 😕
I have two tables: "Tasks" and "Topics".
I used the "Topics" table to add a layer to my "Tasks" table.
Individual records in "Tasks" are nested under the appropriate "Topics" section.
The "Topics" table has a record (section) titled "Resolved".
When I update the status of a "Task" to to resolved, I want the record to move from its existing "Topics" section to the "Resolved" section within the "Tasks" table.
I cannot for the life of me figure out how to get this action to run! The closest I've got is trying to add the record ID of the "Resolved" topic, but it doesn't actually move the original record.
Thank you in advance!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 25, 2025 06:56 PM
WOW!!! oyu have done well and You're close! Airtable doesn’t let you “move” records between linked groups, but you can update the link to change the topic.
Try this:
- In your automation, use the "Find Records" action to find the "Resolved" topic in your Topics table.
- Then, use the "Update Record" action to change the Topic field in the Tasks table to the found "Resolved" topic’s ID.
This will update the task and place it under "Resolved."
If you're still stuck, let me know, and I’ll guide you through it! 😊
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 25, 2025 08:49 PM
Oh thank you! This makes sense what I am trying to accomplish! I think I am closer but still receiving an error, how does this look to you? Maybe I'm not filling the "Field" or "Record ID" portions properly?
Thank you so much for your willingness to help!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 26, 2025 03:44 PM
Hi,
actually, it's much easier. You phrase about 'moving' record is a bit confusing at a first sight 🙂
if your Topic table has only one record with 'Resolved' in primary field, all you need to do:
Just a note: record ID is usually looks like "recRAnd0m_14_cHaRs" chars are letters or numbers (not "_").
When you need to put record_id in automation, don't use @
But using a 'hardcoded' id is a very rare case. Usually you insert id of a trigger record (like on my screenshot), or, when you need to use result of 'Find records' (which can be a list of 0-1000 IDs ) , you choose it in a such way:
