Ask the Community

I am not sure what I am doing wrong. When I use the script I have written on the scripting extension I get the desired output, however when I put that same script into an automation, the output is all wrong.Is there something I am missing?

Hi there,I am hoping there is a formula for what I need. I want to be able to have a date populate when I put in 30 days from today, or 20 days, or 45 days.Example: I need to follow up with sales lead A 30 days from today. What is that date?Thank you! 

Hi All,I'm juste trying to write a small script in node js to get a list of a db I have here in Airtable.As the documentation said, I've used https://www.npmjs.com/package/airtableand my code is as follow :  import Airtable from 'airtable'; const baseId = '****'; const tableIdOrName = '****'; Airtable.configure({ apiKey: **** }) const airtable = new Airtable({endpointUrl: `https://api.airtable.com/v0/${baseId}`}); console.log("airtable",airtable); ==>>> {} console.log("airtable",airtable.getTable("tableIdOrName")); ==> "TypeError: airtable.getTable is not a function" Thank you for your help!

Hi AT Community,For a project I am doing resesarch on record templates. I was wondering if Airtable has any limitations on how many new records can be created at once when using a task template table to insert new tasks once a project has entered a table with certain column conditions.So, there is a project table where a new record will be created with certain columns. A combination of columns will set of an automation that will trigger the creation of new records in a task table, based on a task template. I currently have 90 tasks related to a certain project label, which need to bo copied from the task template table to the task table (the projects are pretty standardized regarding tasks). Is this possible in Airtable, or are there any limitations on how many records can be created at once through an automation?Looking forward to your reply, thanks in advance.Regards,Arjen

I prepared an api script (with the baseId, tableId and the token). I tried to run it on a console and I get error massage. We should I run it?

Does anyone think it is possible to use Airtable to manage ads for a website?I am running a small niche website that I would like to sell ad space for. As such, Google Adsense will not work for me because my website is not big enough, and it also runs under a subdomain.Therefore, I figured I could use an "image carousel" for the ads.But how would I display these ads from Airtable? Is it possible to automate? For example, if you paid for the ad, it will automatically appear in the ad space. If you have not paid, it will be taken down.I figure people could fill out a form with their ad and add it to an airtable database and if it's paid/approved it can appear on the website. Just trying to brainstorm, thanks!

Hallo community,I have two tables: "Bestellungen", "Bestellung Positionen".Table "Bestellungen" has 3 Lookup fields "Artikelnummern", "Anzahl", "Einzelpreis". So the values will be not correct sorted like in a table "Bestellung Position".I think, it is a big bug in Airtable.P. S. If it is not possible to sort automatically in "Bestellungen" table, how should I sort it in relative table "Bestellung Positionen", which filter should I use. I know how to sort Table "Bestellung Positionen" by a field with a type "Created time", then the result with be ok, but I still need an option to order it how I want... And table "Bestellungen" should automatically bring me the same order.Thanks in advance. 

I want an automation to update the linked records. It works when a record only has 1 linked record that the automation should update. But when there is more linked records to update it will not change any of them.   any suggestions?   

I just set up my first multi-source synced table. The information is syncing correctly, but the lookup and rollup fields aren’t working, those fields will only pull source data related to the first synced table, not the second. This seems like a glitch since it completely eliminates the benefits of having multi-sync functionality, has anyone else experienced this? Could this be related to something I did incorrectly at set up?

Does anyone know whether the Webhook API contributes to the new API limits on the Free/Team plans? 

