+2I’m trying to build an automation so that if I put ‘Regular’ in the ‘type’ column in the bookings table it will automatically populate the ‘populate issues’ column in the same table with all the entries in a list (‘issue date’) from the ‘Issues’ table. I can’t work out how to build this automation and get a ‘Received invalid inputs’ error. Can anyone help?
+31Hm 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:
+2This 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?
+31Hmm, 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!
+2So 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.
+1I 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
+1Hi Jayesh,
The "find result shows zero records" error usually happens when the automation conditions don't match exactly with your data. Here's how to troubleshoot and fix this:
1. Check Your Field Matching
Make sure the field you're searching by (like property type, location, etc.) exists in BOTH tables with the exact same spelling and format. Even small differences like "Budget Range" vs "Budget_Range" will cause zero results.
2. Verify Data Format
If you're matching on numbers, dates, or dropdown values, ensure the format is identical in both tables. For example:
- Numbers: "5000" vs 5000 (text vs number)
- Dates: Different date formats can cause mismatches
- Dropdowns: Make sure both tables use the same dropdown options
3. Use Conditions with "is not empty" First
Before your Find Records action, add a condition to check if the field you're searching by is not empty. This prevents the automation from running when there's no data to match.
4. Test with Simple Criteria
Start by testing with just ONE matching field (like property type only). Once that works, add more conditions gradually.
5. Common Fix for Owner/Tenant Tables
For your owner-tenant scenario, try this setup:
- Trigger: When tenant enters data via chatbot
- Condition: Property type is not empty
- Find Records: In Owner table where Property Type matches Tenant's Property Type
- Update Record: Update the matching owner record with tenant details
Feel free to DM me if you'd like to share screenshots of your automation setup for more specific guidance!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.