Ask the Community

I would appreciate any input for such task:I need to determine if TODAY() falls within a date range, say from March 1st to October 31st, regardless of the year.So I need to compare TODAY() with start date and end date without the year, but only with day and month.I cannot figure out how to do it.Thanks for any thoughts

Hi there, I am trying to output text that is taking the text from the lookup field "Name" and taking it away from a field called "Conversations" Currently, I am trying to do this in a formula but for some reason it keeps saying #ERROR!    

En la vista Kaban. Me muestra campos que no quiero que aparezcan. Y no tengo opción de sacarlos, solamente en la edición me deja ponerlos en el encabezado o ponerlos en el cuerpo. Pero no me da la opción de no ponerlos.

Hi Dear community I'm new on airtable and looking for how to control my stockInventory management  Need your help or if you have sample database Most welcome 

I have an interface with a list layout. I was under the impression that when you searched the list it would search every visible column? However when I search for fx “1073” it says there is nothing despite it being in my list?Is this a bug, or is it me who is getting it the wrong way? Search says there is no recordsRecords are there 

Hello everybody, Here is my situation : I have a table of CONTACT(1900 records) and a table of COMPANY (800 records), I have all ready set a link in between them. Now I would like to insert a junction table : JOB.If i use the junction script it will create all the link possible (1520000 records). Is it possible to add a condition in it so the script will create the record in the JOB table only when a link already existe between CONTACT and COMPANY?Thank very muchPlatane

Is there some reason this code does not work in the Body my automation email?<img src="{GraphicURL}">Where GraphicURL is a working URL reference to a remotely hosted JPG graphic image file (.jpg). The image placeholder shows, but the graphic is not being rendered.  

I am running a market place and use Airtable as the data source.Currently I input the data manually. Among the fields is Location with Single Select option. This is because I don’t have to type out the locations every time except when there is a new city. I have been working on an automation using make.com. The data is fetched from websites and goes through a number of modules and then through a JSON Parser where the data is structured before being passed on to Airtable. The challenge is that it seems Airtable refuses to accept locations that are not already in its database (previously input manually), so it returns a “[422] Field "Location" cannot accept the provided value.” Error. I changed it to Single Line Text but still the same issue. Is there a way to resolve this?Any tips will be greatly appreciated. 

As above I would like to be able to toggle all fields on an interface page between view and edit by clicking a button at the top of the page. 

Hello!Our organisation has basically a large ‘to-do’ list table which includes a ‘Tag’ multi-select field which I’ve just found out our Editor users can’t add new options to – either directly in the table, or through an interface list/record view.We are on a Team/Pro plan so I can edit the field permissions, which I’ve set to Editors and up and it still doesn’t work.As I am the Owner, I assumed anyone could add new options to this field because I always thought the common issue was trying to stop users from doing that! I really am racking my brain because it feels so simple but I can’t test it without sitting next to an Editor, and also wild that I can’t find others in the community with a similar issue.

I’m trying to make a button in my interface that will update a date field to today, but it looks like buttons can only update fields to be a specific, pre-determined date. I wish the function was there to add relative dates like today, yesterday, a week from now, etc.

So, I used gallery views in order to bulk upload media while creating multiple cards, super handful… But this feature seems to be gone now?! 😓 It looks like it’s updated, but once I drag files into the view, it kinda crashes…Any one going thru this? Any solution known?

what’s wrong with you Airtable, :confused: why aren’t you listening to us, we’ve been asking you for a dark mode for a long time, almost everyone has a dark mode, why don’t you, help us keep our eyesight for longer, please Airtable, it’s time to. DarckMode. App to Mac

I am an admin of my company. My company works primarily within interfaces, but I would like to invite one of my colleagues to access the base data itself. How do I do this?

