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
Dec 11, 2021 07:04 AM
I’ve got a base with three different forms feeding it. One is for people, the other is for tasks, the last is for a reward.
As rewards are submitted I want to randomly pair the reward to a task.
Is there a way to automate this process?
Dec 11, 2021 10:59 AM
Because you want a random selection, you will need a script.
My script store includes a script that links to a random record. You will need a pro subscription in order to run the automation script, but the apps script can be used with free bases. In your [Tasks] table, you will need to create a filtered view of tasks without rewards, and set the linked record field in the [Rewards] table to limit selection to that filtered view.
Note that this script will link only one task to each new reward record. If you need to link multiple tasks to the same reward, you will need a different script.