- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 06, 2024 09:12 AM
We have a master table to track all bookings made on our platform, There is then a table for each partner location we have, I would like to automate the updating of the individual locations tables when a booking is added to the master list.
Example, Booking 123 is added to master booking list for New York Store, -> Finds table named New York Store -> Adds the new records details to this table
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 06, 2024 06:21 PM
Hmm, I think I would try:
1. Create an automation that'll trigger when a new record gets created
2. Add a conditional step that determines which location its in
3. Add an "Update Record" step that'll create a new record in the appropriate table and link it to the triggering record
And then in all the partner location tables I'd add lookup fields to display the data from the main record