Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jun 08, 2022 06:08 AM
I community,
I need your help.
Actually i sell subscription plant.
The customer choose 3 or 6 month.
I create an automation on Airtable which duplicate the record (by month choose by the customer) and the automation associate product to delivery :
for example : order 201821222
The customer choose 3 month, the automation duplicate :
M1- 201821222
M2 - 201821222
M3 - 201821222
On these records, i have a column with the plants we have to send.
My needs : i want to display on interface the plant send on the previous month.
My employee could choose the plant depending on what has already been sent.
So, how can i associate these records and display the history ?
Thank’s for your help,
Matthieu
Jun 08, 2022 07:45 AM
Do you have only a single table, or do you have two linked tables: one for [customers] and another for [plant deliveries]? I recommend a two table system, and then you can use rollups to pass around info between the two tables.