Skip to main content

Update Tables via new records from Master Table

  • March 6, 2024
  • 1 reply
  • 2 views

Forum|alt.badge.img

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

1 reply

TheTimeSavingCo
Forum|alt.badge.img+28

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


Reply