Not knowing your setup, I’ll have to speculate here, but in general — three tables: Donations, Requests, and Inventory.In the Inventory table, use a Rollup field for Quantity to automatically tally donations and account for requests. Link both Donati...
It's possible as I've done it at my company, but there’s no trivial solution. I can give you a general outline with some pseudocode on how I approached it. Feel free to reach out if you’re interested in a more detailed solution (marko@getsubsystem.c...
On a high-level, the script might look like this:Fetch Records: Use a GET request to retrieve all records from the desired Airtable base and table.Delete in Batches: Use DELETE requests to remove these records in batches.A couple things to consider:R...
Like you said, the idea is to compute: Generated Leads / Amount Spent. So you first need to associate leads with campaigns, figure out the cost of your campaign spending, etc. Here’s a very basic example that I put together. Each lead is associated w...
