Just surprised… Automations do not run if data entered in the mobile app and the field is the trigger (text field non-empty trigger). Meh, that is disappointing, still need to go back to the PC to do data entry in cases like this. Maybe this is technically not possible, but that would be on my wishlist if the Automation was running on mobile as expected.
- Full HTML support in automation
- Form/application in scripting both in extension and in automation
- Native Plecto integration for tables to be used as database for Plecto.
- Pandadoc support, with creation of contracts with info from records, and then backwards updating on changes like signing. (In generel programs for contract creation)
- Typeform extended features to update records in Airtable also instead of only creating records.
Many of these features would make Zapier cheaper because less tasks would be used, and more could be done within the Airtable environment.
@Theis Welcome to the forum. Plecto, Pandadoc, Typeform - maybe you need to reach out to them. They need to approach Airtable. Have you tried Make @ScottWorld PandaDoc and Integromat
What do you mean full HTML support in Automation?
Wish Airtable provides better notification about when the Automation is disabled because there is an error in the trigger. Right now, there is no alert. If the trigger breaks due to changes done in the table, the Automation affected gets disabled and there is no notification, no alert, no email nothing.
The reason trigger broke could be e.g.:
- formula was changed so that the result is no longer a number but a string and automation will fail.
- the field is a formula field producing a date and the formula was changed, if the source input field are empty and the formula still forces formatting as date (DATE_FORMAT) then the result in the field will be ERROR and the Automation will also fail.
This is different from the situation when the Automation “fails”. If the automation fails to run, because the record got deleted, then I see an alert.
Not however, if the trigger gets broken. I am looking at all alerts and there is nothing, no alerts for last 2 weeks, all running smoothly, yet, when I look at the automation run history, the automation was disabled just 2 days ago and this is what it says in the run history:
Also, when the Automation gets disabled, the icon could be RED color (OFF) or something different, like this one.
This is however not an icon that shows when the automation fails, when Automation fails, the icons is just grey color OFF, so there is no visual tag.
The exclamation in red triangle happens if there is something wrong or changed in the automation like email connection changed etc.
So I wish at least this type of icon is used for Automations that:
- are disabled because trigger is broken (as described in this post)
- fail because there is an other issue.
Both situations the icon should be visible.
Long lives this thread.
Is something happening on Airtable end with some of the suggestions we provided?ver
Also, since @Theis brought this up finally a good point, surprisingly nobody here mentioned scripts here in this long post. Airtable should allow running scripts in Automation for all billing plans. Only available for Pro and Enterprise plans How to Run a Script Action | Airtable Support. Unfortunately most people populating this forum are on pro or enterprise plan so I don’t think this is anywhere near on the agenda when it comes to voting for features, but this is something Airtable already has.
Hey there @itoldusoandso .
I will try reach out to those.
Regarding HTML in automation, I can elaborate. If you want Gmail or other mail as an action to a trigger they only support rich text formatting and not complete HTML, meaning that you can’t paste an HTML template from Stripo (just an example) into it. Only way this can be done, is through an app like Sendgrid triggered by a button or just okay running it. But it’s not available in Automation.
I would like my automatic mail setup to actually skip Zapier on this, but I can’t, since Zapier supports full HTML, so I’m using them to send the mail template.
Hope it makes sense.
Give us shortcut for the Apply button in the Filter popup window.
The new Filter popup has an extra Apply button. But this only appears if the database has a lot of records or a lot of fields. Otherwise there is no button and the changes in the filter are reflected in the table right away, which is a perfect compromise… The issue is if there are large number of records or fields the table is slow and changes on the fly would freeze the table for a bit. Smaller tables have no issues loading instantly so I am glad they left the filter in those cases without the button. Personally I hope it is going to stay that way.
However, what I wish they could have done better is to give me a way to hit that button without having to use mouse to click the button. They could have enabled a shortcut for the button, e.g. ctrl+enter or alt+enter or something similar. It’s better for the workflow.
Make the popup window wider and allow to see the name of the view. Currently any any part of the name of the view that is beyond 18-20 characters is obscured so it is difficult to pick the right view when I am copying settings.
Same for the automation name box. Waaaay to small.
This is likely just my wish and nobody’s else:
Allow dynamic conditions for rollup formulas.
All I can do now is to statically compare to cell values. Can’t compare to another cell dynamically. What’s the use of conditionality if I can’t control the condition based on the values in the other table. I know there are work-arounds but in my case they wouldn’t work because I setup dynamic variables all across my base to run mass updates across different values and tables so I don’t need to use extensions.
Here is what I have setup and I didn’t find a way around the dynamic condition for roll up field. I just need it there to be able to fine-tune my batch-updates.
Yes, it’s mentioned earlier in this thread.
For Automation, I guess you mean the name in the top middle column, right?
If you try to rename the automation from there, the box becomes even smaller
Just for info, if you need rename the automation, you can also rename it by right-clicking on the left panel:
That’s what I found later, so it’s a bit less of a problem now at least with renaming the automation.
Adding conditions in the Filter box makes the focus jump to the very end of the conditions list.
When I am adding Conditions in the Filter in the table, the focus always keeps jumping at the end of that filter box. So if I have 49 conditions there and if I add the 50th condition, it doesn’t matter where I add that condition, the focus jumps to the end of that filter box. Even if I add the additional condition somewhere at the top in the hierarchy of nested conditions, still the focus keeps jumping to the end. So if I need to add multiple conditions, I keep scrolling up back to where I was in that nested condition. Driving me mad.
I did mean in the top middle column
Hey Community,
First off, I’d like to thank @ScottWorld for inviting me here to post!
My name is Avi and I’m the VP of Partnerships at SmartSuite. SmartSuite is a work management platform that looks and feels like Airtable but we tried to address many of the pain points and we listen to our customers & partners very carefully to address any pain points they might have.
@ScottWorld and I have been going back and forth recently on some of the Airtable pain points that we have been able to solve and @ScottWorld has been encouraging me to post them on this thread so here we go:
- The issue with the number field has been solved in SmartSuite.
- SmartSuite sends an email and in-app notification every time there’s an error with an automation
- We are working on the ability to purchase more automations and will have a very exciting announcement to make in the coming weeks about the number of records we can handle. Stay tuned!!
- Dynamic choices in linked record fields is live in SmartSuite! Feel free to check out this video to learn more how this works.
If you’d like to learn more about SmartSuite please feel free to give us a try and let us know what you think and how we can improve.
Hey Scott, We did our best to solve in SmartSuite with our SmartDoc filed type. is this what you mean?
Hey @ScottWorld when you set up a linked record filed type in SmartSuite we have sorting, filtering, and fields to display settings. Is this what you mean?
I use nested forms in Airtable quite a bit to shorten the forms. However, the pre-fill doesn’t work for fields that are conditionally hidden! So if I set in the form some fields to be conditionally hidden in that form and I generate the pre-fill link, the text into the fields that are hidden because of that condition will not be pre-filled. Here is what I mean:
Allow us to have unlimited DISABLED automations. Do restrict me to maximum 50 automations both enabled and disabled. Make it same as with extensions. Allow me to have 50 automations that are turned on, that should be the limit. I want to have other automations which I have saved as backup or simply do not use them right now etc…
Looks like this post did reach a dead end now and it is becoming a SmartSuite forum.
In automations, when setting Conditions for different action groups, I’d love to be able use dynamic values for Dates as well.