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
Jul 21, 2020 03:14 AM
I have 2 tables:
When I create a new workout I want to auto-link it to every customer in the customers table. Is there a way to do this?
I found a ‘hack’ of sorts on the forum - grouping workouts by linked customers and then adding rows from below the group that contains all customers. But the problem with this is that I need it to automatically include any additional customers when they get added to the customer table.
Any suggestions?
Jul 21, 2020 05:45 PM
Here’s an idea:
Create three tables:
Customers
Workouts
LINKER
Linker has two fields:
LinkName (Single Line Text)
Workouts (Link to the workouts table. Allow linking to multiple)
This table gets one record only. Name it “LINKALL”. Every time you add a new workout, add it to this record:
In Customers, add two new fields:
Linker (Link to the Linker table)
All Workouts (Lookup field: Look up the workouts from Linker)
Each customer’s Linker Field should be linked to that one record in Linker. It will then pull in all of the workouts.