Button - Run automation - in interface

Hey ​@Cordula,

My first comment is that usually if you are trying to get data copied from one table to a different table, there is usually a bigger issue with how your database architecture has been set up. Would you mind briefly describing your use case and what is it that you are trying to achieve?

Now, regardless of the above:
1. Airtable does not allow you to have buttons triggering automations within list pages.
2. What I’ve done in the past to achieve this exact thing is to create an automation that gets triggered when a webhook call is received.
3. First thing I tried was to have my button open a new tab with the webhook url. However, these are GET requests, and Airtable automation only get triggered with POST requests.
4. So what I did was: create an n8n automation (you can use make.com or any other automation tool) that get’s triggered with its own whebhook, receives Airtable’s webhook url as a url parameter, and runs a code node to make the POST rather than get.
5. Within Airtable, your automation will get triggered now. Next step is to set up a Find Records action block, which will search for all records applying the same filters you are using on your interface.
6. Fianlly, have a repeating group and an update record action block within it.

If you need further help, or would like me to show you around, I’d be happy to go through it on a call :D

Feel free to grab a slot using this link.

Mike, Consultant @ Automatic Nation 
YouTube Channel 

Hi ​@Cordula,

As ​@Mike_AutomaticN wrote above, this isn’t natively possible within Airtable.

However, what I usually do is create a form for my users to fill out with the information that they’re filtering/searching for, and then the form submission will trigger an automation — in either Airtable or Make — to search for the relevant records and perform the necessary actions.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

I don’t know, this sounds pretty basic to me in native Airtable. You would need to start with a ‘blank’ interface, which still supports ‘Run Automation’ buttons. Add the tables and filters you need to the interface as well as the button. The button would trigger an automation with a scripting step. You’ll need a little JavaScript to make it do what you want, but there is plenty of flexibility to do anything at this point.

I agree with Mike above that the idea to copy records from one table to another may be an indicator that you could do better with a different data structure approach.