Ask the Community

Greetings, I have a zip code field that's either 5 digits or 9 digits. I need a formula to display the zip code as either 12345 or 12345-6789 depending on the content of the field. I know How to write the beginning of the formula, I do not know how to write the if 9 part.  I have IF({Zip Code} <6,{Zip Code}, Need to describe the 9 digit code with a dash.)Anyone have a thought on this? I am using a number field for the zip code. Is this the correct field to use?Thanks, Scott

I’m trying to figure out the best way to send single send sorts of emails to people in my database.I’ve tried using the built in segmentation tools of typical mailing list software, but my needs are much more variable and ultimately at the end of the day it’s soooo much easier to just put together my list in Airtable via filters.  And then I could fill in the little extra info I need from there into a templated email of some sort.  I really only need to send a few sentences of info. Is this something I could feasibly do? I assume using sendgrid or similar?

I created a staff scheduler with a series of automations that copies a shift (Workday Date and Start/End Times, Location linked field, employee linked field, notes) to a future date based on 4 checkbox fields (creating a shift 1, 2, 3 and 4 days in the future).While the tool works great, I started receiving an error with only ONE location linked field every time I try to copy a shift. The error reads as follows: 'Creating the record failed due to insufficient permissions.' I have tried several fixes, including creating a duplicate of the location in question in the parent table and cutting and pasting pertinent information and linking fields about that location into the new record. I am completely stumped and as it is impossible to reach Airtable directly anymore, I figured I'd turn to the forums.Thanks in Advance!

It would be awesome if Airtable added 'This Year' and 'This Month' to the filters. This way, I could create a view of records, like expenses or invoices, that apply to this month or year. I'm actually surprised this is not already a feature. It seems like it would be a simple addition. 

I am unable to view Getting Started webinar. Each time I click on it, it takes me to registration page. I can't even find an email address to contact AirTable. The bot is worthless. Please help, thank you. https://www.airtable.com/lp/resources/webinars/get-started-airtable-od

As per the attachment, I have created an automation with multiple steps starting with a form being submitted and ending with an email being sent to the customer who submitted the form.The email body requires data from the previous steps of the automation to be updated.The problem is that it seems the automation doesn't run in sequence (each step following once the previous one has been complete), rather all steps run simultaneously. This causes the email body to be missing data, because the final email is being sent before the records have been updated according to the previous steps.Am I doing something wrong?

Hello!I have the following bases tables:- Team- Emails Teams has records of people grouped by single select types of teams (Management, Development, Operations).Emails has email records that is populated by a form. The form asks for, among other things, the group it is to be sent to. This is a separate field not linked to the team field in Teams. Once the email has been approved, i have a trigger when the status of the email submitted is "good to go".I would like to know how to go about automating sending an email when that is done, to the defined group of people. e.g. Team "Management" is selected on the email submission form, once approved the an email sends to that group.Appreciate any help 🙂 PS: Is there a way to manually send an email from airtable? Perhaps it can be modified to send when a different form is filled out, with say su

Is there a way to put parts of a formula (while writing or editing it) on separate lines, like in a visual editor, to better organize? It works when I cut and paste, but I can’t figure out how to do it in the box. Any suggestions?

Hi All, I'm trying to use a linked record to pull up the TRT of an asset that's listed out as a full timecode, extract just the hours and minutes and put that into a duration field. I've gotten so far as to pull the hours and minutes but when I set the automation to fill the duration, because it's not reading the text as seconds, it's coming in with the wrong duration. I haven't been able to get datetime_parse to convert the text to time. I can sense there's an easier way to do this that I'm just not landing on but nothing I've tried has worked. 

