Solved

Hi, So I have a field called {First Name} and {Last Name}. I have a formula field called {Full Name}, which is simply the result of {First Name}&" "&{Last Name}. Pretty simple. However, there may be cases when the {Full Name} results in blank. For e.g. when I create a new row in the grid, but no First and Last Name have been entered yet. I assumed that the {Full Name} is equal to BLANK() in this case. I have a primary field {ID}, which I’m using as an ID with the intent that if the {Full Name} is not blank, then evaluate to Autonumber&" "&{Full Name}, so something like “101 John Smith”, “102 Rebecca Jones”, etc. However, I want ID to be a formula such that if the {Full Name} is blank, it evaluates to something like “103 No Name”, instead of just “103”, i.e. I want to see the ID that has no full name explicitly, so I thought a simple IF() formula for the ID field would work. I tried to write an IF() formula such that if {Full Name} is BLANK(), then formula result should

Hello all, I have an automation that is looking for a record with specific values. Sometimes it does not find the matching and it is normal (it is a use case.) I would like to know if there is a way to catch the error of the find function ? If not I was thinking of doing it with a script but I found it strange that in automatisation it is not possible to catch error or even do conditional branch. thanks for your help Alex

Hi All! First time in the community. I’ll have a bunch of questions but wanted to know if there’s an easy way to do a formula to convert a duration field from hh:mm (hours and minutes) to hh.hh (hours with a decimal)

Hello! I have two linked tables, let’s say Users and Events, and the Events table contains an Attendees column that links to Users. I want to add a new value to this column using the API. The code is quite simple: await eventTable.update(eventId, { Attendees: [userId] }); But this overwrites the previous attendees. Can I just add one new value to the cell without overwriting the previous ones? I know I can read the previous values manually, add the new one and write the whole array back – but that’s a race condition waiting to happen, isn’t it? Is it possible that someone changes the value after I read the previous contents and before I write the new, augmented value?

Hi. I’m trying to figure out how to use your API. What I need to do using the API endpoints is the following: Send a request to create a user (record/row) in a table Then create a Gallery view named as the user’s name Generate a “share view” link/embed code with an active filter. Is this something that is possible to do via the API? Thanks, Andriy

Just started with Airtable, using the free version at the moment on Firefox / Ubuntu. When I log on, Airtable seems to open to a random base in my workspace. Is it possible to set it to open to the workspace screen so I can choose the base I want to use? Thanks! Dianne R

I have an automated email set up, using Gmail, for informing someone when their video is scheduled to be published. This is trigged once the publish date date field is set. I have changed the publish date date format from ISO to friendly format, but it still publishes the scheduled date as ISO format in the automated email. Does anyone know how I generate an automatic email with the friendly date format? Thank you!

How would you go about configuring a field so that you can create a dropdown list of years inside of a form? Is it possible for it to dynamically update with the {current year} + {10 subsequent years}? For example, the form field might read something like: 2021 2022 2023 2024 2025 etc…

I have a table with a multiselect field for stages: Submitted, Reviewed, Approved, Completed. I would like to track the date of each stage change in separate fields. So Date Submitted, Date Reviewed, Date Approved, Date Completed. I am using this formula to populate those fields… IF({Stage}=“Reviewed”, LAST_MODIFIED_TIME({Stage})) The problem I am now running into is keeping those date entries even as the stages changes. So when the multiselect is changed from Reviewed to Approved, I would like both the Reviewed Dates and Approved Dates to remain. With the above formula, only the date of the current stage remains. Please help! Thank you!\ -Vicki

Hello, I am trying to substitute all the occurrences of ", " (comma, space) in a Lookup field with “%20” and place that into the formula field.

Hey! I know you can rearrange the options in the multiple select FIELD. But I need to somehow organize the actual records with selected options. Take a look at the example: You see, it’s a mess! And my actual table has even more different options - it’s not feasible to do this by hand. I would love to find a way to have them all in order. Thanks!

This is so dumb but driving me crazy-- how do I just grab and drop a section to move it??? It doesn’t seem to work like in excel. Thank you!

Hi all I’m trying to update records in a table using vanilla javascript (because I’m building a Bookmarklet, so curl or node won’t work). I’m stuck on a user error “Unprocessable Entity” and the response is of type “cors”, so perhaps there is something wrong with my request headers? fetch("https://api.airtable.com/v0/appfiPFiZHqEAsjAJ/Table%201", { method: "patch", headers: { "Authorization": "Bearer MY_KEY", "Content-type": "application/json", "accept": "application/json" }, body: { "records": [ { "id": "recSKCdIGgAGRUc5c", "fields": { "Field One": "Bla", "Field Two": "BlaBla", "Field Three": "Blubb", } } ] } }) This returns: Any pointers would be much appreciated.

Hi community, I noticed toward the end of last week that some of my go-to apps aren’t working within my Airtable bases. I recognize today that the issue is related to using the Firefox browser, which has never been a problem before. (Using Chrome, all is well.) Anyone else experiencing this? My browser is updated and I hope this is a temporary bug. Ex1) I can submit text in the search app, but no results are generated. I have the ability to change the view being searched, but it makes no difference. Ex2) The map app is nearly unresponsive. When I expand to full screen I can see the settings, but it doesn’t make any difference if I modify the fields. In each case, the formatting within the app is wonky, too. I’ve included two screenshots to demonstrate. Anyone have any thoughts?? Leads? --Thanks for any insights!

