Ask the Community

Hello I am developing a browser extension. It does Airtable OAuth and then lets the user fetch tables and quickly add records directly from the browser.Yesterday it all worked well for me and today the Airtable API does not send the appropriate CORS headers."Access to fetch at 'https://airtable.com/oauth2/v1/token' from origin 'chrome-extension://bnpbihfpfplcakeplbgbmopmppdkgcdn' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. If an opaque response serves your needs, set the request's mode to 'no-cors' to fetch the resource with CORS disabled."It is indeed true that the preflight request does not have these Access Control headers.I tried the same request from cURL and it passes there and I get back the tokens just fine so it's clear this is an issue

Trying to figure the basics of Airtable. At this point i just want to populate a Single Select field in Table A with information in a field from Table B. Doable? Thank you for our time ~ Tom

Hey,I have a base where I am storing the height of people, I would like to store the height in feet and inches.I also need to sort and filter by this field as well.I found 4 options that I can do:- I can store it as a string, but then I cant really sort and filter it well- I can store it as a decimal, but then 5.11 is out of order and 5.1 and 5.10 look the same, since all numbers have the same amount of decimal points- I can store it as inches, but then when I go to filter itll be super annoying for the user, since im using interfaces.- I can store 2 columns one in feet and one in inches, but thats annoying for the user as well. But it might be the best option for meAll these options are not really useful for my needs.Does anyone else have any other idea of what I can do to make this work for me? Thanks

We have a series of event registration forms listed on our web site, with URLs that prefill a particular field and hide it from the user. These links all broke today. Help!For example, this link (which is live on our site) stopped working today:https://airtable.com/appOQfoS4FjmyZPko/shr3lPQDrY1VTx0Ba?prefill_Events=STEM%20Helping%20Students%20Learn&hide_Events=trueBut removing the prefill_Events and hide_Events workarounds leaves us with a form that does:https://airtable.com/appOQfoS4FjmyZPko/shr3lPQDrY1VTx0BaAny ideas about why this stopped working today? We have been using this prefill URL sy

Hi,Let's say I have a People table with Name A, Name B, Name C.Another Table "Sports", which links Name A with Football, Name A with Football (again), Name A with Basketball, Name B with Basketball, Name B with Basketball, etc.In the People table I want to create a (rollup?) field that returns e.g. for Name A: "Football (2), Basketball (1)" as a string.Haven't been able to figure it out playing with COUNT, ARRAY, etc in Rollup field and searching this forum. Any ideas?

I am trying to create a formula to calculate the number of days a specific status is active. For example, how many days the ticket is "On Hold". The need is to calculate the number of days the ticket was actually active, in other words the difference between the {Closed Date} and the {Created Date}, minus the number of days the ticket was in a "On Hold" status. However, I am not finding a way to keep the counter, when the status changes. Currently, the counter resets to 0 when the status changes. If you could advise me on how to do this, that would be great!

I’ve been working on a custom Extension (App) using the “Getting started” guide. The Extension has been working fine, running on my localhost at https://localhost:9000. Today, the Extension in the Airtable UI started showing the following message: { "error": "FORBIDDEN", "message": "blockId mismatch. Make sure you are entering development for the correct block." } The error message is very clear, but I haven’t changed the blockId in the remote.json file. I’ve also tried restarting my local and reloading the UI, but this error persists. Somehow it seems like the blockId must have changed, but I’m not clear on how/why or where I would get the new blockId from. Any thoughts on how to fix? I’m assuming I could just create a new Extension, but I’d rather get to the root of the problem. Thanks in advance!

Hi, I've been testing Airtable to create a visual database system for skilled professionals in Nepal. While fetching data from Airtable API to my APP, I hardly get all data. Few of my data are missing. I have tested it using postman.  

We are using Airtable to track receipts. The current setup is a Receipts tab, where employees can fill out a form to submit their receipts. The Staff tab, is where the list of staff names are that the staff choose from when filling out the form that goes to the Receipts Tab. Then I have a 3rd tab for Reconciliation Month that the Finance Manager can apply onto the Receipts tab when they do the final approval of the receipts. The workflow is that an employee will fill out the form when they have a receipt. Then once a month the finance manager will go in and review confirm which month the receipt applies to so th

