Hi guys,
in the spirit of Christimas I’m in charge of a support group for people in need.
We have got a lot of applicants who really need our help to make sure their kids are going to get a gift this year.
I’ve got a ton of gift cards in a single column in excel, and I’d like to distribute all the gift card codes to the recipients.
Now here’s the kicker: the recipients have different amounts of kids, which means they need different amounts of giftcards.
I’m trying to figure out an automation that links a number of times from the recipients sheet to the gift cards code sheet, while never linking to the same code more than once.
The route I’d go would be to make a formula field which counts how many links are in a ‘link to an another record’ field, and if there’s less than the number of children in the family (a manual number field), then it keeps adding a new link from the gift card sheet.
But the last part is not really doable in automations, as I see it…?
Worst case: I’ll do it by hand, but it would be great to know how to solve it in Airtable.
How would you solve it?
Cheers and happy holidays !