Ask the Community

When a form is submitted, the information does not populate into the base right away as it always has. When I check the base the following day-- usually 24 hours later-- the information is there.We are on the Team (plus) plan, and have been for more than a year. This is the 4th or 5th time this has occurred within the past year. This impacts our workflow. Please help... what does the mean?

Im looking for a tool that will connect with Airtable so that I can use the APi/Whatever to map in the contact sets we have, create cards and relatiponships with those contacts in our tables and show these on a high quality map publically.Im very used to doing this in a platform like Voxel (but that is WP based) and thats my fallback, but that is held back by WP. Im needing something that is super fast and SAAS based, that can publically connect and manage thousands of visits without falling over. Anyone using any good public tools? The mapping in the extensions are not on the same radar as this.

I have enabled viewing record details and customized the 'sub interface' however I now have 15 instances of this and have no idea how they appeared there, they all look identical except that the automation buttons don't work... is there somwhere I can view and delete all of these without having to go via the 'parent' interface?

Seems like I did this in a past life, but I can't find it  now.Just want to import or past selections from excel or CSV as options for single select field.Thanks for all help!

I run a renovation and interior design firm.  I thought Airtable was going to be the ultimate solution and have spent months perfecting my bases.  We need a database of products and materials that we can assign to projects and present choices and final selections to our clients.  Our clients are not other businesses, they are individual homeowners, so we are not going to ask them to create accounts in Airtable or become collaborators on our internal system.  Each product record has a lot of internal pricing information that we do not want to share with our clients.  I tried several extensions but they fell short in many ways (only show one record at a time, only show certain pre-set fields, etc).  I tried creating a shared, curated view but our clients could still open and view any field they want.  The list view looked fantastic but there's no way to share OR print!  I spent hours creating awesome interfaces just to discover they're only availab

Hi,I would love to able to share custom apps with external users. Maybe someone has an idea if I can realize that using the airtable interfaces. Dashboards can be build super quickly. In general, I have a straight-forward use case:We are using Airtable as CRM and would like to allow customers to access their data / i.e. an overview of their data. It would be great if we could just send them a link and they immediately have access to a dashboard. Is this somehow realizable? 

Hi. Thanks in advance for any help.I'd like to take a table with dated records in them, then group them by month-Year.How do I take a date format and make a field that will allow me to show the latest records at the top for a particular month? For example:2024 - 2 (all records follow)2024 - 1 (all records follow)2023 - 12 (all records follow)etceteraThen of course as we add newer records at the top, they'll continue.Thanks!  

The objective of the code is to select the options that are in the array for a multiple select field. I don't understand why it never allows adding options even if they are exactly the same as those in the table. It is an automation script. Thanks in advance for the help.  let table = base.getTable("TABLE"); // the table is correct let fieldName = "Technology"; let recordId = "recXXXXXXXXXXXXXX"; // the record id is correct let selectedOptions = ["AI", "Augmented Reality"]; let record = await table.selectRecordAsync(recordId); if (record) { let currentValues = record.getCellValue(fieldName) || []; let newValues = [ ...currentValues.filter(opcion => selectedOptions.includes(opcion)), ...selectedOptions.filter(opcion => !currentValues.includes(opcion)) ]; await table.updateRecordAsync(recordId, { [fieldName]: newValues }); console.log(`Record ${recordId} updated with options: ${newValues.join(", ")}`); } else { conso

Hello, I'm using the duration field to track recorded audio sessions that vary in length. Currently have it formatted as (HH:MM:SS) to account for sessions that are both multiple hours long and less than an hour long. When I have sessions that are less than an hour long, Airtable won't display a zero value in the hour slot. Ex: a session is 30 minutes and 6 seconds, but Airtable displays it as 30:06. This makes it appear as if the session is 30 hours and 6 minutes long. I would prefer it to display as 00:30:06 for clarity. Does anyone know how I can get the field to display zero values? 

I teaching myself automations and have a requirement I cannot figure out how to get to work. Love ideas.I need to set up a daily automation that looks at all of the records in a certain table and if any record has yesterday's date, send a single email to the recipient that includes a link to a view to look at the data. So the logic would be something like in table X, count number of records where payment date = yesterday. If count > 0, send an email with a link to a view that shows all the records with payment date = yesterday.Thank you!!!

