Next thing is to make an automation so that the formula fields populates a specific URL field with the webhook URL + record ID when a record is created. The webhook URL field gets displayed as a button in Stacker.

Then I used the below workflow in Make, which: • Receives the record ID when the button is pressed in Stacker • Finds that specific record back in Airtable • Then uses the array aggregator to select which specific fields to copy (in this case, it's all the non-automated fields which users can see and edit in my Stacker app) • Then creates a new record in Airtable, mapping/copying the array data exactly. • Then refreshes the page in the Stacker app for the user, so that they can see there's been a response.

Notes: • As the button is made by an automation after the creation of the record, users can't actually use it for up to 15 minutes due to Stacker's data refresh rate. • It's the same with any records they copy - they go straight into Airtable, but won't appear in Stacker for up to 15 minutes. • I wasn't able to figure out how to copy attachments, nor could I exactly figure out how to copy checkbox fields or single selects - so I either changed them to text values (single line, rich text or linked records), or created what I call functional or "admin" fields in Airtable which populate with text via an automation when my users fill out the "actual" single select/checkbox fields. I mapped these in the Make workflow, then have some more automations in Airtable to fill out the "actual" values from the admin fields.

So, not necessarily pretty - although it'd be much better if that immediate data refresh gets implemented 😉 - but it does work.

And this is what my users will see when I enable the button (apologies, we're a very purple charity)