Ask the Community

Hello. I've 6 tables, I've carefully counted the records (with no filters), it's 906, and Airtable indicates it's Off-limit. (only 5 records deleted in the past week)I've removed 32 records, My computed total is now 874, but Airtable indicates 983 (now inside limits !). All other bases are below 1000 recordsDo you have an idea of the difference (109 records) explanation ? (I need these 100 records !)I work in a non profit organisation giving information technology training, and showing Airtable experience for other bigger organisations with bigger budgets. We have only volunteers, impossible to buy a PRO Plan.Thank's for your help

Hello, I was wondering how I update my fetch code in observable to use the personal access tokens? Here is the notebook: https://observablehq.com/@datagrazing/fermentation-jar and the code in question: Airtable = (await import("https://cdn.skypack.dev/airtable@0.11.1?min")).defaultfull_data = { data = { const base = new Airtable({ apiKey: API_KEY }).base(BASE); const records = await base("ratios").select({ view: "Grid view" }).all(); return records.map((d) => d.fields); }

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 with CORS.Since CORS worked for me yesterday and does not work today I wonder if Airtable API blocked me? But it

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 syntax for months without an issue.

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 that it will group together.I am trying to get it setup to do an automation that sends the receipts to the finance manager by staff person by month. I am able to do the email that pulls all the receipts together for that month, but can't figure out how to break it down by person. The staff tab has a lookup of receipts by person, but it is pulling all the receipts. I

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 currentHealth = record.getCellValu

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!