Hi all! Here's what we're trying to do, and what we tried that isn't working:What we're trying to do: (example table: https://airtable.com/appKiBFGhHOgFeXf2/shrrTAISY39Rx8mL5)We run an exam, and have two tables:test_takers - each person who is taking an examexam_instances - each instance of an exam, 1:1 linked to test_takers.In other words, a single test taker could take an exam multiple times, generating multiple exam_instancesWe would like to store the status of the exam (e.g., not started, started, passed, failed) in two places:In exam_instances - each instance will have a single exam_statusIn test_takers - each test taker will roll up the "maximum" of those statuses. For example: if someone starts the exam twice and passes the second time, so one entry in

Hello everyone,I have used scripts a lot in the Automations pannel. However, I'd like to create more user friendly experiences using the Script Extension.Upon creating my system, it appears that buttons that trigger script extensions can not be run from an Airtable interface. Can anyone confirm that? Is there a way to create better experiences directly in the interface pannel by allowing users to follow a set of actions as defined in those scripts? Can it only be run from the data pannel?Thank you very much,Simon

Hello all,I am new to Airtable. I am building automations but have no idea of scripting.Maybe someone can help me with my issue.I have 3 tables:1. Projects (here I group linked operations)2. Operations (these are all operations)3. Products (these are products which are included in operations.4. BOM (bill of material for invoices)Project is linked to operations via PROJECT_ID.Operations is linked to Products via PRODUCT_ID and projects via PROJECT_ID.Products is linked to BOM via PRODUCT_ID.I want to have this kind of logic:When record is created in operations, with operation type "Sales", where product is not empty,I want to search all entries for this product in BOM table, and copy all entries to Operations table, with link to the same project.Is it even possible? Any help on how to do this kind of stuff? 

Hello, I am having issues with adding additional advertising week options to the formula below. This formula works well:IF(AND({Advertising Plan}, {Live Date}),SWITCH( {Advertising Plan},"4 weeks", DATEADD({Live Date}, 27, 'days'),"52 weeks", DATEADD({Live Date}, 364, 'days'))) But as soon as I try to add additional week options (I have already added them to the Advertising Plan single select field), I get the 'formula not valid warning'. This is what I am putting in:IF(AND({Advertising Plan}, {Live Date}),SWITCH({Advertising Plan},"2 weeks", DATEADD({Live Date}, 13, 'days'){Advertising Plan},"4 weeks", DATEADD({Live Date}, 27, 'days'),"8 weeks"({Live Date}, 27, 'days',"52 weeks", DATEADD({Live Date}, 364, 'days' ))) Please let me know where my formula is mucking me up, I feel I am going cr

Hey there!I am an Airtable novice looking for formula help. 🙃I have a table with columns: Year, Candidate, Entity/Org, Side, Race Level, State, DistrictRight now, my formula is:IF(Candidate !="", CONCATENATE({Candidate},", ",State," ",District),CONCATENATE({Entity/Org}," - ", Side))which will pull the Entity/Org & Side when the candidate field is empty. However, there are instances wherethe District field is empty (in which case I want to pull in the {Candidate},", ",State," ",{Race Level})& instances where the District field AND the Candidate field are empty (where I want to pull in the {Entity/Org}," - ", Side))Any help is greatly appreciated!Thanks!

I know how to make my date show correctly using DATETIME_PARSE(DATETIME_FORMAT({EDate}, 'MM/DD/YY'))And I know how to create a new string by using this formula{EDate (from Events For Sync)}& "- "&{EID#}But what I can't figure out is how to make the first formula work with the second formula into one formula that works.I've tried different ways but nothing seems to work and I am stumpedThis may seem easy for some - but I am frustrated that the date field when you have it set for one way doesn't carry the content over when used in a formula.  But whatever.

We would benefit greatly if a timeline view could be set to week (or preferably a user-selectable qty of days) but still show the records by hour. Today it seems to be only possible to show records by hour when in the single day view. When using any date setting other than Day, even if something is only 9-11am on a given day, it will simply show as an all-day event. This is not effective for scheduling events that are not all day, or, in our case, events that occur through the night.The calendar view does have a 3-day option that can be shown by hour, but it does not allow for grouping so the calendar view is not an appropriate solution for resource planning.

Hey all!I run the backend of a small newspaper, and one thing we do is make a list of "happenings" that we publish each month. I had set up a back-end system via Airtable collection form, and the listings were then compiled into a Google doc via automations, and it was working great until this month when suddenly basically all my automations were failing - suspiciously only ones that involve dates like one-day and multi-day events. Did something change with Airtable automations in the past few weeks or what is going on! I had to manually add all the listings this month and it was a pain. Desperately hoping someone can advise, happy to share more info -- could not for the life of me figure it out,Thank you!!

Hi,I would like to share a record from my base via email.I opened the base, selected the record I wanted to share and chosen "send record."Then I got an error message "this row could not be sent because recipients must be collaborators on the base or workspace." So I invited the recipient to become a collaborator. The recipient received and accepted the invitation but even so they are not showing as a collaborator in the base and I am getting the same error message when I try to "send record."I am on the free plan and I have not allocated all the editor roles availableDoes anyone have any ideas/suggestions what I can do?Thanks 

Is it possible to create a new record from within an interface's form lookup field?I'm running into an issue where I need to be able to use a lookup field in my form, but often need to create a new lookup field record on the spot.  See below image with what I need, but must not be an option.  

Is this simply being overlooked right now by Airtable? Currently we "add new records through a form".  However, the form lacks the capability to "create a new record" for a lookup field.  However, I noticed, that in an interface, if you turn on the ability to edit/delete records in-line, then you get the ability to create a new record directly from the lookup field.  Seems like this is something that just hasn't been rolled out yet?  Editing/adding records inline, isn't a great solution for our workflow, so really trying to figure this out! Thanks in advance!1st Image - Showing in-line lookup fields ability to create a new record if one doesn't exist2nd Image - Showing forms lack of ability create a new record.  

I synced Wordpress to Airtable using Zapier. Whenever I submit a form on Wordpress, the information is shown automatically in Airtable. However, the only issue I am facing is that attachments are not showing at all. I have a form field where users can upload their profile pictures. The attachment in Airtable shows empty. Only if I upload directly an image from Airtable the image is shown (Row 2). However, that is not what I want. I want the image submitted in the wordpress form to show in Airtable. Any idea where the issue might come from? Thank you for taking the time and helping! Jad 

Hi dear airtable community, I’m using airtable curl API and I want to get the data from the oldest. I believe the go here is the sort parameter passed on as a query, but the createdTime is outside of fields, how can I access that? createdTime has to stay and must stay out of fields for my use case. Current endpoint I’m using, just need to read the createdTime that is outside out fields https://api.airtable.com/v0/{base}/{tableName}?sort%5B0%5D%5Bfield%5D=createdTime

  We are a small design build construction company. We have started using airtable to organize the design details of our projects. These include things like paint colors, cabinets, flooring, etcOur ideal workflow would be: Click a button to create a new project and then be able to import templates based on what is in that project scope (tile work, bathroom, kitchen etc).Pull items from our catalog and other sources to create the selections.Generate a PDF report that we could send to the client to get a signature.Track changes made to the selections.Once the selections are signed, we would move to procurement and use airtable to track purchased items ( when to order, and when they arrive on site).When the project is complete we would present the customer with a printed copy of all

Just need help determining the correct selector and attribute on the Linkedin applicant html page.I first tried Text Content by CSS Selector using the id which worked flawlessly until I realized that the id isn't static. It changes every time I open a different candidate. Now I want to try using the HTML Attribute by CSS Selector but I need help determining which HTML to use. The code is attached.Thank you so much in advance for any help you can provide.

Hi everyone,I have an Airtable view containing filtered records that may change daily.I want to set up an automation to send an email with all the view records as an attachment (CSV/PDF/Excel) or in the email body, every day if the view contains any records. Is it possible with the SendGrid App?What is the best way to achieve this?Thanks in advance for your help!Best regardsRashid