Ask the Community

Once I start the Airtable app on Windows 10 it fills up the entire screen. I am unable to size it smaller like I can do with a typical window by dragging the edges. How to fix this?

Bonjour, j’ai besoin d’un coup de pouce…J’ai deux champs C et P liés à une table N.J’ai besoin de vérifier si  les valeurs du champs P sont bien inclues dans le champs C. Dans ces champs les valeurs peuvent être entrées dans des ordres différents. Le résultat serait par exemple le remplissage d’un champ “TEST” renseigné automatiquement “OK” si vrai et “NON OK” si faux.Je n’y arrive pas que ce soit avec une formule ou un script. En essayant aussi les lookup et rool up. Bref je me noie… Auriez-vous une méthode claire à me donner ? Merci de votre aide.Si possible je cherche une solution sans automatisation.Chris

Needing the ability for a manager to oversee tasks while various team members do their parts as it moves through a recurring monthly process.If the manager is assigned all tasks they’re responsible for managing, it looks like they have about 240 things to do when that’s not really accurate, making it challenging for the manager to parse out their real to-do’s vs the tasks they’re responsible for but are currently being working on by someone else. If the manager is not assigned to the tasks, it’s difficult for them to monitor the progress of all tasks. Example: A manager is responsible for 60 client tasks being completed in a month, moving through a kanban board for various stages and assignees doing their part. 4 other team members have action items for all the tasks at various points. How can the manager see progress of their tasks while the action item is with someone else? Basically, the manager needs an accurate view of their actual action items/to-do list and a separate view to se

Hi! I’m trying to create an automation that is basically:If publish date is yesterday and status is not ‘published’ then the publish date updates to today.  I saw some people mentioning creating a TODAY() formula field and using that as a dynamic trigger. Questions with this:How will this field affect already existing records?  What needs to be added between the parentheses of the TODAY() formula?

Is there a non-scripting way to filter out specific filenames from an attachment field? Interface look up field displaying jackets of manuscripts. Want to show all images bar those with the filename “Placeholder.png” Had hoped for an “Only include linked records where ‘Jacket’ ‘filenames does not contain’ but missing that one.Or a formula where I can use FILTER into a second field but still display an image?Didn’t want to use scripting as want to keep as a look up  but maybe I’m missing something? Any ideas appreciated!   

Hello, I’ve recently come across Airtable as I’m researching how to create a local business directory website. This tool seems really helpful for creating databases, however I’m not sure how this can be incorporated into my site, I’m building my own website, my dev knowledge is not vast right now as I have some refreshing to do, but it’ll just be in HTML/Javascript. Is it possible to incorporate this into my site, and then modify the appearance with some CSS? If so, can anyone help provide information or point me in the direction of the help article for this?Thank you!

Hi all,I need to generate a 4 digit code from the year a record was created and how many records have come before in that year.E.g the 5th record that has been created in 2023 = 2305.I have reformatted the referral date DATETIME_FORMAT({Date of Referral},"YY") but unable to get a COUNTIF function to work to count how many referrals have been made before this one where the referral date is in the same year.

I've been trying to find out what counts towards my automation run; however, either I can't find it, or I'm constantly overlooking the something.Basically I just want to have a solid grasp on what adds towards my automation limit?Is it just counted every time an automation runs?Does steps in the automation also count?Does loops count as one or multiple runs?

I'm experiencing issues with error notifications in automations. Notifications have been disabled for all accounts, yet some accounts are still receiving them.Is there a setting that overrides the user's notification preferences in their interface?

I have my form embedded on our site, and I don’t want the title to show. Is there a way to hide it? I tried deleting the title on the form within AirTable, but it won’t let me have no title.

All,I am trying to create a simple automation that for some reason, wont work.   On my “Trips” table I have a date submitted field.  When this field is populated, I want all the corresponding expenses that are listed on the “Receipt Log” table to be updated with a submission date.  I created a view on my Trips table to show all records that have the date submitted field populated and I use that view as my trigger.  I then do a “Find Records” action that shows all the expenses that have the same “trip name” as the trips in the view.  The find records is working perfectly. I then created an Update Record action and using the Airtable Record ID from the Find Records.  But when I test this action out, it continues to fail saying “invalid input”.  I can’t figure out why. Appreciate any suggestions,Kevin

I want to add custom color to my base. But I can see the 30 colors for my plan. Is that possible to add custom colors?And one more thing is I'm unable to apply colors to the button for the interface workflow template. Is it possible to add colors to the fields and buttons?When I create a new blank interface, I can add colors to buttons and some background colors to some elements the same does not apply to the workflow template.Please guide me on this to achieve my requirements.I appreciate any help you can provide.

