Ask the Community

I'm building out the Airtable to Google Calendar Automation (see this article)It is important for us to hide the guest list so invitees cannot see other people invited or their contact information. There is not a setting inside Airtable automations that handles guest list or guest permissions from as far as I can see.The Google Calendar account that we are using to send out these invites has guest list and guest permissions DISABLED by default. If I create a new Google Calendar invite inside Google Calendar itself, they are disabled. Works as expected and respects the defaults.However, when I use Airtable to create Google Calendar invites, it is ignoring this setting in my Google Calendar account and creating invites that ALLOW people to view the guest list.Any ideas?

Hello,I would like to create an RSVP form that can limit the number of participants. Is it possible?

Hi all,The links to shared views (password protected) are not working as they used to; it seems users need to previously sign in or sign up for free if they want to open the URL.  Is anyone experiencing the same issue? Thanks.

Hello,I've got a problem when using the search function on interfaces, the text will change as I'm typing or miss letters, almost like a text autocorrect. It's very frustrating. I'm wondering if anyone else is having this problem or is there a work around?Thanks,Andy

I am working on an AirTable base for my warehouse that receives Vehicle Tires. Our Receiving staff runs AirTable on their iOS devices; Currently, they scan the Barcode of the Tires and it automatically goes to the respective article/item on the AirTable Base and then they add the 'Tires Received amount' to the existing Inventory. i.e. If the Existing Inventory was 1000 and a shipment of 50 Tires were received, they change the Inventory number 1000 to 1050 manually. I would like to observe the possibilities of creating a column where the user can input a number every time a consignment of tires are received and that number automatically gets added to the existing Inventory and gets updated on its own.Table in the Base is as follows:-Column A has the Tired Brand and the Model/Size;-Columns B has the Current Stock (Inventory);-Column C has the Supplier name;-Column D has the unique barcode number of each Tire type.Thanks for

I have a company planner in airtable that I want to print in a year view colour coded with the project name printed.  How do I do that?  It doesn't have a year view option so I added the calendar to my google calendar but year view in that doesn't work either!  What do other people do??  

Hi,I'm trying to determine how to display the difference between two dates as years, months then days.I have a start date and an end date, (the moment a worker started in the company and the moment he ended his contract with us), and I need to know how to have the result like "1y,3months,15days" or something like that, I found a formula that gives me the result in weeks and days, but a week always have 7 days, but a month can vary the days (28 days, 30 days, 31 days), so I am kind of confused

What is the API limit for Airtable Post/Patch requests?It looks like the number is 10. Is that correct? Are there any ways to increase it?

Hello All, I have a question about creating a custom synced calendar for each user.  I own an RV van rental management company and am trying to figure out how to have a unique calendar link for each customer that we can sync up with our user interface.  Currently, I am creating a new view for every user, but I don't see this as a scalable option as we expand. I would like a unique calendar showing each user's reservations created automatically rather than manually creating it every time we onboard a user.  I hope this makes sense.  I also don't want hundreds of views in airtable so each user can have a unique calendar.  I am using stacker as my user interface and would also like to figure out how to embed the calendar there so customers don't have to rely on a link.

I'm using the WORKDAY function and it's skipping the weekend as it should, but it always returns the previous Friday. Is there a way to have it return Friday if the date falls on a Saturday, and return Monday if it falls on Sunday?

Hello, I recently added a field to my calendar view and it appears at the top of each new entry rather than at the bottom where I would like it. Is there a way to change this order?

Hi! I am using SendGrid to send emails to everyone. When I send the email, it is a success, it was sent however recipients do not receive it all. How to fix this one?

Hi Is it possible to show the day of the week along with the date in a field?

Is it possible to set a rule for a (checkbox) column?Lets say i have 20 records, 1 column is a checkbox, I want to select 5 records at a time.If i try to select 6 records, maybe a popup or something letting me know i've selected 5 already.Is that possible?

