Showing ideas with label automations and scripting.
Show all ideas
Submitted on
Aug 30, 2020
11:33 AM
Submitted by
Alberto_Alvarez
on
Aug 30, 2020
11:33 AM

I want to send by automations email Bank card data but I don’t send this number complete. I want to mask this field to show in the automation mail with this format XXXX XXXX XXXX 1234 I don’t want to send by email the complete number of this card. I made a field Bank Card with the numbers complete I made another formula field named “Mask Card” with the formula REPLACE({Bank Card},1,15,"XXXX XXXX XXXX ") Into the view this numbers it show well XXXX XXXX XXXX 1234 but when I insert the field Mask Card into email automation only send into this email xxxx Anybody can heklp me?
... View more
Submitted on
Aug 28, 2020
09:48 AM
Submitted by
ScottWorld
on
Aug 28, 2020
09:48 AM

Two feature requests for the automated emails that get sent from the new Automations feature: We can specify our own “From Name” for the automated emails, but Airtable always appends the phrase “(via Airtable)” to the end of the From Name. Please give us a way to remove “(via Airtable)” from the emails, because it would be more professional for this to not appear. In our message body, the automated emails support Markdown for creating paragraph breaks but not line breaks. Please give us the ability to create line breaks in addition to paragraph breaks, which would enable us to have a little bit more design control over our emails. Thanks! 🙂
... View more
Submitted on
Aug 14, 2020
04:43 AM
Submitted by
Nathan_Renner-1
on
Aug 14, 2020
04:43 AM

I would suggest that form submissions that include attachments should also be able to (optionally) include those attachments in the automated emails that get sent out.
... View more
Submitted on
Aug 07, 2020
07:56 PM
Submitted by
Kamille_Parks
on
Aug 07, 2020
07:56 PM

Certain blocks require users add an editable (non-formula) field to a table to hold misc data which shouldn’t be directly edited by the user (i.e. the Map Block requires a geocache field). Many Script Block scripts semi-automate or standardize data entry processes to provide a form of data validation or workflow integrity. I think it would be nice if Airtable’s field permissions included a toggle for " Allow this field to be set in scripts/blocks/API" when the field permissions are set to: “Who can edit values in this field > Nobody”. For fields with permissions set to “Who can edit values in this field > Nobody”, there is already a toggle for “Allow this field to be set in records created through forms”, this would work similarly. This will help collaborators who should have the ability to edit data as determined by the script/block do so, but not directly to enforce some measure of data consistency in all the cases where a Formula would be insufficient.
... View more
Submitted on
Jul 26, 2020
05:38 AM
Submitted by
Caroline_Riteno
on
Jul 26, 2020
05:38 AM

I’d love for the button functionality to include “Start Time Block” (and potentially end as well) Is this possible? (A button that would start the time tracker block for the record)
... View more
Submitted on
Jul 23, 2020
12:25 PM
Submitted by
Zollie
on
Jul 23, 2020
12:25 PM

The concepts might be vastly different to Airtable staff, but to users they’re both just ways to extend Airtable functionality. It’d also be an opportunity to rethink the right side-panel design.
... View more
Submitted on
Jul 17, 2020
10:51 AM
Submitted by
Mike_Pennisi
on
Jul 17, 2020
10:51 AM

Many use cases for Airtable’s Scripting Block (and also for Custom Blocks) involve making requests to services running on another domain. Since scripts execute in the context of a web browser, such requests are restricted according to the Cross-Origin Resource Sharing (CORS) protocol. Users’ requests are frequently blocked for this reason. At the moment, the Scripting Block does not offer a solution for this problem nor does its documentation recognize the need. Some Airtable users have found a publicly-available service to meet their immediate needs, e.g. CORS policy error when trying to fetch API - No 'Access-Control-Allow-Origin' header API calls to a NodeJS/Express application with no domain name This is undesirable for a number of reasons: users must discover the service on their own (This obstacle is particularly daunting for the entry-level programmers for whom the Scripting Block is designed. Even experienced developers can struggle with the complexity of CORS.) the reliability of the service is not guaranteed the trustworthiness of the service is unknown (The proxy has access to all the information intended for the destination service which frequently includes sensitive data like API keys and database contents.) If Airtable provided a CORS proxy, it would fill what some might argue is a hole in the capabilities of the Scripting Block. It could confidently educate users on how/why to use the service, guiding them away from unsafe practices and toward more resilient solutions.
... View more
Submitted on
Jul 13, 2020
01:25 PM
Submitted by
Mike_Pennisi
on
Jul 13, 2020
01:25 PM

The Scripting Block offers a number of asynchronous functions for collecting input from the user. To date, all the example scripts I’ve seen use these APIs one at a time in a sequential fashion, e.g. const name = await input.textAsync('What is your name?');
const birthplace = await input.textAsync('Where were you born?'); This pattern is serviceable, but it produces an unideal user experience: users are led on a forced march through one question at a time. That can be disorienting when folks run a script for the first time, and that’s particularly apparent when more input is required. Given that the APIs all return Promises, I expected to be able to compose them in parallel and prompt the user for all input simultaneously, e.g. const [name, birthplace] = await Promise.all([
input.textAsync('What is your name?'),
input.textAsync('Where were you born?')
]); That would show users the full extent of the required input “up-front” and offer them the freedom to provide it in a sequence of their choosing. In the Scripting Block today, the second code example does not function as intended. the UI is initially rendered according to the use case (both input fields are present) entering data into either field causes a “spinner” animation to be appended to the document (somewhat confusing, but not entirely disruptive) entering data into the second field causes an error to be displayed, e.g. ERROR
R: userInputStartTime
at main on line 30
... View more
Submitted on
Jul 12, 2020
12:00 PM
Submitted by
Bharat_Batra
on
Jul 12, 2020
12:00 PM

I just wanted to say awesome work to the AirTable team on the development environment inside scripting blocks. I like coding in it even more than using WebStorm/intelliJ, which I’ve always considered state of the art! The one feature I think that would make it even more helpful would be to have a shortcut to copy and paste the previous line or highlighted section (cmd + d in WebStorm). This is super useful for speeding up the basic structural stuff… Eg. const fromQuery = await base.getTable(fromTableName).selectRecordsAsync(query); //would be nice to copy this down below and speed up typing const toQuery = await base.getTable(toTableName).selectRecordsAsync(query);
... View more
Submitted on
Jul 09, 2020
11:17 PM
Submitted by
Michael_Harris
on
Jul 09, 2020
11:17 PM

Though there is already a button feature that I like. But what if…IF you want to use a button to ‘change the field value’. For instance, when I press a button, it puts a checkbox in the checkbox field. Unfortunately, there is no way to do that, except by using just the script block. As blocks are only on the paid plan, I’m only on a free plan and with no access to blocks, I wish there is a way to actually change the value of the field by pushing a button without the use the of the script block. I hope that feature will be implemented in the near future.
... View more