Skip to main content

Get data from a linked record back to the original sync table

  • November 22, 2022
  • 2 replies
  • 26 views

Forum|alt.badge.img+4

Hello,
I’m going to try to simplify my issue as much as possible. Hopefully it will be clear enough.

I have 2 bases : Operations & Purchases.
In Opérations I have a table with all my Orders.
In Purchases I have a table with all my Suppliers.

The Suppliers table is sync to the Operation base, and then my Orders’s records are link to the Suppliers still in my Operation base.
When I create a new Order I add the related Suppliers.
So on my Suppliers table in the Operation base I have for each supplier the listing of all the related orders as linked records.

Now I would like to have this same listing back in the Suppliers table, but in the Purchases base. And not as text field, but as linked records as well.

Is it possible ?

Thank you in advance

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • Brainy
  • 6460 replies
  • November 23, 2022

Hmm, if I’m understanding you correctly, you could:

  1. Sync the Orders tabe from Operations base into the Purchases base
  2. Create an automation in Purchases where, every time a new record gets created in the Orders synced table, it’ll link said new Orders record to the Suppliers record in Purchases

Should work I think


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 1 reply
  • November 23, 2022

Thank you for your advise Adam.
I’m going to try it out and let you know.
Have a great day