Ask the Community

Hi,I'm new to AirTable and trying to work out if this is possible. I'm creating a form to collect data on various buildings and the facilities they have within them. I've got a starting list of facilities that I'm going to use a multi-select list for, with a checkbox option for other. If "Other" is checked I'll then show a single line text field for the data collector to add another item. However, there could be many items to add. Is it possible to keep adding single line fields on an ad-hoc basis.For example in my basic list I have:PrintersWifiWater fountainThe data collector finds that building A also has:Disabled accessScannersComputer labCaféThese 4 extra items also need to be added during the data collection and so would need 4 new text inputs to be added. Is it possible for the user to dynamically add text inputs to a form?

Hello, I want to send a form to users to sign up to an activity so the user can provide their contact information and their acknowledgement to have read certain conditions. I know how to configure the basic personal information, but what’s the best way to do the section for reading and acknowledging the conditions? I don’t have a place on the web to put the text to read so I can’t send the reader to an external link. Is there a way to link to a separate field in a base, with very long text ? I would have to do this for three conditions. I was thinking: One of the field has to be a long text “X” to read. The next field would be a single check box “I have read X” Any suggestions? Thank you

Hello all I’m a reporter who uses Airtable to keep track of big developments on the subjects I cover. When I find a relevant article, I use the clipper to pull the page title, URL and whatever text I’ve highlighted in the story into a table. It’s a nice system. But what I can’t work out is a way to easily log the date of an article’s publication. It doesn’t seem possible to add a date field into the clipper, so at the moment, I’m writing the date manually into a short text field. That’s fine - though if I want to arrange the articles by date, or generate a timeline infographic, I’ll run into problems. How might I work around this? Dave

Hey guys!I’m looking for a Shopify+Make+Airtable expert for a little quick project I have…?

Hi there,I'm trying to utilize Airtable to manage Shopify Metafields (among other things), but am striking out with doing this in what I believe to be the most logical way.I've configured a field (column) as "multiple select" with preconfigured options (the array). This ensures we're dealing with legitimate values.Syncing to Shopify, through the use of AirPower, requires the metafields to be in the format:["MF1","MF2","MF3"] I've used ARRAYJOIN to convert the array to a string in a separate field, but am stumped at actually formatting the square brackets and quotes.Suggestions?TIA,Jeff

If anyone is interested, I wrote some code to sync over new Shopify orders to Airtable using the Shopify Order Created webhook and the APIs of both platforms. The code can be found in this Github repo:https://github.com/codeupify/functions/blob/main/shopify/airtable-order-integration/README.mdThe code is in Python and using Flask as a webserver that you can host somewhere. There is also a serverless solution available here if you don’t want to spin up your own server:https://codeupify.com/f/yMYerkEaOB

I have a contest that has 3 rounds that are dependent on each other to start and stop. Each Customer's contest could have different durations for each of the round. They usually define a start date and a duration.For each contest record I define: Name of contestNominationsStartDuration EndRound 1StartDurationEndRound 2StartDurationEndI would like to use date dependencies to link the three rounds, so if I change the start date or duration of any round, the next rounds dates will shift. I have tried to configure the date dependencies but it looks like I can only set one configuration per record.  Is there any way around this that I am missing? Thanks in advance

I have a script running that has been working well, but 2 days ago it stopped working.Where it used to take a file from 1 column, rename it, and reupload it to a next column, it now:1) Takes the file2) Renames it3) But when it uploads on airtable, the filename becomes a string of gibberish like "70d5b867" and doesn't use the filename I had specificed. The puzzling thing is, in the record edit history I see that the file with the right filename has been uploaded. But when I actually find the file, it's not named right.Here's the script:  // Dynamically retrieve the record ID from input let recordId = input.config().recordId; let table = base.getTable("Agenda"); let record = await table.selectRecordAsync(recordId); // Define an array of sets with their respective WIP tray field, output tray field, and naming format let sets = [ { wipField: 'WIP IF Session Banner (Automated)', outputField: 'IF Sessi

Looking to create one or more sales email campaigns leveraging email templates. Campaign could be triggered against criteria in a project table.I was thinking the email templates might reside in their own table, potentially with the identified campaign name, subject, body, sequence number, cadence etc.Assume 3 emails in campaign with the cadence as follows: Email 1 sends on startdate, Email 2 startdate+2, Email 3 startdate+5For example, "Campaign Name" = "Lost Deal", "Email Campaign Status" = "Active", "Email Campaign Startdate" = 2024-10-24Project table contains the primary contact name, but no email info. Primary Contact Email address is contained in the contacts table associated with the project. Subject field and Body field along with Campaign Name in "Email Templates" table. Is it possible to reference these fields  and automate sending the 3 emails using the referenced fields on scheduled dates based on their cadence?&

I find that when using the Sidesheet option, it's really easy to miss when a colleague has made a comment on a record. The design is only very subtly different when there is a comment vs. when there are none, and by default the comments are collapsed. One simple solution would be to make the comments section non-collapsible, or at least default it to being open. Is there a setting for this that I've missed?

Hi. I'm just getting started on airtable and I want information on my form builder in my dropdown menu to show on the actual form. When in the form builder it shows the first and last name plus other info such as status and email addresses but on the actual form when I click on the same field it only shows me the first name. Is there a way to change this? I'm trying to change it from the second photo to the first photo on the actual form. 