Hi,I’m relatively new to Airtable and I want to use it to help track inventory. I’m not familiar with coding or complex formulas and I’m thinking those are the exact things I’m going to need to pull this off…Ideally, I want a base that has a full list of inventory and user capabilities to allow checking in/out different items. I want quantity to auto-update based on in/out. The user facing side needs to be very simple and easy. Originally, I was thinking a form where the user will type in the ID and whether they're checking it in or out and it will auto update the quantity but now that I’m trying to work through that- it doesn’t seem very straightforward. A form recording every single response as a new line item is not useful in this case.Quantity number will be very important because I want a dashboard that displays what items are available and where to find them. Any guidance would be incredibly helpful- other posts, help pages, formula suggestions, general layout, literally anything

I found this post: Help creating a script to tag products with keywords from product titles.  Using the code with the adjustments the script runs, but not well.  I am hunting keywords in course descriptions for a sustainability tracking and awards system.The problem is when this searches for keywords it's too literal. If the course description has "...equal.." then it will attach that link. If the description has "...equality..." it will not. Originally the keyword list had the asterisk wildcard, which meant there was a lot of things it wasn't finding because it doesn't seem to recognize that as a wildcard, but that lack of wildcard means it's missing possible links now. I would prefer not to add every iteration of "equal" to my keywords list though.How do I address the problem I’m experiencing programmatically?

Hi Airtable Community, I’m attempting to send an email every time a new record is created. The message of the email should include the contents of every field that has data in that new record. Our fields are added to regularly, and I do not want to edit the automation every single time a new field is added to our table.  Is there already a known solution to this, that will automatically include all fields with data in the message of the email without pre-coding the specific field into the automation?  Thank you,Danny

I am having users attach photos and I would like a way to show the size of a file so that we can have an indication of the size of the file attached. Doesn’t anyone have a solution for this? Thanks in advance for your help.

So, I have some data that looks like this: 二代目 歌川広重; 1826 - September 17, 1869I want to sparate the japanese name, at left, from the dates, at right. It’s not always Japanese, but it is always seprated by a semicolon. Formula suggestions? Thanks in advance!

My table has two checkbox columns that are set to show different symbols for True. “Actively Working” column is set to show a yellow star. “Hide” is set to show a red “x”.Both of these columns are showing a mix and match of both values (see photo). It is happening in the app on both ipad and phone. Individual records opened up show the correct value in the correct column. Anyone else having this issue? How do I resolve it?

I want to put a hyperlink within a long text field called "notes" on my calendar. I can't figure out how, so any help would be great.

Hi,I have two tables - one that has projects with tasks and one that has employess. Each task field from the different projects is linked to the employee table. When I want to assign an employee to a task, I link the employee record to the task in the tasks table. This works fine.However, when I go to the employee table, I want to see a list of all the tasks assigned to each employee.How do I make it show up automatically?

I’m new and just learning Airtable. I know that other flower farmers use Airtable already, but I haven’t found many resources about how exactly their Workspace is set up. I’d love some input regarding keeping track of items such as a master crop list, year to year crops, maps, task calendars, inventory, clients, products, newsletters, vendors, etc. It doesn’t necessarily have to be flower specific as the veg community has a ton of overlap. 

Lets say I am linking a People Table and a Projects Table.In the People table I want a column that has all the Projects Associated with that specific person. In the Projects table, I already have all the projects listed along with the associated person. When I ‘Link from Another Record’ from People to Projects, nothing populates. I’ve tried the LookUp as well but nothing populates as well. 

I'm encountering an issue today with the Airtable interface. When I try to add a chart, table, etc., by clicking on the plus sign, nothing happens. Do you have any ideas about the source of the problem? I don't think I've exceeded the limit of 50 pages per interface, as I have deleted some content, yet the issue persists.

Hello everyone, I have a pretty specific question form a form I want to have connected to my site. So I want to have a contact form on my website that is kindoff a two step process. First step is the user inputs their name, number and address of the property. Once the user inputs this info and clicks get a quote, it will take them to the second part of the form where they input just a couple more details.Ideally what I want to happen is this:If the user completes the first step but upon moving to the second step decides not to complete it because of time it would take to fill out, I still would like the info that he submitted in the first step to be submitted to airtable. Is it possible to do this? 

Hi everyone, I have a problem with Lock view. I have a view that I lock so that other people can’t modify/change my data listed there. but when i try to share this view. the toolbar for fields, group, sort, etc is not locked and the person that is using the shared URL can use it.Is this a bug or thats just the way it is?if yes, then is there a workaround for this?thank you in advance