Ask the Community

Here's the situation. I need a base with 4 tables. Each table has inventory for 4 different types of products. Data for each record includes descriptors including single and multi-selects, text and most importantly the # available. The inventory manager would add this data. So far, pretty easy. Next, want to create a form so requestors can order from this inventory. Requestors would need to see the inventory available by type. As requestors fill out the form to place their order, we need to see the inventory amount change in real-time such that if user #one depletes the stock, user #2 will see a notice similar to "currently out of stock, will be ordered."  It would be nice if the inventory manager would be notified that a product would need to be ordered. There would also be the need on the form to order a product that is currently not in inventory. Not sure if the existing data sets would be used or just an open text box.Can Airtable do this?

Hello Airtable Team.I am trying to run the following script, but it show me this error:ERRORTypeError: trackerSsot.watch is not a function at main on line 7Script:// Define the table and field namesconst tagsPods = base.getTable('TAGS TSM PODS');const trackerSsot = base.getTable('Team Tracker SSOT');const fieldToFill = tagsPods.getField('FULL NAME')// Listen&nbs

I run a table that keeps track of content my team creates for a digital billboard. When we hear about new content, our project manager builds out a production schedule based on the date the content is supposed to go live on screen.To help my PM with scheduling, I used formulas to populate some milestone columns (initial concepts due, kickoff to production, multiple creative reviews, etc...) with some estimated days for each step in the process. For example: Project Kickoff should occur about a month from the start date and uses "WORKDAY({Start Date}, -33)" while the File Handoff date is only a week before launch and uses "WORKDAY({Start Date}, -5)" So far, this has worked great for providing some rough dates during the initial project planni

 ERROR : {"error": {"type": "INVALID_REQUEST_MISSING_FIELDS","message": "Could not find field \\"fields\\" in the request body"},I am attempting to insert data into a simple table : 4 cols called A,B,C,D datatype of cols is the same single string.I compose my JSON body raw as follows : When I execute this via Postman I get the following error : If I execute the CURL command the insert works fine. This is the CURL statement : curl -X POST https://api.airtable.com/v0/apppXXXXXXXXl5tP/nXXXable

Hello!We are attempting to connect using OAuth 2 but the development team says they are not getting any answers from Airtable.We are being asked to login first - which we do, succesfully.Afterwards, we are being asked to select the base and be granted access.That's fine but after we click Grant Access, nothing happens. The team expects to receive a code of some sort.Would you kindly help me out?Thanks,Andrei 

I’m loving the idea of the SendGrid block, but from my experimentation, it appears emails can be sent only as plain text, which is virtually useless. SendGrid’s API makes it very easy to specify emails as HTML. Am I missing an option to send as HTML? This is the difference between a wildly useful tool and one that offers minimal utility.

Hello everyone - and Merry Christmas! So I am playing around with a table that contains several Records with dates in the future (new Records are being added from time to time). The Records will be made by colleagues in one department and then taken care of in another department. Right now I've made an Automation that sends an email to people from the other department with all the info they need from the specific Record so that they can complete the task straight from their inbox. However: I want to be sure that they actually do it; or in other words: I want to be sure that Records aren't forgotten. Is there a nice way to accomplish this? I thought of adding a Button to the email so that when my colleague in the other department finished the task, they could click on that Button and it will be registred in Airtable on the specific Record; however I don't see that's an option. I hope to find a solution in here! 

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.