I have a script that takes the records in a table called "Runs" and creates a separate entry in a table called "Breakout" for each linked entry in the "Runners" field. However, this script is currently only able to run manually, and if it's run mult...
I am running an event where there are multiple participants that can participate in multiple events. I know how to link the Participants and Events tables together. However, I have a need for a view or third table that lists out each unique pairing...
I am attempting to calculate asset depreciation using Airtable. I am calculating using the following Fields:
Purchase Date: Date field
Unrecovered Basis 1: A formula which is returning a currency value
1 Year (from Depreciation Conventions): This is...
You gave me something to think about. I don't think this'll work for my needs because there are literally 100s of events, but it's at least a step in the right direction! Thanks
Maybe I should rephrase the question. I'm looking for a script that runs on record creation that takes a field that will have at least one, but possibly more linked records, and writes them out to another table individually.The final output would lo...