I have a column that has strings of option lists, and I would like to extract only one option "COLOR=" ,between the comma & " "(space), from them. These option lists sometimes include different language letter so It must extract english only.Here we have four examples of the string that shows the pattern.COLOR=WHITE 화이트, DETAIL=NONESLEEVE=SHORT 쇼트, COLOR=SKY BLUESLEEVE=LONG, COLOR=GRAY, TOP=DOUBLECOLOR=LIGHT YELLOW 밝은 노랑=>>>> I would like to see >>>>COLOR=WHITECOLOR=SKY BLUECOLOR=GRAYCOLOR=LIGHT YELLOWI tried REGEX-EXTRACT({option column},"COLOR=[a-zA-Z]+.*[a-zA-Z]+)"but obviously it includes after comma as well. something with '*,+' was recommended but do not know how to combine these..Thanks for the help in advanced!

My automation has to update the Currency field with the formula field value. The formula field contains a number formatted as currency.When testing automation I receive an error message "Fields" could not be converted to a string that I can not figure out. The updated field is currency (which is basically the number in fact) and the source field is the number as well.I will appreciate any ideas and hints on what's the problem and solution

Hi all, We are looking to find out if it is possible to create a table view that follows the pattern in the screenshot. We tried using lists but it only gave 1 layer of information, for the second layer there needs to be a new Table of contents, however, all our content is located in one master info sheet that is populated from a form. How can we achieve this view? Also maybe there is a way to create a personalized UI ?Thanks

Hey everyone! Can you help me to figure it out how to properly write this formula?IF(Result>={Goal120%},"Excellent",IF(Result={Goal100%},"Completed"),IF(Result<={Goal80%},"Partial"))Both Result, And Goals are Columms in my table. Thank you all, in advance! 

Hi, I have two use cases to solve: 1. (To simplify) the base is made from experiments (that contain) Sessions (that contain) Observations. Each experiment is matched to multiple codes. I have to create observation in context of session and assign code from experiment sets. 2. A session can contain one or more person. I have to assign a specific person to observation, it will be easier if I can select from persons that are related to the session.I'm quite new in Airtable. Is there a way to solve this two use cases? 

Hi everyone!I'd need help creating a formula that adds a number if there is one or more duplicate of that record.Example: if i have two record 'maria', one should be 'maria-1' and the other 'maria-2' or similar.For now i've tried a workaround using autonumbe, making a formula {name} & {number} but so they're not numbered sequentially by duplicates, just by the table order.Any ideas?

I've created an automation to link the submissions of two forms together based on the email a customer inputs. Presuming that they input the correct email in both forms without typos, it will link them no problem.I've just noticed today that if one email is all lower case and one has an uppercase letter then it won't connect the two even though it's spelt exactly the same.I understand there are formulae that I can use to correct the case, but I want to manage this through the automations. Is there a way to create a find record condition that is "Where *email address* is *email address*" that isn't case sensitive?

Hi there, I have a table with a field of contacts for a database I'm building for work. The table has several sections: names, roles, venues, projects, etc. I want to make a table that just looks at projects but uses all the data from the original contact list. How do I do this?

Hi everyone! We're excited to release a new feature into beta: the Sync API.It's a new sync integration that accepts CSV-formatted data through our REST API. We're hoping this makes it easier to plug in data sources that Airtable doesn't natively support.Developer documentation is available here. Usage limits are currently 10,000 rows/500 columns/2 MB per request, rate-limited to 1 request/10 min.Sync API is available as a table sync source right now - tucked away under "more sources" in this menu. A full setup guide is available here.    Sync API is currently limited to Pro and Enterprise customers.

We have several bases that we need to synch to a primary base. All fields need to synch except one. We have downloadable files that we need to change out for each synched base, but cannot edit them once we synch once we do this. Does anyone know how we can synch our bases and leave that once column editable?

  Hey guys,I just started using AirTable today and i'm going crazzy on how to set up a percentage formula.I have column A which is named goal (set up as number), column B, which is names Actual (also set up as a number field), and column C which is the variance of the two. I'm trying to create a 4th column which would show me the variance in percentage and would be great if I would be able to also show it as a progress bar. Now, I have figured out the percentage bar, but how do I get the actual percentage instead of me having to calculate it every time?Is it actually doable?I have included a screenshot so you guys can better understand me 🙂Thank you everyone!

I have TWO workspaces using the PRO STARTER PACK.Yes, the mysterious product no one has heard of. It was a blog post that's now vanished but you can read about it here: https://community.airtable.com/t5/other-questions/how-to-add-users-to-quot-pro-starter-pack-quot/td-p/129452 It was a dream come true. 5 seats x  350.00 a year all in. I loved it because it's basically just OLD PRO with an extra 100.00 fee to get four seats thrown in.I have NO idea how many people got access to it.NEW PRICING:I for ONE love the new pricing because I wanted a SMB version of Enteprise.That said, I have no idea what is happending to PRO STARTER PACK.I asked in the last community call, but I was only told answers would be coming.I want to plan ahead to so I can DOWNGRADE some clients and move some bases around.The best thing you can do if you're impacted by this change and you're NOT on enterprise is make a base of your bases and start to plan a migration path for your customers.

Hello, I'm trying to integrate Airtable with the Flexera SaaS Manager tool to capture details regarding usage and license in Flexera. I went through the steps of generating a token and landed on a page that says I need to grant Flexera Access. However, the "Grant Access" is not active - or if I click on it nothing loads. Can someone please help me? 

I have a base to manage volunteers and volunteer events. There's a Volunteers table to store volunteer information (name, email, phone, etc.). There's an Events table with details about volunteer events. There's a table called Volunteer Signups that shows which volunteers are signed up for which events.I use a form to register new or returning volunteers. The form fills in the details on the Volunteer Signups table. An automation then creates a new record in the Volunteers table if the volunteer's email is not in the system yet. If the email is in the system, a new Volunteers record is not created.Returning volunteers will then have multiple events listed on the Volunteer Signups table, one for each event they have signed up for over time. I want to have a linked record in the Volunteers table that shows only the most recent event they have signed up for. Right now I'm only able to show the first event they signed up for, not any subsequent events. What do I need to change to achieve t

I have built an Airtable structure that utilizes the Created date/time field type to track when a record is added. This Airtable solution will replace an Excel version of the same data. The Excel version contains 2 years worth of data with it’s own creation date column. When I come to import this data into Airtable, the Created date/time field is going to return a value of the import date/time and rightfully, not the real creation date from Excel, This means when I develop charts such as Records added by month, the imported data will always be linked to the import month. I will not be able to use the Created date/time field to analyse the historical data. What is the best way to only have to use one creation field date (without the user manually choosing the creation date on a form) to track the actual creation date of both historical and current/future data?