Hi allCan someone please advise how to make an automation to occur for when a button is clicked ("complete in 'Next Action' field) this will match the Quantity Ordered number to Quantity Dispatched number so that Quantity Remaining formula shows as 0.Alternative suggestions welcome 🙂 Just wanting an override in my system as Ordered doesnt = Dispatched 

On a dashboard interface, I have a pivot table that counts the number of times a parameter (e.g. the ticket price for the exhibition) was mentioned by visitors in their reviews and I have those counts be computed for each venue (see Attachment #1). I would like to have cells be color-coded depending on their value: shades of green for the Strengths pivot table, shades of red for the Weaknesses pivot table. Unless I'm mistaken, as yet it's not possible to get this visualization feature on Airtable. Would you have any workaround to suggest?Similarly, I'd like to get the same formatting on the table that's displayed on the PDF report that gets generated by Documint (see attachment #2). Any other PDF-generating tool to suggest that would allow me to get this color-coding? 

I am syncing my Google Calendar with airtable - one way: I'm adding the bookings on Google Calendar and they display on my airtable calender view. Today, none of my bookings after tomorrow is showing on my Airtable. Is there something wrong? 

I need some help with something. I am building out a project management system for my team. Our projects tend to be pretty big, so each project has it's own base. But, we need a project overview base to allow leadership to see the status of projects easily. I have an Overview base built, but I need some way to automatically update the percent complete of each project in the Overview base. We have the team level subscription, so I cannot update the source records from the project base. I would prefer not to use any 3rd party systems like Make or Zapier, but if that is the only way to do this, I am open to it. Any help or ideas would be awesome! 

I have read all the comments and solutions re: logos in the emails.  I have done<img width="200" height="50" src="https://www.brittcoxgroup.com/site_data/brittcoxgroup/editor_assets/Wide%20Logo%20with%20CB.png">but it still does not work.  Please help. 

I'm creating a script to compare two rollup fields and add the values both share into a third column. The fields roll up linked record fields and return them as just the text in a comma-separated list. Airtable documentation says rollup fields are an array; it looks like this is technically true, but it seems to be an array of a single string. When I log.console the cell value (note, I'm using getCellValue, not getCellValueAsString), I get ["Category 1, Category 2, Category 3"]. I want to get an array of multiple strings: ["Category 1", "Category 2", "Category 3"]. I'm very new to Airtable, so before I try to figure out ways within my script to separate the one string using the commas and all that, I want to make ask:1. Is this single string output the expected behavior, or is my script calling it incorrectly?2. If it's normal, is there way to configure the rollup fields to instead keep them as separate items?

I have a table with two date fields- "date created" and date "completed". I would like to create a formula that calculates the number of dates that passed from the date the record was created to the date it was marked as "completed". What's the right formula for this?

I found a great Airtable template but I can't for the life of me figure out how to get that template into my existing base. I get it that I can sync and then remove the sync, but the reason the template is so cool is because of the multiple tables, views and interfaces.Am I right that I would have to sync each table in the template to my base and then edit to get all of the configurations, like views and interfaces?I also understand that I can make a copy of the template and sync my existing tables to this new base and then delete the old one, but this means that all of the links I've shared out will no longer work, which leads to frustration and less uptake of the toolIf I understand this right, templates are designed only for when you're starting a brand new base and not good for adding to existing bases. Is this correct? I feel like I'm missing something! ETA: I see this feedback from 2017 but I'm only the 3rd person to upvote it in 7 years. Is this really not possibl

The AI responses in an automation action have drastically deteriorated. I suspect the reason is Airtable is no longer calling GPT-4. Previously, you could choose between GPT-3 or GPT-4. Now it is a toggle that says "Use AI models that optimize for best results", which I only noticed when investigating some bizarre fields in my base that were populated via AI. 

Dear all, when I prepare the message of a mail to be sent in an automation, some field (eg.: coming from a column with formula (concatenate)) are different from the original.In particulare the character "_" is lost and even "\\" is changed to "\\".Less important: also some emojis are changed. Could you help me to fix the issue?Thank you very much.Best regardsA. Borriero

I'm having difficulties understanding how to link these two tables and would appreciate a little help.Table 1 called "Products" looks a bit like this:MakeLineModelTypeDellLatitude123LaptopDellOptiplex3231DesktopHPProbookA34LaptopAll the fields are Single Text except Type which is Single SelectThen I have another table called 'Processes' with only two fieldsTypeProcessLaptopBox AssemblyLaptopScreen ManufactureLaptopPSU TestingDesktopBox AssemblyDesktopCase PaintDesktopPSU TestingOn the Product Table, I'd like it to "lookup" the selected product type and complete a field containing all of the processes.TypeProcessLaptopBox Assembly, Screen Manufacture, PSU TestingDesktopBox Assembly, Case Paint, PSU TestingI'm having trouble understanding how to set this up. Any ideas?

Hi, I have two tables in a Database.One table: called "People". It has list of peoples and their Emails.Second table: called "Mailing" Has email from table one.I would like to set an new field in "People" (table 1) that marks "1" if an email is present in both tables. I called this field "Did_I_found_Email" (1 = yes, 0 = No).How do I do this?    

Hi allI have an Orders Table and an Order Line Items table.I have a Date Required field within the Orders Table which is linked to my Order Line Items table.I want to have an Updated ETD (estimated time of departure) field against each line item so it is separate from affecting the overall order ETD (i.e. each line item with one order can have a different ETD).Ideally I want to just show the format as mmm-yy (i.e. July-24)Any ideas on automating this so that the Updated ETD takes the Date Required data but can be editable? Thanks!

Is there anyway to change the “row Height” of the primary row? I have a sheet with a bunch of check boxes, but the rows are very wide due to the names (that can no be helped) It makes the checkbox feature seem pretty useless. Anyone know how to change that or be able to “:wrap text” in the primary row?

Dear all I have 3 tables.1. table is a list of construction sides.2. table is a list of for different services that we offer on those construction sides. Each record has the name of the service and the linked construction side. Here are all services of all construction sides listed3. table has one field where you can link to services from the second table and a 2. field where you can put the time it took to finish the specific service.This 3 Table should be populated through an Interface. Best would be a form. But i dont want the user to see all services of all construction sides in the menu for field 1 but allow him to filter for construction sides.Any Idea how to do this?I would be greatful for help!