Showing ideas with label automations and scripting.
Show all ideas
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 21, 2018
11:48 AM
Submitted by
typo
on
Nov 21, 2018
11:48 AM

When I use a lookup table to reference an e-mail address, url, or phone number in another table, I would like those fields to act as active e-mail addresses, urls & phone numbers when they are displayed in the lookup table. Currently the lookup table formats them as text, so if I want to e-mail a group of people from a particular set of lookup fields, I have to hand copy all of the e-mail addresses. Or, if I want to text someone from a particular lookup field, I have to hand copy the phone number.
... View more
Submitted on
Nov 14, 2018
03:24 AM
Submitted by
Goce_Ristov
on
Nov 14, 2018
03:24 AM

What I find lacking over and over again is time when a field(not record) was last updated. Example: I have a field status. I need to know when the status was changed from In Progress to Completed. That way I can group all Completed tasks by month and calculate pay for this month. I think it is not too much to ask and it is a very basic and must-have feature for a project manager softwaer.
... View more
Submitted on
Oct 31, 2018
04:33 PM
Submitted by
Sandra_Shields
on
Oct 31, 2018
04:33 PM

I’m using SendGrid, but it only allows for text messages. How about the HTML option please?
... View more
Submitted on
Oct 31, 2018
12:25 PM
Submitted by
Josie_Duffy
on
Oct 31, 2018
12:25 PM

Hi - I am wondering if it’s possible to automatically get Airtable to pull documents into a database from a certain folder on my desktop. I have a Mac. Is Automator a possible way to do this? Any guidelines would be great. Thanks!
... View more
Submitted on
Oct 16, 2018
02:07 AM
Submitted by
Andrew_MacNeill
on
Oct 16, 2018
02:07 AM

I was replying to a question in the Community forum and used the Zapier integration as a way to do this but I think this could be something built into Airtable as it’s effectively an AirTable to Airtable integration. So by having a new record added to one (or more bases) would automatically create a new entry into another table (perhaps in another base) with some prep-populated fields.
... View more
Submitted on
Oct 11, 2018
05:07 PM
Submitted by
kc01
on
Oct 11, 2018
05:07 PM

It’d be good to have a formula that accepts a cell ID as it’s only argument and returns a date-time record showing the last time that field was edited. For example, you could have a to-do list with Doing, To-do, and Done as the options for a single choice field and then a column next to it showing when that field was last updated. How things are currently, if we want to know how active some team members are on their progress, we have to open every field one by one and check the change logs individually. Cheers
... View more
Submitted on
Oct 01, 2018
03:02 AM
Submitted by
Mathias_Elmose
on
Oct 01, 2018
03:02 AM

I would find it very useful if there was an embed block that would be kind of similar to the page designer except that instead of printing it would be for embedding it into a website. The use case would be showing records from Airtable in a more customized way that would feel and look more just like a part of the webpage. Say I wanted to show a table with all our employees. Right now it would be via an embed view (which is great) but if I could design it to look and feel just like our website it would be very useful
... View more