Showing ideas with label automations and scripting.
Show all ideas
Status:
New Ideas
Submitted on
Dec 11, 2022
06:06 PM
Submitted by
tlloydthwaites
on
Dec 11, 2022
06:06 PM

We use RabbitMQ a lot to take action when certain record events happen. For example, when users are created in a table, this sends a message which triggers account creation in other systems. At the moment, we use scripting automations to send POST requests to our RabbitMQ HTTP API. This is cumbersome, and there's no way to listen to events without creating webhooks. We would love first-class AMQP integration in Airtable. This would look like: In automations, the ability to send an AMQP message with a routing key and payload Ability to listen to an AMQP topic and take action
... View more
Submitted on
Nov 25, 2018
08:59 AM
Submitted by
Drikus_Eksteen
on
Nov 25, 2018
08:59 AM

I am using Airtable for our Cattle Trading Marketplace and also for the Animal Feed business I’m involved in. I want to use Page Designer to mail first the deal information and secondly the contracts for each deal. It will save me hours of time because from the records, the dealsheet and contract get populated with data, and if I can just email it as a PDF it will be super. In the mean time thanks for a great effort with Airtable. Never heard of it since a few months ago, but it is awesome and a real lifesaver. Kind regards,Drikus EKsteen
... View more
Submitted on
Mar 25, 2022
02:52 PM
Submitted by
Sticker_ninja
on
Mar 25, 2022
02:52 PM

Oftentimes my automations that include a scripting step don’t fail but also it don’t behave the way I want or expect. I want to be able to search/filter the run history of an automation based on the primary field of the record that caused the problem. That way I can find the run log and troubleshoot the issue via console logs I included in my scripting step. 🙂
... View more
Submitted on
Jul 05, 2020
10:07 AM
Submitted by
typo
on
Jul 05, 2020
10:07 AM

The scripting block is cool. But a lot of us use AirTable because we don’t know how to code. I’d love for someone to create an AirTable block (or feature) which would let me script automations through a Zapier-style interface. (no coding knowledge required). In my dream world, this would not only script automations within an AirTable base, but also between AirTable bases, and ALSO between AirTable and other software with API hooks.
Also: it makes me grumpy to have to pay extra for Zapier. This should be a feature within the AirTable pro plan.
... View more
Submitted on
Nov 25, 2018
08:16 AM
Submitted by
typo
on
Nov 25, 2018
08:16 AM

I work in film and video production. When I bring on a crew, I have them fill out a form which lists name, e-mail address, mobile phone, food allergies, scheduling conflicts, their production department, and their production title. The problem is, this information needs to be distributed into two different tables: One table holds name, e-mail, mobile phone, & food allergies-- that information tends to stay the same from production to production, so I keep that in a “master contact table” (which I also use as my general address book) Another table (the “Roster” table) holds the person’s scheduling conflicts, production department, and production title-- that information differs from production to production, so I don’t want to keep it in my master contact table because the same contact might work on different productions in different roles and I need to keep track of who did exactly what on each production. (Yes, I could just keep it all in the “Forms table” and try to manage everything with filtered views, but that would be unwieldy because each contact could be entered multiple times-- making it clunky as an address book) Because air table forms only allow information to go into a single table, I have to go through some crazy gymnastics in order to get the information from the crew form into the appropriate fields. Currently, I do this: I have a THIRD table, a “Forms” table which collects information for all of the fields. I have a Zap which 1) pulls the name/phone/e-mail/allergies info from the forms table into the master contact table (updating an existing record or creating a new record as needed) 2) copies the name/department/role/scheduling conflicts info into the rosters table 3) links the name record in the rosters table to the name record in the master contact table (and finally) 4) deletes the record in the forms table once all of the information has been moved into the correct place. This multi-step Zap costs $25/month. However, if I could create a form with field inputs from multiple tables (instead of being limited to my form only inputting information into a single table), I could save myself a lot of money and headaches.
... View more
Submitted on
Nov 12, 2020
02:44 PM
Submitted by
jowan_qupty
on
Nov 12, 2020
02:44 PM

Can we please allow scripts to be run through links?! I believe this could potentially have many use cases. My Use case. I recently built a base for a client who owns a large Portfolio of real estate assets and wanted a flexible Property Management System, so i decided to do it on Airtable. I have built many scripts that automate tasks such as creating new tenant contracts + simultaneously creates new corresponding bills, scripts that spit out custom reports such as a City Report, Building Report, Unit Report, or Tenant Reports. When running the City reports (it shows a list of all buildings in that city + relevant information about each building), it would be nice to have the building names as a hyperlink, and when clicking on it, it would run the “Building report” script.
... View more
Submitted on
Mar 18, 2021
08:07 AM
Submitted by
Lee_Mandell
on
Mar 18, 2021
08:07 AM

Currently you can execute a scripting app from the desktop version. Much of our data entry is done through the mobile app and many of them are complex and take many taps and entry into many fields. This can be steamlined quite a bit with scripting apps.
... View more
Submitted on
Mar 10, 2022
08:06 AM
Submitted by
dk82734
on
Mar 10, 2022
08:06 AM

Frankly, this should have been implemented by now. I shouldn’t have to manually keep track of stats run per automation. Why is this important? Well, once you hit your 50K runs/month limit, the first sane thing you’ll want to do is: Figure out which Automation was responsible for contributing THE MOST to this months quota. Does Airtable provide any built-in way to manage this? No. So you’re left spending more dev cycles implementing some hokey third-party webhook system to capture EVERY Automation Run evaluation and writing the date of each evaluation out to something like a Google Sheet (because Google Sheets don’t have a 50K record limit). Then, once your stats are in Google Sheet, you need to spend time building graphs split by Automation Name to see how many executions ran per minute/per day/per week to figure out likely culprits. Again, more time wasted. Next, once you find the culprit Automations, you might want to search the Automation Run logs to around the time WHEN THE SPIKE HAPPENED. Does Airtable allow you to do this? Sure – you can pull up the run logs… AND THEN YOU HAVE TO MASSIVELY SCROLL through historical logs – there’s no way to say “take me to the run logs back on 2022-04-15 @ 12:25 UTC” exactly – no, you’re left manually scrolling and clicking the “more” button for ever… and ever… and ever… and… well, you get the point. Oh, and while we’re on this topic, when Airtable generates an email saying that an Automation Run encountered an error – unless you click that email within about 1-2 minutes of receiving it – let’s say you open up the email like 1-2 days later, IT DOES NOT AUTO-SCROLL you to the location in the logs where the error took place … No! Instead, you’re left to have to manually scroll again through the logs to figure out where it was located. TL;DR: Automation Run logs suck; there’s no way to scroll or search them by time, keyword (sorely needed) We need Automation Run stats, in the form of graphs showing executions by day – split by Automation Name. This helps users not exceed Automation Run quotas.
... View more