Ask the Community

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 Session Banner (Automated)', namingFormat: 'if24_session

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).

Hello, I need help structuring my datetime_format as it has been showing inaccurate days.What I want is to have ~ Live Event ~ On-Air Start date(MMDDYY) and my formula is below:However, with this formula, it is producing a date that is the following day when any time is past 12:00. I'm using the 24 hour time clock.Can someone help me fix this? 

I have an interface that has been made to show lists of all of the Purchase Orders, Purchase Order Items, and Invoices from clients. (Purchase Orders is a table, Purchase Order Items is a table, and Invoices is a table. Each of these tables uses the client's number as part of the name of the record.)Right now, the only solution I have to show everything for a client is to enter their client number into three separate filter elements. (Each filter element is connected to a list in the interface - a list of Purchase Orders, a list of Purchase Order Items, and a list of Invoices.) The filters all work with the same search term because of the client's number being used in the name of the records in the three tables.Is there a way to somehow tie these together so that I can enter just one piece of information in an interface and have it display results from three different tables?

Can Forms be customized outside of just adding the fields in the table? Can I add labels or pictures that don’t add anything to the table but improve the look of the form?

hi everyone, I have created a form with the new form designer in interfaces. When I share the link to it, it shows an Airtable image and title, which may discourage the audience from actually opening the link in the first place...Is there a way to edit/change the cover image and title that are displayed when the form link is shared? thank you

Hello! I am currently using the below formula to pull together a list of cities that correspond to a record. I have City 1, City 2, City 3, City 4, City 5, Cities 6 fields. Formula looks like this: CONCATENATE({BP City 1}, ", ",{BP City 2}, ", ",{BP City 3}, ", ",{BP City 4}, ", ",{BP City 5}, ", ",{BP Cities 6}) My formula works if all 6 fields contain cities although it doesn’t look great if only one city is listed. It ends up looking like this: Philadelphia, , , , , Anyone know how to fix the formula so that the appropriate number of commas appear so there will not be a string of messy commas at the end? Thank you!