Ask the Community

Airtable has this really handy trick for instantly reformatting phone numbers into (###) ###-####.I need the same treatment for email addresses that are entered throughout the Airtable base to force them into lowercase. It's getting clunky to include reformatting language in automation.I'm not great at creating scripts. Is that the solution?

Is it possible to automate the status of read-only interface collaborators? For example, when the status of a collaborator changes to 'inactive' in my base, I'd like to remove them as collaborators on all interfaces. When their status changes to 'active', I'd like to remove their access to Interface B but preserve their read-only access to Interface A. 

I need help with script (or other way?) to merge Multiple rows with same "User ID". These aren't duplicate rows. They have 2 fields in them that are different in each of the rows with the same User ID but need to be merged to one row. Essentially every 4 rows will have the same User ID that needs to be merged like this. Examples below.Example of what I have:User IDQuestionAnswerDaveDo you like CatsNoDaveDo you like DogsNoDaveDo you like Hamsters Yes

Hello,I am using airtable for a two step form process.The first table is called "Event Request". When you submit the Event Request Form it makes a record in that table and assigns it a "Request ID" number via an auto-number field. Once that form is approved, via some script and automation, the user receives a prefilled "Event Information Form" from an Event Information Table to add details.When the user submits the Event Information Form, I capture the Request ID from the initial request in the Event Information table too.What I would like to do is have a "Form Received" field in the Event Request Table that can say "yes" if there is a matching Request ID in both the Event Information and Event Requests table. Any help would be much appreciated! Thanks! 

I have a form that is letting people create Inventory Request Records, choosing Item Records they would like to check out from our inventory. We would like to have a way that will automatically prevent them from choosing an item that will be checked out during the dates they have selected.Using the filters and conditional options for these fields, I only see being able to toggle visibility for the results of the "check in date" and "return date". I would like to use the values from the questions asking for the dates to compare to the records in our "Items" grid so "Items" checked out will not be visible but I cannot find a way to do this. We are not able to use a 3rd party platform.Any guidance on maybe how to rework the fields to allow us to use the info from previous answers to help filter their selection? Is there any way to have formulas or more advanced coding in these forms?

Hi,Being somewhat new, I have a couple of questions about sharing views.I have a base for a book club.  It has a Members table and a Books Read table.  The Books Read table contains Date, Title, Author and Member who proposed the book.  This field uses a link to the Members table itself.  Works good so far.First question:I'd like to send an email to the members with a link to the grid view.  I click "Share" from that view and copy the URL link, then add it to an email.  Will that URL link change if I add records to the table, or if I add fields to the table?  If not, I can continue to use that same link, right?Second question:Assuming the link doesn't change, I created a QR code with QR Tiger for that link.  I'd like to embed the QR in the body of the email, along with the pasted link, so the recipient can either click/tap the link or use their camera to access the grid view.  Is there any way to st

I am struggling to add a holiday string in an existing worback formula that changes the date based on another field. I applied Workday successfully but cannot apply {Holiday String}&"" SWITCH({Channel Size},'Large Email', WORKDAY(DATEADD({Launch Date}, -16, 'days'), -1),'Medium Email', WORKDAY(DATEADD({Launch Date}, -12, 'days'), -1),'Small Email', WORKDAY(DATEADD({Launch Date}, -8, 'days'), -1))I found two posts about adding a holiday string from a lookup field {Holiday String}&"" and still cannot get it to work.https://community.airtable.com/t5/other-questions/referencing-holiday-string-in-a-formula/td-p/135086https://commu

Hi - I am just starting out with Airtable and I want to track my yearly memberships and send an automated email to the customers when they are nearing their 1 year renewal period. In that email I would like to include a stripe link that they can click on to pay for their renewal. Depending on their membership type, I have different stripe links. I am wondering the best way to do this? Here is what I have set up so far...1. Trigger - I have a filer view set to show records that match a certain condition. For instance - I want to send an email to everyone who purchased in March 2023. So I filtered by date - If Date is after 2/1/2023 and Date is before 335 days ago. (is there a better way to do this?) I also filtered by Membership Type*The Trigger type I used was "when record matches conditions, but should this be set for a scheduled time instead? Each month I will have different renewals that are due.2. Actions - find records from my filtered view; I have a condit

We have a form our users fill out that requires selecting a few entries from a long list of items, which we've managed to clean up by storing items by organization name--each organization has its own multi-select field, and they're conditional upon that organization being selected, so the form works nicely on the front end.On the backend, we have a bit of a mess. There are nearly 100 organizations, and every one of them has a field. In order to easily collect the items that users are selecting, we have a formula field that concatenates every organization field. It's basically:{AA} & {BB} & {CC}which returns the selected values in whichever field.The problem is that the multiselect fields don't all behave the same with the concatenation. Sometimes they produce a comma and space between them. Sometimes they don't. My goal is to clean this up for our user facing team in our automated email notification to show which items they've selected in a

Hi All, I use the API to pull our data into Excel for automated reporting, and it does the job quite nicely :slightly_smiling_face: However, I’ve added a new column to collect a bit more information, but that column doesn’t seem to be available to select when choosing columns within the query. It’s a number field (although I have tried changing it to a text field, and a formula field in case it was the field type that was the issue). Any thoughts?

Hello!I am looking for a formula that will update on a month basis to pull data for a meeting.I have a few dates I want to pull from - Target Start, Target Completion Date, and Dev start. I would like to label any records that have a date in the upcoming month (ex. March as our review is the last week in Feb) to be labeled as "Now." Then any content that has a date falling in the next 3-months to be labeled as "Near" and all remaining to be "Next". Any thoughts?? The date ranges for Now and Near could overlap, meaning it is being worked on over a longer period of time and should also reflect as Now.Thank you!!!!

I'm trying to execute a simple API call to Fireberry:   const options = { method: 'POST', headers: { accept: 'application/json', 'content-type': 'application/json', tokenid: '...' }, body: JSON.stringify({accountname: 'Test'}) }; fetch('https://api.powerlink.co.il/api/record/account', options) .then(response => response.json()) .then(response => console.log(response)) .catch(err => console.error(err));   This exact call works in Make, but in Airtable it throws a 405 - 'Method not allowed'. It seems impossible to complete thi task without another tool like Make. Is there a fix / workaround?

Hi guys, we’ve been using web builder Softr and integrated some Airtable databases which can be accessed via URL web browser. Softr offers the functionality that we can build up a pre-defined filtering with URL for our entries. (their example: https://ninfa906.softr.app/list?filter-by-Position=Engineer) We tried to set this up based on our Airtable database data but failed (already tried a lot of other structures, case sensitive etc.). They recommend this structure: ?filter-by-fieldName=fieldValue In our case this would mean (main URL is: KidsCircle-Kurse & Workshops): https://www.kidscircle.io/kurse/list?filter-by-Coach=BRUNO (fieldName is Coach,

When I embed an Airtable grid into Squarespace and peek at the mobile view, it doesn't display the card layout as it should. It displays a sliver of the standard desktop grid layout. Is this a Squarespace-only anomaly? Any workarounds>

I have 2 linked tables, Tasks and Sub Tasks. I want the Sub Tasks' status to define the status of the Task. I currently have a rollup that makes an array of all the statuses in a given Task's Sub Task. Then I have a formula that reads these arrays and creates a status. ITrying to create a formula that fulfills the following requirements:If all subtasks are "Done", the task status should be "Done".If any subtask is "In Progress", the task status should be "In Progress".If any subtask is "Done" and at least one subtask is "To Do", the task status should be "In Progress".Otherwise, if none of the above conditions are met, the task status should be "To Do".I am not much for coding so I explained this to ChatGPT and it gave me the following code. IF( BLANK({All Sub Tasks- Status}), "To Do", IF( FIND("In Progress", {All Sub Tasks- Status}), "In Progress", IF( AND( FIND("Done",

Everybody, some years back I built with "PHPRUNNER" an application with airtable+rest-api.  That worked great, but as of February 2024 airtable has changed. An API key is no longer sufficient, but a token must be used (0auth 2.0 - User ) in PHPRUNNER.I have already created a token in airtable, but unfortunately I can no longer connect to airtbale and the application. Could you tell me if the parameters in the new connection are filled in correctly? Thanks in advance. See screenshot's. What am I doing wrong ?        

I create a form (interface in Airtable) to collect information from user and store in "Table A". Output fields include "Age", "Location", "Claim", "Special", Compo". I have another "Table B" to have above 5 fields and addtional "diagnosis value" field. Table B is combination of  different conditions of "Age", "Location", "Claim", "Special", Compo" and output of "diagnosis value". My question is how to set up formula to link up Table A and Table B which can filter the result of "diagnosis value" according to User input in Table A under different combination of "Age", "Location", "Claim", "Special", Compo".If you have any idea, pls. share your thought. Thank you.

Say I have this Base A. As I have more and more Tables added to it, I want to split it to twoBases A and B to better separate my workgflow.Is there a trick to make a table in base B keep linked to a table in Base A? I understand I can use Synced Table to achieve this somehow?My plan for now is to duplicate Base A and rename/make "Base A Copy" into Base B, and then delete the unrelated tables in each base to split them. Ie, in Base A, Tables 1, 2, 3 stays and 4, 5, 6 gets deleted; in Base A Copy (ie Base B) Tables 4, 5, 6 stays and 1, 2, 3 gets deleted). But Table 4 is linked to Table 1. Is the only way manually relinking everything? Thanks so much in advance.

Suppose I have multiple products (Cola, Root Beer, and Diet Cola) that come in different sizes (6-pack and 2-liter). I currently have an interface set up where I can fill out a sales order where product and size are selected separately via single-selection. The problem is that each possible combination has an arbitrary price not based on any mathematical formula. I would like to reference the price based on these two selections, but I can't see any way to do that.I'm totally comfortable making a new table with a separate record for each possible combination (so six, in the current example). I just need a way to reference those records based on my two single-selects.

Hi everyone!I want to send email to our customers in which I want them to choose between two options (buttons). "YES" or "NO" depending if they agree with the cost of repair for their product.How can I build this buttons and email so that I can get their choice direct to the AirTable? I already have one single select field with yes/no option. But I don't know what to do next.Thank you for your help!

I am working on a formula that1. Trims2. Replaces Double Quotes (") with Apostrophes Quote (')3. Replaces Ampersands (&) with 'and'.TRIM(SUBSTITUTE(SUBSTITUTE(DESCRIPTION, '"', ''),'&','and'))The above works, except, if I change it to include the Apostrophes Quote ('), it gets an airtable error.  Any advice?Kevin

Hello:I am trying to create a RollUp for A Scoring Process we are undergoing related to our Strategic Plan. I have managed to get everything else to work; however, I am running into a challenge doing a RollUp for two questions.One is a Simple Yes/No Question. I want to get the total number of Yes/No Votes.The second is a Yes/No/Maybe question. Likewise, I would like to get the total number of Yes/No/Maybe votes.I have tried creating conditional formatting that counts IF FIELD=YES, but that is not giving me the total number of 'Yes' when I roll up. I recognize I will probably need five new columns - but I cannot figure out how to get them to populate with the required information.Thanks for any help. 

I struggling to correct a formula where I want the return value to appear based on IF AND statements.Goal I am trying to achieve:I DO NOT want the phone emoji to appear in the “follow-up” column if the “lead score” is below 5 (Eg: 0, -5, -15).Here is a short Loom where I walk through what I want to fix: https://www.loom.com/share/82b6cdb91b12403d96fdb047760e01e0?sid=bdca5f77-58d9-478e-bfbd-6395874742dcBelow is my current formula:IF(DATETIME_DIFF(NOW(), {📧 Inquiry received}, 'days')>=90, IF(NOT({🎉 Date Won}),"📞 ",""))What I want the formula to say:If the “inquiry received” date is greater than or equal to 90 days

Hey,I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!

Hiya! I'm relatively new to Airtable and need help with this formula. I need to find a formula that displays the date for the Friday of the week before the start of the next month based on a date in another field. Would also love to know what each element does so I can learn a little too rather than straight copy/paste. Thank you so much!