Automation - pull in list from one table based on data entry in another table

Hm assuming your end goal is for that ‘Regular’ record to be linked to all the found records, then you could do this instead and I’ve set it up here for you to check out:

And this is what it looks like in action:

The record ID is the triggering record’s ID:

And the linked field is populated with the IDs of all the found records:

This is amazing - thank you so much Adam. I spent hours trying to work out how to do this and was about to give up - really appreciate your help! Can I just check - will the issues field in table 1 update automatically if the issues are changed in the column/table it pulls from?

Hmm, data changes of linked records will show up automatically via lookup / rollups, but the links themselves won’t change I’m afraid.  What would be changing on the issues side?

I do free half hour calls and would be happy to jump on a quick Zoom with screenshare to try to help too!  

So sorry for the delayed reply. I think you are right - the issues shouldn’t update too often so think this solution will work. Many thanks for your help.

I am new to Airtable,facing issue as i have two tables owner and tenant having data property type,subtype,location,budget range,urgency criteria in both.

I want to update/ fetch matched data when iwner/ tenant enters their data through chatbot automation in table.

When I do set up with update record automation & set condition but it shows error/ find result shows zero records.

Can anyone help me? Please

Only linked record fields can be automatically filled up by automations; simple text lists cannot. Verify that the record field "populate issues" is linked to the Issues table. Then, when Type = "Regular," start the automation and update that field. The "invalid inputs" error will appear if the field types don't match.