AUTOMATION WORKS WHEN I TEST BUT WILL NOT RUN AUTOMATICALLY

So you’re submitting the form, but nothing’s showing up in Google Sheets?  Any chance there might be multiple forms set up in the base that might be causing some confusion?

On the off chance you’re expecting your current data to also show up in Sheets, Airtable Automations only trigger on new data I’m afraid, and so even if the current data was created via form submissions the automation won’t run on them

Yes, i have other forms, however, when i was setting up the automation I selected a specific form for which the automation will be run… I know that it only triggers on new data, I am aware of that but even with the new data, nothing appears… When I click the test button the data show up in the sheets… I don’t know what to do… I also tried changing the trigger to “When a record is created”…. I tested it, it appears to work but when i turn on the automation nothing happens…..

Do i need to use third party apps to get it to work?

Hmm, if you could DM me an invite link to your base I could try to take a look for you?  Just tried this out and it worked fine for me:

But yeah if you can’t get it working this way then third party apps like Make, n8n etc are your only bets I guess

Just a quick question, does your Automation Run History show anything when you submit the form?
 

Since your automation is active, it should appear there if it’s getting triggered. That will help us confirm whether the automation is running but not updating the fields, or if it’s not being triggered at all.

So do check the run history and let us know what you find. That will give us a better idea of where the problem might be.

Taha, Airtable Advisor

Here is the automation history… It says that i have reached my limit… My limit is 100 runs per month.

I’m just on 17.

​@danidarko93 

Based on your automation history, it looks like your automation isn’t getting triggered because you’ve hit your monthly automation run limit. That’s why it’s not firing when you expect it to.

In your tests, it works fine because you’re selecting existing records, so the automation does not actually run a new trigger.

If you feel confident that you haven’t used up your full limit yet, the best thing would be to reach out to Airtable support directly. They’ll be able to confirm what’s going on and clarify why the system is showing that the limit has been reached.

Taha, Airtable Advisor

Also just to clarify, you’ve run this specific automation 17 times this month, but the 100 run limit is for all automations in your entire workspace. So if there’s another base with an automation in it those runs add up too. This would also count if your workspace is shared with someone else and they’ve made a base with an automation.

Alright…. Let me upgrade to a paid plan and see if it works

Thanks for the information…

I will let you know if it works