I have a simple automation that checks once a day whether a list of records in table A can be linked to a synced table - table B. It first finds all the records that have no links. Then it loops through the list and tries to add a concatenation field to my linked field. If there is a record in my synced table that matches my concatenation field, then it links to that record. If not, I assumed nothing would happen, and it’ll wait until the next day to try again. However, it sends me emails every day with an error saying, “Updating the record failed due to insufficient permissions.”I assume this is because it thinks that the ones without any matching records it should create a record in my synced table, which it obviously can’t do.Is there a way around this so it does not throw an error if there is nothing to link to?Some matched, some did not, though if one does not match it, see it as an error 

Hello, I have created a Google sheet -Airtable integration through Make. Althought the scenario is successful and the data is fetched correctly, the results do not appear on Airtable. I have run it before and had worked.Can you please help me on what might be wrong?Thank you

Have asked Google, the Duck, even Bing, and can’t find an answer to this question: How much wood would a woodchuck… No, sorry, that’s a different question for a different time. My current question is: How much text can be stored in a Long Text field (of a single record)?

I don't believe there is this functionality but can gmail SEND email to an Airtable Base?  (like forwarding an email to airtable)

Does anyone know a way to save Outlook emails for future reference? Something where you just click and drag the email in to Airtable and open it in Outlook when you click on it. I guess you can drag it in as an attachment but it won’t then you have to download it to again it instead of it just going straight to Outlook and opening it up. Anyone know the best way to store emails on Airtable?

I’m working with a list layout interface. I’ve toggled the option on for users to filter, but the dropdown is not offering me all fields, only a (unknown what) selection. (Sorry for huge images, I still can’t figure out how to resize.) The field I’m looking for is called © Email. It’s a single line text field and it is the primary field in table. Instead I can only some other fields with email in the name. Is this an Airtable limitation or am I don’t something wrong? I can’t find documentation on it. Thanks. 

I am hoping someone can help me with this! I have tried and tried to find a solution, but I’m having trouble. Currently, records are named using a PDF filename that is synced from a Google Drive folder. (ie -- 123456789.pdf) The number of digits before in the PDF range from 4 to 9 digits. Currently, the record name becomes G-123456789 in our table.However, we have a new naming convention for our documents. So, I need to pull only PART of the filename to name the record. The new naming convention looks like this:123456789 North Smith 04-03-2025.pdfI need it to pull just the first number (123456789) to use to name the record in Airtable. I hope that makes sense, and I hope someone can help! Thank you!

hi im really struggling with something that i think should be easy but is very challenging to get right. I’ve been tinkering with scripts, automations and apps now to basically just manage one field in one of my tables. I am creating a scope of work configurator that has a list of components in one table and in another table i want to create records for each distinct project that I create. What i would like to happen is to have a checkbox in the components table and then run a script to fire at my command, to then have a chosen record in the projects table to link to all checked records and then pull in the data it has to run a simple calculation/formula on to get a result that totals an estimate for the amount of hours it would take to complete all the checked items. I need each project to be distinct so i can continue to update its unique record based on what’s checked in my script/app without having to create new tables or new bases for each distinct project. I can make the calculat

I am looking for a way to upload csv files of data into different tables but have them linked. Is this something I will need to do manually, or through an automation?I have one table Companies and the other table with Employees. I need the employees linked to the companies table but I am unsure the best/easiest way to do this via csv upload.Thank you for your help!

Hello, Our office has an Intranet using Microsoft Sharepoint. I am trying to embed our Airtable database onto the Sharepoint using the native “embed” web part. We have had success using this component with data from other sites. When we attenmpted to embed the Airtable we got this message: “Embedding content from this website isn’t allowed, but your admin can change this setting. They will need to add ‘airtable dot com’ to the list of sites that are allowed” Our admin followed the instructions and added ‘airtable dot com’ but we are still getting the same error. Does anyone have any advice? Thank you!

Hello,I don’t have a lot of scripting experience but feel like this one should be simple. However, I can not find my error; it’s probably something super simple and I’m just not seeing it.Here are the two simple tables I have: So in the Day table, when the Week linked field is missing, I want a script to automatically update the field. Here is my script: The error is: I know the weekID is correct because I can paste the result in the Week field and it works but unfortunately the script can not do it. Thanks in advance, I hope this is easy one!