Randomly matching two columns from separate tabs

Topic Labels: Automations
980 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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?

1 Reply 1

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.