Hello, I was just wondering if it would be possible for me to get the results from one table and make them automatically appear on another table within the same sheet?
Yes! You have several options to automatically transfer data between tables:
Send Table Data: Click Actions → Send table data, select your destination table, and choose either:
Send row - transfers each row as-is
Send row for each item in a list - creates separate rows for list items [1]
Write to Other Table: Use this enrichment to map specific columns from your source table to the destination table. You can set it to auto-update when new rows are added [2]
Lookup Rows: Pull data from other tables using Lookup Single Row or Lookup Multiple Rows - works like VLOOKUP in spreadsheets [3]
All methods work within the same workbook and can be automated to keep your tables in sync.
Is that what you were looking for?
If you need any more help with transferring data between tables or have other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so I can support you further?
How do I start the “lookup multiple rows” action?
To start the "Lookup Multiple Rows" action:
Click Actions → Lookup Multiple Rows in Other Table [1]
Configure these inputs: • Table to Search - select which table to look in • Target Column - the column to search within • Filter Operator - how to match the data • Row Value - what value to search for • Limit (optional) - max rows to return [2]
That's it! The action will pull all matching rows from your target table. [3]
Did that answer your question?
If you still need help setting up the "Lookup Multiple Rows" action or have other questions, I’m here to assist. Would you like to share more about what you’re trying to accomplish so I can provide further support?
When I go to ‘target column’ I am unable to select certain columns - how can I get those columns? For example I want it to find/lookup ones on a different table where the lookup output is ‘true’
If columns aren't showing in the Target Column dropdown, they might be hidden. Check the Columns button at the top of your table and toggle on any hidden columns you need. [1]
For boolean values like 'true', make sure the column data type is set correctly. Click the column header and check if it's set to the right data type (Text, Boolean, etc.). [2]
The Lookup Multiple Rows action searches within the Target Column you specify, so ensure that column contains the 'true' values you want to match against. [3]
Is that what you were looking for?
If you need any more help with selecting columns or setting up your lookup action, I’m here to assist. Would you like to provide more details about the specific issue you’re encountering so I can support you further?
