Ask the Community

Hi, I love these kind of icons used in table names and fields. How can I find icons like these, especially with this style? Is there a page for icons which Airtable supports?

Vague but important product feature idea 17786It'd be great if we could get a form of breadcrumbs for naviagtion when viewing records, and their subsequent child records.ie) If I am in my record view for Projects, and click into a Task (Linked, Child Record) then into a subtask of that task, it'd be great to be able to see this reflected in a top Nav Client ABC / Project 678 / Ross' Task / Ross' Subtask 46 I know it wouldn't work for all scenarios, but it'd be SO powerful for this type of multi level App buildingRoss

Good afternoon! I’m working on gmail automation and inserting $ amount fields into the content of my message. I’m using the following formula and noticed that the trailing zero is missing for an amount: CONCATENATE(‘$’& ROUND({Daily Rental Fee},2)) Missing zero: How can I get the zero to appear?

Hi,I use a formula field to build a URL to prepopulate a Fillout form, and I send the link via an automation -> Gmail send. The formula looks like this:"https://user.fillout.com/t/random?email="{email&"&name="&name&"&id="&RECORD_ID() When sent out in a mail this becomes a clickable URL. I would however like to have as a "friendly name" clickable link instead. This I know can be done with the [Click here!](https://domain.com) syntax, but I can't figure out how to work that into the formula. Anyone know how to do this? Rgds, Björn

Hi, I have been trying to solve this, and I'm curious if there's a solution. Please see attached screenshot. I'm trying to add a contact within a form in a new interface that I built. How can I achieve this? I can't seem to have a + sign for users to add new contacts. It only gives me the option to choose existing contact. I want to add a new one from there. Any suggestions? Thanks!!!

HiI am very much new to AirTable so this may be a beginner’s question but I would appreciate the help very much. I try to describe the situation in detail below.Context: I am setting up a more efficient lead generation & reach-out tool for sales purposes, automating some manual tasks such as data scraping & email generation. We have 3 email templates that we use, depending on the product that we want to advertise, plus we send to two types of contacts - English or German speaking (i.e. up to 6 different email templates)Goal: I want to set up the process, so that once I have a Contacts table filled, I manually define for each contact which kind of email they should receive and in which language. Then those emails, based on the templates, with personalized tokens (i.e. Hello {Name}, ….) are stored in a new table “Personalized mail”. (then I will use that data to input to Make.com and send these email drafts to my Outlook draft folder).—Here how my tables set up look ideally:Table

I want to launch the first version of my product which essentially let's the practitioner connect their Google calendar, manage their availability at the backend and their clients can book the call from the available slots. Each practitioner can only see information concerning their practice aka data privacy is essential;. How can I go about building a multiuser login without adding them as collaborators? If you're an expert and can help me build this, please reply here. Happy to onboard a consultant who can help build this.

Hey all, so I am trying to create an automation to send over a slack message everytime there is a new record, but for some reason it is not showing the tagger suer properly.I have a table with all the users D05XXXXXXI tried with just the following formats @D05XXXXXX, <D05XXXXXX>, <@D05XXXXXX>.And none of the seem to work. Any ideas what may I be doing wrong in here?

Hi,Is there a way to create a download a CSV button to the interface for users to be able to export the record or list details as CSV? if it can be done, How do I do it?Thanks

I have created a ticket system and have now created an automation that should change a status after 2 days. Unfortunately it doesn't work. I have a date field that contains the date of creation and a condition that if the date is 2 days ago, the status should be changed to "2 days old".

We have a large team and many tables. Each department has their own table "queue". Obviously someone minding the SMS queue does not want to see the paid social queue first and so on. Is there a way for users to change the tab order based on their personal preferences and not be forced to use the base default tab order of all the tables?

I have a table with information about kids on a team I coach. I have a field for their birthdates and use that to calculate their age divisions. I’d like to use a calendar view to show upcoming birthdays, but the calendar view based on their birthdates doesn’t work, of course, because their birthdates aren’t in the current year. Is there a way to do this?

Is it possible to request results from the REST be sorted by the createdTime (which is returned on the payload) without needing to add a new column to the table? i.e. right now if I pass createdTime to sort, I get back an error: [Error: {\'type\': \'UNKNOWN_FIELD_NAME\', \'message\': \'Unknown field name: "createdTime"\'}]

Currently, all rich text formatting is removed in Lookup fields. It would be so helpful if rich text formatting (especially hyperlinks) is carried over into Lookup fields!Airtable, please support this function! 

Hello, I set up an automation to check a record within a certain timeframe from the job date, and if the record field was not up to date, then an email would be sent to the two people in charge of that data entry. It is basically:If the job date is 7 days from now, and the field X is showing Y, then send an email to Bob and Jim that says "enter this data". I have attached screenshots of the set up. I can't work out what I have done to make it think it must send the same email 500 times. Any help appreciated. I am new to automations

I have an automation I am trying to create to loop through days in a record.  Basically the record I get includes the start and end date of a time period.  I would like to loop through from the first day to the last day and create a day record for each date.  Something like:StartDate = 09-28-2024EndDate = 10-01-2024The loop would create dates in my Dates table for 09-28-2024, 09-29-2024, 09-30-2024, and 10-01-2024. I've figured out how to do this in a script however my current plan does not allow for script execution so I'm wondering if there's a way to do this outside of a script.  Any suggestions would be appreciated.

I chose the project management template that came with interfaces with various pages. They are very helpful and I have up to now only needed to do minor changes. However, in removing the placeholder data and starting to add my actual data it seemed to have "unlinked" the people section, where the interface is set up to pull task data for whatever user is currently accessing that page. It was showing me a random placeholder person, but I do not know how to make sure it associates a "person" record with the account accessing the base/interface.My initial thought was to just add a dropdown to filter the data based on the user chosen, but I seem to have no way to do that. Navigating the interface editor within a prebuilt template interface is unendingly frustrating and confusing, and none of the documentation seems to match what I'm seeing.Is there a way to link records to a person/account instead so this feature works properly?

Hi there,  I'm pretty new to Airtable so forgive me if the answer is straightforward. I'm trying to set up the following automation:  When an entry in table B has Field A = X and Field B = Y then update Table A, Record Z, in Field "Dernier numéro de facture" by changing its value to {Dernier numéro de facture} + 1 (so incrementing its value by 1) What should I enter in the Field highlighted in the image attached? I tried {Dernier numéro de facture} + 1 but it outputs a "Could Not parse number" error although last invoice number field is a # Number. Thanks!

Hello,I'm trying to create a "Sign Up Page" using an Airtable Form, however, it's not working like I want it to :).I have 1 Table which is the Available Time Slots, and 1 Table which is the SignUps & associated SignUp Form.The problem is that I want my Linked Record (Available Time Slots) to show up in a Grid Format on the Form (either Old Forms or Interface Forms), however, the only option I seem to have is a "+" sign that says "Add Record" that gives a Drop Down menu. Is there anyway I can customize this to display in a better format for folks signing up for a time slot?For example, a list with radio buttons? A grid with a column that has a "Sign Up" button?I'm exploring the possibility of building a SignUp app in Airtable, and using automations, record #s, and pre-filled forms to allow people to self-service their needs like cancelling a session.Ideas are welcome!TIA,ML  

I have multiple tables that deal with budgeting, and in each one I've got a similar setup. I track the total budgeted and then how much we've spent manually, then a formula determines the difference and another formula looks at that difference and determines the status of the budget. It works great 95% of the time and looks like the below.Total BudgetedTotal SpentDifferenceStatus$100,000$100,000$0Matches Budget$500,000$650,000-$150,000Over Budget$300,000$200,000$100,000Under BudgetThe problem I'm seeing is that every once in a while I will get a record where the Difference correctly shows $0, but instead of Matches Budget the formula will return Under Budget or Over Budget. I don't know what could be causing this since there's no rounding taking effect; it's all precise numbers and formatted as currency.The formula I use to determine the Difference result is {Total Budgeted}-{Total Spent} and in the screenshot below you can see three different records, all with zero amounts for the dif

Hi y'all,I'm trying to build an airtable base for a concert promoter. In one table (Current Shows), I have the shows they are working on, as well as fields for all the info attached (ex. artist, venue, show date). In another table (Ticket Links), I have a form for their ticketing team to add ticket links. I've built the form so it asks for the artist, venue, show date, and ticket link and it pulls from all existing artist and venues that the promoter works with, so none of the inputs are manually added (except the show date). I'm working on an automation that ideally says: whenever a ticket link form is submitted, find the record in the current shows where artist, venue, and show date match. Then, input the ticket link. Below are the steps I've taken. The automation runs successfully when I hit "Test automation" or "Run as configured" but fails to run on my Update Record step, giving me the error "Received invalid inputs".Trigger: When a record matches conditions:When, i

Hello there ! 🙂I'm using a dashboard type of page in a interface I'm using to onboarding new team members. I would like to combine 2 types of things in that same page of the interface : A grid view of items they have to read / review for their onboarding process (ideally, this would be editable by them without having to open a record)A calendar view of the meetings / trainings they have to attendHowever, I can't seem to find a way to have a calendar view while using the dashboard interface. Is there any workaround for this or is it just that I can't find the way to do it? I'm still kind of new to using interfaces.Thanks so much!

I insert one field from a query as a Grid in an e-mail using Automations.  This results in a single column listing the retrieved records which is what I want.  However, the column only goes about 1/3 of the way across the e-mail.  I'd like it to go all the way across but I can't find any way to set the width of the column.  Is there a direct way (via a setting) or a workaround that would make his possible?   When I try using List instead of Grid, I get too much space between lines.

HI i want to ask some questions i have a two table Product and Category, in product i have linked to another record field with the name 'Categories' and i want to filter the record in Product table with id that i have in Category table i have tried this but it's always return empty records. https://api.airtable.com/v0/<basedid>/<tableid>?filterByFormula={Categories}='recVXBZfPO530BgxK'Do you have any solutions?

Hi,I am trying to extract text and date from subject field in gmail into two seperate fields but I can not get the formula right.The subject will be in this format  "16610 6/9"16610 should be extracted as text into seperate field and 6/9 into date field (september 9)Can anyone help?/Michael