Solved

The Airtable pricing page says that the Free plan includes up to 5 creators/editors and unlimited commenters and read-only users. Do those apply to the Plus and Pro plans? If not, why not? Am trying to get Airtable a paying customer and can probs get my client to go from paying $0/month to $10/month but they need those commenters and 1 creator (that’s me). I know that Enterprise is the latest and greatest thing, but they can’t afford $10K/year. Thanks so much.

Hello all,I have a table that's filled with (linked) dates. To be able to view all the dates in a list, i've created in the script app a script to give me that list. But, is there a possibilty to sort that list?Below the code: // Change this name to use a different table let table = base.getTable("Deadlines"); // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); let Weer = record.getCellValue('NB-Weer - DATE'); let Dag = record.getCellValue('NB-Dagkrant - DATE'); let Pagina = record.getCellValue('NB-1-1 Pagina DATE'); output.markdown(`**NB-Weer:** ${Weer}`); output.markdown(`**NB-Dagkrant:** ${Dag}`); output.markdown(`**NB-Dagkrant:** ${Pagina}`); ... and the result:Very much a scripting newbie so any help or pointers very much appreciated!Allready a big thanks and any help is welcome

To explain my project, I have two tables :- A "Movies" table that stores a list of movies, one of the fields in this table is an Attachment field that contains the movie poster image.- A "Catalogs" table that has a link to the "Movies" table.The goal of my project is to create catalogs by selecting the movies I want to include using the link to field, and then, by clicking a button, launch a Make scenario that retrieves the selected movie list and generates a catalog in PDF format using Eledo. The data insertion into Eledo is done in JSON format (example: {"title":"Movie1","description":"Description1","img":"URL1"},{"title":"Movie2","description":"Description2","img":"URL2"}).Before the Airtable changes, this project was easily working because I could simply retrieve the movie image URL using a formula for the "URL" value. However, since the changes, this is no longer possible.I do have a solution, which involves manually replacing the JSON for each movie in the Make scenario and setti

I have data that essentially looks like this:I want to use a formula to populate the last column with the type (in my example, food) based on whether or not other cells in the row are greater than 0. So IF (column A, B or C is >0, return "Fruit") AND IF (Column D>0, return "Fungus" and so on). I can get it to return one of the types but not all. Ideally they would be separated by a comma.I also sometimes have a blank cell and sometimes I have a 0. I know I can do a simple IF statement and have columns for each type, but is there a way to do this in one column?  Thank you for your patience, I am new to airtable and airtable formulas!

Hi everyoneI've come up against a limitation and I'm wondering if there might be a creative workaround for it using linked records and/or multi-select options.The problem is that when you have a base with multiple collaborators, if you have a "record comments" box in an interface, there's no way to limit which other users that collaborators can send @ comments to.  I'm building a platform that will involve multiple clients from different companies collaborating within the same base.  It's no issue restricting which records they can see based on filters by "current user" etc, but this option doesn't seem to be available for comments.  I think there may be a way to link users to records of other people just in the same company as them, and then use a multi-select option instead of the collaborators list you get when you type "@" to allow users just to select the names of colleagues, and then a checkbox or button that posts their comment.Has anyone ever done this?&nbsp

I need help - my CSV file is downloading the line breaks in my long text fields - I tried to eliminate them running >REGEX_REPLACE for \r, \n, \r\n, u2028, u2029, u0085, u00B6This took care of most of the line breaks but there are still 2 stubborn line breaks I cannot beat HELP!

Hi guys! Thanks in advance for your support.Right now I have several tables in a database, one of the tables contains the events that occur, and another table contains the types of events that exist (in order to count them). The question is, how can I count only the events that have occurred in a specific month or have been involved in that month? For example, if I want to know the number of events that have occurred in May, but an event started in April and ended in June, it is not going to count if I use a conditional which searchs for event started or ended in May.Do you have any ideas of how to implement it? 

This is driving me nuts. I have a long text field (rich text turned off) that seems to have multiple line breaks. Formula I used was Substitute(Field,“\n”,“”) and while it seems to work it also doesn’t. I tried with putting in a value instead of “” so I could see it working and it is working but also airtable seems to be keeping paragraphs anyway. Any help would be greatly appreciated.

Hi community,I don't know if i am missing smtgh or if it is impossible :When you use a calendar view, you can drag unscheduled records from the right pane into the calendar.I cannot achieve this within a interfaces' calendar.❓

Hello,This is my first day with Airtable and I have a question. Ill be importing data via a webhook. Just one location per import (or filled out form that is imported to my Airtable). I I've connected each location to a individual ID for future export. I connected the ID's to all possible locations to choose from, and I want the ID for the imported location to show up besides it. However the ID's dont show up automatically.Probably a bit of a messy explanation, so here are some pictures:The first picture is where I want the ID's to show up. So beside the "ort" column is the "ort ID". I added this ID manually to make it more clear. On the second picture are all the possible "ort" and their respective ID's. So when importing a "ort" from my website form (automatically) I want Airtable to pull the correct ID from the other table and display it beside the "ort" on the first place. How do I do that?  

