Ask the Community

I have set up a Calendar view for events with Start and End times from my database. The calendar view sometimes shows subsequent/non-overlapping events as overlapping on the calendar. For example, all of the events in the screenshot immediately succeed the previous event. Some are shown as non-overlapping, while others are shown as overlapping events in the UI. Why does this happen? Is there a way to fix so that they do not appear as overlapping in the UI?

Hey! I have 3 checkbox fields that indicate the completion of a task. I want to show completion of the tasks using the newly released progress bar on the Percent tab, but without having to manually type in the thirds (1/3, 2/3, 3/3). If I use a formula to sum up the checks as a third, then use another formula to make it into a percent, I still won't be able to get the bar since the formula field does not come with that feature. How do I get that % into the percent field without having to create an automation? Is that the only way, or is there an easier/simpler way to go about this?Thanks in advance 🙂   

Hi,I'm trying to figure out if there is a script or formula to allow for when cells are updated in a column of a Google Sheet to update a corresponding column in Airtable. Here's the scenario I have:I have a Google Sheet that is organized by client project and it tracks the number of project hours used. I'd love for when the corresponding client project's client hours are updated in that Google Sheet that it is updated in the corresponding client record field in Airtable. I see a lot of stuff for updating a Sheet based upon an Airtable trigger, but not the other way. And I know that there is a Google Sheets API to add a row, but that's not what I need either as no new rows are created, it's just a field being updated.Hopefully this makes sense. Would really love any guidance on this that someone may have.Thank you!Julie 

I'm using the Airtable node in n8n to search records, and I noticed that the Limit field doesn't allow me to set a value higher than 100. Previously, I could set it to 600 without any issues. Has there been a change in the Airtable integration or any updates to the node that enforce this new limit? If so, is there a workaround to retrieve more than 100 records in a single query? Any guidance would be appreciated! 

Does anyone know if it’s possible to generate a url in Airtable that would both prefill fields AND autosubmit the form. I would like to be able to send a client a link (generated from an Airtable formula) via e-mail, that once clicked, would submit an Airtable form automatically with prefilled information. In other words, clicking the link would take them directly to the form submission confirmation page. All they have to do is click the link (or button in the e-mail) and their form is automatically submitted. I know that this is now possible using Stacker.app, but I was hoping for a similar solution simply using e-mail. In Stacker.app they add "&autosave=1 at the end of the url, but this doesn’t seem to work for me outside of that app. I’m guessing that this can probably be done using a e-mail button or link with a Zapier webhook, but I was hoping to avoid that if possible. If there is something similar to the “&autosave=1” feature, that would be ideal.

How can I quickly get the Airtable Support to contact us? I am seeing a lot of people complaining that that the airtable support does not reply. And the Bot is killing me by routing the whole conversation in circles. I really need them to rectify my issue ASAP, as it is affecting out programmes.Hope that by posting it here they could help me.Reference No: 0088832000889887

Hello, So I have an automation to trigger when a checkbox is checked (in screenshot). It works when I test it, but it's not working on it's own. Meaning, when I add a new record and then at the end I check the checkbox, it doesn't add a new record to the programs calendar. I'm not sure what the issue is. Any help would be appreciated.Take care,YSDT

I'm tracking book publications and each of the titles in my database will have several dates for different formats - Hardback, paperback, ebook and Audio...I'm trying to create a formula that will automatically select the earliest of these dates so that I can use that to trigger something else.I've searched other questions and found this:MIN(VALUE(DATETIME_FORMAT({Date Field #1},'YYYYMMDD')),VALUE(DATETIME_FORMAT({Date Field #2},'YYYYMMDD')),VALUE(DATETIME_FORMAT({Date Field #3},'YYYYMMDD')),VALUE(DATETIME_FORMAT({Date Field #4},'YYYYMMDD')) )I feel like this is partway there but because some books don’t have all formats some of these fields will be blank for some titles and where that’s the case I just get an error message. Is there a way to tell it to ignore any blank fields?Thanks 