Hello, Not sure how to phrase this-How do I lock across several fields then sort alphabetically by the first field? I want all the information organized by name in the first column but don’t want to lose all the websites in other columns. Thank you!

Hi there, I am looking to use the Button run script field in Airtable to send specific data from my table into Zapier. Does anyone have a template script they can share? This is what I have so far. let url = "https://hooks.zapier.com/hooks/catch/TKID?recordID=?name=?"; let table = base.getTable("Table 1"); let view = table.getView("Grid view"); let record = await input.recordAsync("Pick a record", view); let name = record.getCellValueAsString("Name") let email = record.getCellValueAsString ("Email") await fetch(url + record.id + "%name=" + name + "%email=" + email); My understanding is the steps are: Create Button field Add in script that posts to Zapier webhook Catch data from Airtable Run rest of the Zap Just looking for help on the Airtable script side. Thank you.

Hello all! I’m new to Airtable and need your help. I’m using two tables with responses from Typeform. Both tables have similar fields, the difference being only the language. So I have Table 1 [english] and Table 2 [Portuguese] populate with similar information. My problem is: I need to populate a third table with both Table 1 and Table 2 data combined. I’m using Zapier to combine the responses for Typefome and send it to Airtable, but Zapier seems pretty unstable, so I’m looking for a way to populate directly from Typerform. Someone know if it’s possible?

Hi, I’m trying to get familiar with the SWITCH formula by taking a shot at using it instead of a nested IF but can’t seem to figure out the following. I have a field called “Expiry Date” (type Date) and another field called “Expired?”, which is a formula field where I’m trying to use the SWITCH formula. My goal is that the “Expired?” field formula should output “Expired” if the “Expiry Date” is lesser than TODAY(); it should output “Expires today” if the “Expiry Date” equal to TODAY(); and should output “Still Active” if the "Expiry Date is greater than TODAY(). The formula I’m using is SWITCH({Expiry Date},<TODAY(),"Expired",=TODAY(),"Expires Today", >TODAY()"Still Active","N/A") I’m definitely doing something wrong because I’m getting a formula error. Can somebody please help me with this. Thanks, Sean

Hi all, maybe a stupid question but I’m confused about how to format my automated mail. What my Airtable looks like: What my Mail looks like: What should i do that both look the same way?

Hi all, I’m looking to display the result of a formula as a read-only check box. The result of the formula is always a 0 or 1. Here is the formula: IF(AND(OR({Meal Plan Shopping List Recipe}, {Non Meal Plan Shopping List}), NOT({In Pantry})), 1, 0) Adding a screenshot for reference. I’d love it if the 1/0 column could show a checkbox if 1 and nothing if 0, like the other columns. Thanks in advance!

Hi community, I see that the API has a limitation (5 requests per second). We are facing some issues with our API calls and suspect that the limitation of the API is causing the issues. We are using Zapier, AirTable automations and some other API calls via our own platform. Is there an overview where we can see if we (often) reach the API limits and which call is responsible for that? Such an overview would be very helpful in understanding how we burden the system. Thanks in advance for your help

Hello Community, I am having an issue with an automation and would love some guidance. The automation is intended as follows (w/ pics below). Trigger: When Production Status field IS “Scheduled” AND Review Status field IS “Approved” AND Publish Date field (actually called Archived Publish Date in my table) IS “before today” Action: Update records’ Production Status to “Live” I can see that the tests are working, and the automation triggers when I add a new record meeting the above conditions, but when I run the automation, nothing changes to my existing records meeting those conditions. I was really hoping that it would update all pre-existing “Scheduled” records to “Live” to save time on data entry.

I have a table with a multiselect field for stages: Submitted, Reviewed, Approved, Completed. I would like to track the date of each stage change in separate fields. So Date Submitted, Date Reviewed, Date Approved, Date Completed. I used the Last Modified Date field type, but it overwrites each time the stage is changed and that does not work for our needs. Any suggestions? Thank you!

I’ve scoured the message boards and cannot find a workaround for this. I have a formula to calculate a Due Date in a formula field; however, the filtering options for the formula field is quite unhelpful. I would love the option to filter for due dates within a week from now (etc) but the only options I have are “contains” and “empty” - which prevents me from creating filtered lists of Tasks that need to be done soon. The best I can do is sort the entire list - which isn’t nearly as helpful. Anyone have a workaround or idea here (I would like to keep the formula as is - it tracks when items need to be done based on a final date)? I could copy and paste all the values into a date field, but that extra step might be unnecessary (hopefully)? Here’s the formula I’m using if helpful: DATETIME_FORMAT(DATEADD({Event Date},({Days Before Event}*-1), ‘days’),“M/D/YYYY”)

Hello, I’m pulling my hair out… I have the following formula: REGEX_MATCH({Products},"Personal") {Products} is a ‘A Name’ column and the above formula produces a 0 if “Personal” is not present in the column’s field and a 1 if “Personal” is present in the column’s field. Using the same formula on a different table: REGEX_MATCH({Products},"Personal") {Products} is a ‘Lookup’ column and the above formula produces a 0 if field is blank and a #ERROR! if not blank. The only difference between the two scenarios is the top formula is checking a ‘A Name’ column and the bottom formula is checking a ‘Lookup’ column. What am I missing? Why am I getting an #ERROR!?