I tried to create an Automated email, and I don't know how to create a date time format nor rounding number.1. I created new fields with DateTime_Format, but when I put it in the email, nothing appear.2. I also round number in the number field and it won't round numbers in the email

I run an appointment system on Airtable and am looking to send reminders a few hours ahead of upcoming meetings.For example, a meeting is scheduled for 2pm on June 24th, therefore by 12pm on June 24th, I'd like a reminder email sent out.Which Automation Trigger would I need to use to do this? And what would the steps be? Possible solution: could I convert the time into minutes and then set up the formula such that once it hits X number of minutes before the start time, it meets "record conditions" (determined in Automations) which then leads to the automation being triggered?Thanks in advance for your help! ps I'm not interested in using external tools like Make or Zapier as we're a non-profit with limited funds - they just about stretch to Airtable. 

Hey there!I have an automation that is designed to take specific records from two separate tables and duplicate them into a single table. I used the repeat for each duplicate one of the tables, but because I can't use two I'm trying to do the same using a script but failing to add many of the record details.  let inputs = input.config(); let destinationTable = base.getTable("Executive Summaries copy"); let sourceTable = base.getTable("5-Year Automation"); let importQuery = await sourceTable.selectRecordsAsync(); let fivYearInputList = inputs.fiveYearInputList; for (let record of importQuery.records) { let strategicObjective = record.getCellValue('Strategic Objective') let updates = record.getCellValue('Monthly Update') let forcedOrder = record.getCellValue('Forced Order') let divisions = record.getCellValueAsString('Executive Sponsor') let whatIsBeingImplemented = record.getCellValue('What is being implemented?') let

Does anyone know what the max field limit is for each table in each base? Thanks.

I am trying to get a specific folder ID from Google Drive through an Airtable script based on information from a newly created record. I think I am supposed to get access to my Google Drive by connecting to it via API. I’ve built and published a web app using Google Apps Script but I’m unclear how to connect the platforms together. What are the general steps to send data from Airtable to the web app so it can take that information, process it and send back a response to update a record?

8653906699

8653906699

8653906699

8653906699

8653906699

8653906699

 alok kumar garg a screenshot of the link 

I have a table listing persons linked to another table showing tasks. I'm trying to show the remaining tasks a person needs to do.Example: These two tables are linkedTable 1: a list of 100 peopleTable 2: a list of 34 tasks to be done by each personEach time a person competes a task I link them to the task, so Bob will have 2 tasks done (linked to his record), but Mary will have 30 of the 34 tasks.It is easy to see how many tasks each person has done, but it is hard to see which ones remain. How do I go about doing this?Example goal: Mary: 4 tasks remaining, which are W X Y Z

I want to send an automated email that includes a formula field/token (it is called "6-month historical average"), formatted to 0.1 decimal place (this formula calculates an avg of the numeric values in 6 other fields, all of which are to 0.1 decimal place).Although the "6-month historical average" field is formatted to 0.1 decimal place, when I test the automation, this value always appears with a long string of decimal places e.g. instead of 4.6 it will show as 4.6248482367213....Why is this happening? I want the historical average to show with only 0.1 decimal place.Thanks for your advice!

HiIs it possible to count the number of changes or modifications that have been made to a specific record?Rgds

Hi there and Happy Friday!I am trying to calculate the time it takes an individual to get a specific type of number at the time they enroll in our program.The formula I have is essentially, "If the individual does not have a preexisting number, calculate the time difference between the date they got the number and the date they enrolled in the program." The formula is: IF({LO has FTN at time of Enrollment}="No",WORKDAY_DIFF({Enrollment Date},{Turned in FTN})) That works but if “Turned in FTN” is blank, the calculation results in "#ERROR" and I hate "#ERROR". So, that means I need to add something like, “If “Turned in FTN” = Blank, then “””. I tried adding that a few different ways but am still getting #ERROR. Any ideas how to get rid of the #ERROR? Thanks in advance!