Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Move record to new section when record is updated

Topic Labels: Automations
200 3
cancel
Showing results for 
Search instead for 
Did you mean: 
ashleyalward
4 - Data Explorer
4 - Data Explorer

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! 

3 Replies 3
Marvel
4 - Data Explorer
4 - Data Explorer

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:

  1. In your automation, use the "Find Records" action to find the "Resolved" topic in your Topics table.
  2. 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! 😊

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!

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:

Alexey_Gusev_0-1740612641043.pngAlexey_Gusev_1-1740612676923.png

Alexey_Gusev_2-1740612769666.png


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:

Alexey_Gusev_3-1740613428870.png