Wondering if it is possible to run the auto-number column, but conditional on another column. We are setting up a purchase order tracking log, and I would like things to autonumber based on the field for who is doing the ordering. So if Steve goes in to create 3 separate orders, he picks “Steve” from the single-select dropdown field “Ordered By” and then he gets a sequence of auto-numbers. For his 3 orders, he would get 1, 2, and 3 (I would have the key column by a formula that creates a unique ID based on “Ordered By” and the Autonumber, so it would probably be “Steve001”, Steve002", “Steve003”, etc etc). If Dave then goes in and enters an order for himself, what we would like is for the auto-numbering to restart for the new single-select entry “Dave” so that Dave’s first entry would get an autonumber “1” again, and the key field would be “Dave001”. If steve then goes to do another entry, he would get “Steve004”. So far, I am not seeing how to do this (or if it can be

Hi all, I would like to know if there is a way to increase the time slot unit vertically in the calendar view. The reason is that it seems that for events with durations smaller than 30 minutes, the events don’t fit any more one above the other and they are showed with a horizontal offset and a slight vertical overlap (see this screenshot). This is not great as it suggests visually that there is an overlap of events, which is not the case. Is there a solution to this problem? In advance, thanks for your help!

Hi all,I'm trying to setup an automation that updates a record when an events is scheduled that matches users in the database to confirm that they scheduled and when. I can do this with Zapier but I'm trying to do it directly in Airtable.The main problem is that I need to use Attendees to Find a Record where e-mail contains "guest email" but this field is grayed out and says "No valid nested options".Any ideas / suggestions?

So I'm running into an error that I can't seem to fix. Whenever I try to set a condition based on a linked record or a formula field, I get that an unknown error has occurred.My first table, products, have a linked field to a record inside the main product master where the product's vendor is linked. So I've created a lookup field for the vendor record id and stored it inside my products table. The value for that record is "recSdTazTLqgiGtBb".My second table, Vendor IDs, which contains all of my different Webflow IDs, is also linked to the vendor in the table. Here I get the exact same field value "recSdTazTLqgiGtBb".Now I want to run automation that temporarily puts a webflow ID into my products record that I'm trying to edit. The trigger is an update to the action field, which works fine.The next step is a conditional logic group that asks

Hello everyone,I come to ask for your help. I created a Google calendar event creation automation from Air Table records. Everything was going very well until recently. Unfortunately for a few days, the automation has stopped working and I end up with the following message: "Unable to parse datetime".I saw on the community that this problem came up often but without a real solution. Could someone tell me how to solve this problem?Thank you so much.

Hello,@ScottWorld, after watching one of your videos, I set up a Make scenario to automate a csv export from an Airtable view:I used the CSV "create csv advanced" module and it works fine.My problem is that all fields in the exported csv are surrounded by double quotes:Do you know how I can remove them?Thank youPascal

Hola :wave: quisiera saber si alguien puede ayudarme con una capacitación de Artable, para gestionar adecuadamente el seguimiento de los clientes. :pray:

I'm trying to pull data directly from linked record in an Automation by using the Find Records action with a Condition to match the Record ID which i added to the main record via Lookup field. BUT when I try to reference the Rec ID field it says "no valid nested options"?? I am using the gear icon to match and find the recordIs there some way to lookup a linked record and pull data into Automation directly, ie without adding fields manually to the main record?

I am trying to import XML file but keep getting invalid Xpath (I copy it from XML reader or I modify it based on the requirements) or no results (I am sure that file has 200+ opportunities). Any suggestions?<?xml version="1.0" encoding="UTF-8"?><Grants xsi:schemaLocation="http://apply.grants.gov/system/OpportunityDetail-V1.0 https://apply07.grants.gov/apply/system/schemas/OpportunityDetail-V1.0.xsd" xmlns="http://apply.grants.gov/system/OpportunityDetail-V1.0" xmlns:xsi="

Hi everyone! I would like to know if it possible to search in all fields of a table while looking for a linked record (in another table). I tried to do that but I get result only from the first field

Hello and thank you for everyone I have api documentation from a Delivery Company and I would like to get shipping quote to our airtableThat’s what I got from themhttps://api.aitworldwide.comif anyone have idea I would love to know thank you 🙏

I mistakenly clicked 'unsubscribe', and now I can't receive any emails from Airtable Automation (noreply+automations@airtableemail.com). Since my email provider is not a common one like Outlook or Gmail, I don't have the option to add 'Safe senders' or 'domains'. Is there any solution to my problem? Thanks a lot!

We have an Airtable business account – it's our slow season so we're trying to save some money so I'm working on changing up our base design to be more forms-based.One thing I'm curious about though – say I make an interface with a button that triggers an automatic, then I have a user with read-only access and an unpaid account.  I assume that they would not be able to push that button to run the automation, is that accurate?

Hi, I have a Contest Definition Table  that is capturing specific dates related to a contest.  I have start and stop dates for about 5-7 different stages of a contest, so Nominations Open, Nominations Close, Voting Opens, Voting Closes, etc. I have a record template set to create a set of tasks in a separate Tasks table for each contest based on those dates. The tasks are linked to the Contest Definition Table, All of that works just fine.  Each task has it's own Start and End date. There are actuals tasks for Open Nominations, and Open voting which is set based on dates designated in the Contest Definition Table. What I am having a hard time figuring out is how to update theTask dates when dates change in the Contest Definition Table. Thanks for any help you can provide. 

Hey Airtable community,I've got an automation where I need to create multiple task records when an episode is marked as "received". Here's my setup:Tasks List table: Contains template tasks linked to specific showsEpisodes table: Where I check "received" to trigger automationTasks table: Where new tasks should be createdCurrent automation:Trigger: When "received" is checked in EpisodesFind records: Looks up matching tasks from Tasks List based on showCreate record: Tries to create tasks in Tasks tableProblem: The "Create record" action creates one record with all tasks combined, but I need separate records for each task found. Quick example: The "Tasks list" table has entries for Task List    | Show |Transcode | Show A Show B |Send to A  | Show B |

Hi Everyone,I’m experiencing a frustrating issue with a user in my Airtable workspace. I’ve set their seat to Viewer, but I’ve noticed that it occasionally changes to Editor without my intervention. This forces me to periodically check and reset their seat to avoid being charged for an additional Editor seat.This month, I missed checking for a couple of weeks and ended up with a $400 charge due to the seat change. Airtable’s customer support has been great about refunds, but I’d like to find a solution to prevent this from happening altogether.Has anyone else experienced this issue? Are there any known fixes or preventative measures I can take to ensure the seat stays set as Viewer?Thanks for your help!

Please solve for me. If I wanted to control which bases a collaborator (individual) has access to and added the individual to each specific base, am I only charged once, since same user?Example, there are 5 bases in ABC workspace, and Bob needs only access to 3 of them. He’s added to all 3. Since same user/email address, is the charge only for one collaborator?