So sometimes I find myself in a situation where I want to do something that sounds simple: I want to link a record to multiple records at a time. Which is usually easy if there’s only one linked record present in a field, but not so much if linked records already exist.

I can’t copy and paste because that will overwrite the existing records and I want to keep those. I can technically update it bulk from the PTO Requests table, but only if I have my People names in a comma-separated array, which I don’t. So I’m using a script.

I’m sure you can dial this into your needs a little bit more, but this script works by adding everyone in the People table to the visible records in the Holiday view of the PTO table.

See the Source for example photos.

Check out this example PTO Tracking Base.