I have an automation that is sending a payment receipt to a client The document of the receipt is in an attachment field of my base and I want to attach that one file to my Gmail using the native Airtable automation.Please see my Loom below for details.https://www.loom.com/share/635ea73ecb1b46b390f91e25fcedf0a6?sid=3b203e01-804c-4550-831f-abac3537c332

Hi,An erroneous automation setup has cost all my automation credit all 50,000 in a fee hours.  Hoping to get it temporary increase in credit to run our business function.  All our workflows have stalled. Need urgent help. Much appreciated  

Hi, With the new interface features, is it possible to share an interface with a lead/client for that person to add and edit a new record (with access to his/her own record only)? I want to use one or more calculators as lead generator tools, and also as tools for clients (who are not Airtable users themselves). Is this doable with the pro plan, without extra costs for each person using the interface, and without third party apps?

Hello guys, i have a table where i calculate some values which can also have a Zero.That means that i sometimes get 3/0 which leads to a Nan error.I already tried a couple of formulas but i do not get it. So my question right now is how can i put the cells which would have Nan as a value to 0? I would be happy for a solution. Thank you.

I have a linked record field in my table (Table A) where I disallowed the linking with multiple records from Table B. However, when I duplicate a record in Table B that is linked to a record in Table A, the linked record field in Table A gets 2 linked record, even though the linking with multiple records is still disallowed. How can I prevent this to happen?

Love the new List View - really useful.BUT - is there a way of removing the "Level 1" text in interface designer?  See screenshot.  I just don't need it and it would be confusing to users. 

Hello you!I'm looking to remove 2 characters of fields, from the right of the cell. I have a list of prices, like that, no currency :1570197401549I'm looking to get this :157 Є97 Є15 ЄThe deleted numbers are the cents 🙂Cheers! 

HelloI've managed to create a formula that adds x number of days to a start date and pushes the result to a work day if the end date is Saturday or Sunday:IF(AND({Direction start date},{Number of days},"days"),WORKDAY({Direction start date},{Number of days}),"days"),{Number of days})The result seems to work fine, however the formating isn't great as the answer is is like this 2023-06-02T00:00:00.000Z .  I've clicked the format option but that doesn't let me do anything.  Any suggestions would be gratefully received! 

I'm sleuthing but not getting anywhere - would be grateful for pointers for the following which is the crux of my business.  Is this an automation? Or a script? Should I start looking at Make? Thank you so much. Table A - Long List of People (500+)Table B - List of One-off Events (500+)How best to create Table C - Shortlist (50+) people going to 1 event?I've seen the Event Tracking Base and understand the connected table structure but there are so many People/Events and wondered if, instead of manually typing the person or event into a field, I could go to Table A, scroll through and tick let's say 50 people to go to 1 event in Table B, and have that create a new separate line item record in Table C that I can then use as a lead to chase (without creating duplications if they are already on the list)  

I am new to Airtable and having trolled the site, youtube, internet and anywhere else I could think of have been unable to find a solution.Is it possible to create a customised user friendly data entry form to my own design? Instead of a set piece format.Many ThanksBruce

I have a script that runs in google apps script and deletes all the records in a airtable table one by one, since I am new to coding and don't know how to code can anyone help me to modify the script to delete the records in batches of 10. I used chat-gpt to generate the script.The script that deletes airtable records is:function deleteRecordsInBatches() { var airtableApiKey = "API_KEY/ACCESS_TOKEN"; //Paste your apiKey or accessToken here var baseId = "BASE_ID"; //Paste your baseId here var tableName = "tab3"; //Paste your tableName // Number of records to delete in each batch var batchSize = 10; var tableUrl = "https://api.airtable.com/v0/" + baseId + "/" + tableName; var headers = { "Authorization": "Bearer " + airtableApiKey, "Content-Type": "application/json" }; // Fetch the initial set of records var recordsToDelete = fetchRecords(tableUrl, headers); while (recordsToDelete.length > 0) { var batchRecords = recordsToDelete.splice(0, batchS

Looking over the API documentation, it appears that attachments require a url key, so they must already be available on a web server. Is it possible to upload local files to Airtable via the API? I’d like to build my own form that POSTs to Airtable and uploads an image as an attachment, but it doesn’t look like this is currently possible. Am I missing something? Thanks!

HiI have in my AirTable a list of Names. Lets say I want to find all results with last name "brown". I am making a search for people with formular like this:filterByFormula: LOWER({TABLE_ID})="brown"How can I do it that if I search "bro", or even "own", it will also send the result of someone with name "brown". Meaning I want to receive when the String contains the seach word, not just when its an exact match.Thanks

Hello! New to Airtable. Trying it out to see whether I can use it for a specific need I have. Scenario: Our community (of around 500 members) have a shared google sheet having each of our basic details. I have imported that to a airtable base. Question: Can I set the permission on the base such that (i) all members can view the table AND (ii) each member of the group can edit their row?Thanks!Varun