I have a “Links” table. The primary field is a friendly name and the second column is a URL. When I view this record from a linked table, the URL is the 3rd entry down. There is another field above it. How can I reorder these? And here is the column order in the links table: Name | URL | Namespace | Type | Server | Participants

Hello Airtable Community!I'm looking to enhance my tables and I believe using scripts could be a helpful solution.Here's the issue: I have a database where company managers provide monthly forecasts for income and costs on their respective projects. Currently, I've set up an Airtable automation that detects the start of a new project and adds a record to the managers' table.However, I have a gap: when a project is completed, I want Airtable to lock in all the data entered up to and including the project's end date, and then remove any predictions made after that date. Does anyone have a solution for achieving this? Your assistance would be greatly appreciated!

We have built an automation that syncs data from our CRM with Airtable. Each insert/update/delete in the CRM post a message to a webhook created from an Automation. This works perfectly fine for single transactions in the CRM but for a bulk update or an import in the CRM of e.g. 500 records it only processes a limited number of records (e.g. 168 out of 800). Is there a limitation in the number of instances of a script that can run in parallel? And if so, is there a way in Airtable to work around this as I have no idea to buffer the webhooks coming in.

I have two tables: one called companies and one called candidates.  I'm creating a form for candidates to fill out which will add them to the candidate table.  One of the questions on the form is "where do you live?".  I want to match them with companies that are in their same city, so I want the company locations I have in my companies table to be the options for the "where do you live" list in the candidate form.  Is there a way to sync these up?  I tried linking the record, but I get a message saying "this is read only and won't appear on the form".  Ideally I want new locations to be automatically added to the candidate form when I add a new company with a new location.  

"I am conducting research to monitor the depression status of patients. It's crucial that I track their status on a weekly basis. Consequently, I am looking to set up a reminder calendar to facilitate this. I've utilized the provided formula to determine follow-up dates, but Airtable suggests that the outcome isn't recognized as a date format. This has hindered my efforts to create a calendar using the results. I would greatly appreciate any advice on this matter. Thank you!"   IF(    {First visit},    DATETIME_FORMAT(        DATEADD({First visit},1, 'weeks'),

Hi all!So I've read quite a lot of articles in here and I can't find what I am looking for.  I created 4 tables in my base :Activités (Activities)Tâches (Tasks)Sous-tâches (Subtasks)To Do'sHere's how my base works : In Activités, all our shows are listed and gets one of the following statuses (Confirmé / Option / Supplémentaire)Tâches contains our main tasks and Sous-tâches contains the subtasks. Both are linked.To Do's, would be used to create the lists of tasks. There is a link to the table Activités.Base on these informations, here's what I would like to achieve by using an automation :In Activités, when an activity with the status Option or Supplémentaire gets the status Confirmé and therefore enters the view ''Représentations confirmées'', create a list of subtasks to complete in the ta

In our organization there is some of the user that can not log in. there was no problem for them the other week but suddenly they couldn´t  Can you give me a tip what to do

Say I have a table in which each record has a Single Line Text "Notes" field with content like this:MondayGood FridayTuesdayTaco TuesdayGood FridayTuesdayI want to find all records where the Notes have exact matches, in this case for Good Friday and Tuesday, and display them together.I figured I'd have to add a field to check for uniqueness somehow and then filter for non-unique records, but I'm not sure how to do this. 

Have you had any experience with Airtable Partner Portal? How long did you wait for a response to your application? 

I have a table of date ranges: school terms and holidays over three years.How do I determine which range a specific date occurs within?

Hi,Is anyone else experiencing views not currently loading within their database?We have multiple users reporting seeing a error message "Loading this view...This view may be loading slowly due to a large number of records or fields". Some users are experiencing load times of 20 minutes. Looking into the account the record and storage limits are no where near capacity.The offices internet speed is fast and all other web based platforms are working. Any insight here would be appreciated.