Hi, I have a very quick question. When filling out a form, when selecting a record in a linked field, you see [pic1.jpg].Is it possible to change it so that it looks like [pic2.jpg], in the form view itself.This way you are able to see more information about the record you are selecting. Thanks,Nareg

I have a form to create tasks, and it asks the user to select a 'project' to link the task to via a record picker.There are a lot of projects, and they are duplicated for different clients, meaning when they use the form, and search for the name of the project we get duplicate results with no way of knowing which record is the correct one.Is there a way to pull in more information into the 'record picker' view, eg) name of client, etc? 

Hi AllI created a form for my drive team.  The form information has start time, end time, etc.  The form information goes into my master spreadsheet.  The team members do not have a paid AT account - Only I do.Is there a way that the information on the form that goes into my spreadsheet could be automatically emailed to the user that submitted the form to me?

Wondering if anybody has the same challenge, or has thought of a solution/workaround to help monitor Interfaces across multiple Bases?My team manages many similar projects that we run for multiple clients, and for confidentiality reasons the data for each project should be stored in its own individual Base. In each Base, we have data to report on overall project status which we currently present in an Interface.Now, our project managers find themselves needing to understand holistically the status of 20+ projects, but now must manually locate and open 20+ Interfaces to view each one. This is something they must do on a daily basis.Does anybody have a solution to bring all the Interfaces one would like to continuously monitor into one singular location? 

Hey there. I’m using this formula for a column: DATETIME_FORMAT({Date of Donation}, ‘M/D/YYYY’) & " — " & IF({Donor Account}, {Donor Account},{Company account}) It’s pulling some company account names that have commas in the title, generating unwanted quotation marks around the field name.: 10/24/2019 — “Farrar, Straus & Giroux” Can I drop something into the formula that will eliminate the quotes?

I am creating an automation to bring into AirTable records from a Google sheet that is being populated by Google forms. One of the fields is a Date-Timestamp field. However, even though the formatting is the same in both the spreadsheet and AirTable (namely, Date-Timestamp with the same formatting parameters), the Test Run yields an error that says, “Field ‘Date-Time’ cannot accept the provided value: Could not convert string to date.” Shouldn’t an AirTable automation designed to bring in a variety of fields from Google Sheets be able to bring in Date-Timestamp data without converting strings to dates? Is this a bug? Or am I doing something wrong? Thanks. Mike

Hi there, I have the automation example in Airtable that sends a digest email of certain records for yesterday (in our case, overrun on tasks). On days when there was no overrun, the email would still send but would be blank, which is not appreciated by management. I found this script in the forums here that helps prevent the email going out BUT it means I get an error alert & email instead, and it makes me go and check the automation is still working: // A script to stop the automation running when no records are found. // This prevents blank emails being sent. // See: https://share.support.airtable.com/2NuwnyDD?method=GET let numRecordsFound = input.config().numRecordsFound; if (numRecordsFound < 1) { throw Error("No records were found. Aborting so no blank emails are sent.") } Is it possible to stop or exit the automation silently, without throwing an error? Many thanks in advance, Chris

Hi all together!I work with an organization with an airtable enterprise account and we are currently having the problem, that a table is limited to 10.000 rows (can this be?).My question is, if there is any limit for rows in a table for airtable enterprise accounts?Online I read about 100.000, but it seems ours is different.

I am trying to use the API request to retrieve comments from a record using the following URL: v0/{baseId}/{tableIdOrName}/{recordId}/comments. However, I encounter a '[404] NOT_FOUND' error. I am using an OAuth connection in Make, which works when I use any other request, such as a simple 'Get a record': v0/{baseId}/{tableIdOrName}/{recordId}.

Looking for an API that can be. used for integration purpose to fetch all the data related t the subscripted plans 

I cannot get DATETIME_FORMAT to work in a Rollup Field. There are multiple dates present in the Rollup Field, and each displays correctly when NOT using the DATETIME_FORMAT I am attempting: DATETIME_FORMAT(ARRAYJOIN(values, “\n”), “M/DD/YYYY”) But that results in an #ERROR! when there are multiple dates present in the Rollup. It works correctly when there is only one date present in the Rollup Field. I’ve found a couple topics on this same issue, but no resolutions. Thank you!

The little grammarly bubble keeps showing on top of what I'm typing. It's specially bad and annoying when I'm working on formula fields and I can't see my formula. How do I turn it off? Toggling the extension off on chrome didn't seem to work. Cheers,

Would be great to have a better to navigate across tables - i have a base with more than 50 tables that is difficult to manage

Hello,I am pulling out the few hairs I have left over a problem that I am about to solve, but I can’t find the sticking point. To summarize:I have a record in a COMMANDE table, linked to multiple records in a LIGNE_COMMANDE table. (The classic case of an order header with its order lines).I want to be able to “Clone” via automation (when a record enters a specific view, for example) both the information contained in the COMMANDE table and the content of the linked records in the LIGNE_COMMANDE table.When I say clone, I mean creating a new COMMANDE record (almost identical, as it will have a new order number assigned) and creating new linked LIGNE_COMMANDE records (identical but linked to this newly created COMMANDE record).