Solved

Hello,We are using the “Phone SlackID” field in Airtable and passing its value into the body of a message using the “Slack Send a message” action in an Automation to send mentions.In the “Phone SlackID” field, we’ve set each user’s display name in the format @last.first, and it has been working correctly for almost all users.However, after one staff member changed their display name, they no longer receive mentions. Specifically, @last.first now appears as plain text.Could you please advise us on how to resolve this issue?

I have a date time difference formula formatted to decimal with 2 places but not returning any values less that one. My formula is as follows: DATETIME_DIFF({End Time},{Start Time},'hours')What am I missing? If I recall correctly this should be able to return hours less than 1 (e.g. 0.5 for half an hour difference)

Here’s the problem in a short loom. Maybe I need to have the event table with the name of the event as the primary field: 

Hi! Do you know if it’s possible to add the text generated for an AI field to an email automation? Everything seems fine in the other fields but not in the AI generarted. I tried copying it with a formula but it is not working.   

AirTable is not allowing me to upload my CSV file. I click on the + sign, select “CSV file” under “Add from other sources”. I drag in my CSV file under the “Local Files” section and click “Upload 1 file”. It seems to work, I select “Create a new table” under the “Import your file” dropdown. It shows me a beautifully created base with all the column's I’d like.  However when I click “Import” I get an error sign saying “Can’t import CSV file” with the statement “Invalid data” underneath. Does anyone know what might be going on / how I can fix this. The only option airtable gives me is to click a button saying “Okay” and I’m back to the start. 

They are in the same base.

Is there a way to export the structure of a table to csv, JSON, etc.? Specifically, I’m looking for a way to export information about a table, not the data itself. Some method that will give me an output like field 2 is long text, field 3 is lookup, field 4 is date, field 5 is single select, etc.

Anybody has tips on how to do that? I have a long text field (cca. 1000-2000 characters including spaces). Beside that another field showing keywords, usually not more than 10-15 keywords. These keywords are typed in through Google API and edited by me manually. These can be keywords (or better say key phrases) are separated by comma. These are the words (phrases) I want to make sure I have them in my long text field in sufficient number of times. I am looking for a way to calculate the keyword density, that is how often do the keywords (the words in the keyword field) appear in the long text field. I do not need to see individual count, sufficient is to have summary count - number of times any keyword appears in the long text. The density count will give me a percentage = number of total keywords(phrases) / total words in the long text I looked at this suggestion here but it seems to me Airtable database would explode if I start generating a tag (which seems to me is essentially a

I have an email automation set up so that when an attachment is added to a field, an email is triggered to a project manager with a copy of that attachment.Currently, we delete the old attachments before dropping a new one in so you do not receive multiple attachments with the email that gets triggered.Now with the new Versions feature, I want to keep the old attachments in the field but only have the latest attachment added to the email. Is there any way to limit the attachment field in the email automation to only the latest one that was added?

Hi, can someone please help with my formula? I’d like to calculate the number of days between two dates, but if the dates are the same then they should display 0. The formula below works to show the ones with the same date as 0, however it then shows the ones with different dates as being one figure too little. DATETIME_DIFF(  {Post Sale Date},  {Auction Date/Time (Local)},  'days') To fix this I added +1 to the formula, which of course, solves the latter issue but not the issue for same dates need to show 0. DATETIME_DIFF(  {Post Sale Date},  {Auction Date/Time (Local)},  'days') +1 Can someone please assist 😊

 This is an Opt-in / Reference Check form:https://airtable.com/appDms8x0QIhxU2F5/pagg3esZJjn6ytUSK/form For some reason, its no longer clickable.. you can’t type on any field. I already made a dupe and its still the same. I tried to revert to yesterday’s version and the old form worked. But Im trying to find out the difference on the settings and visibility, there’s no difference. Im just confused.. another problem is that we sent out this form to plenty of people already that doesnt work.. Can anyone help me please?

I'm working with a database structure that has three tables: Publications, Artworks, and Individuals. I'm running into an issue with a Rollup field and hoping someone can help me find a solution.My Table Structure:Artworks table: Has a field that references one or more Individuals Publications table: Has a field that references one or more Artworks Publications table: I want to create a Rollup field that shows all Individuals associated with the Artworks in each PublicationThe Problem:When I use a Rollup field with an ARRAYUNIQUE() formula to get the individuals associated with the artworks, I'm getting unexpected results.For example, if a Publication contains 10 Artworks, and each Artwork has 1, 2, or 3 associated Individuals (sometimes different ones), the Rollup field returns each combination of individuals rather than each individual individually.What I Want:I want the Rollup to return each unique Individual associated with any of the Artworks in the Publication, not the combinatio

I am trying to access Omni but the icon does not appear in the upper left corner of any of my bases. I am on a Business plan with 20,000 AI Tokens per month available. What should I do?

Hi! Does anyone know a trick about how to get the email of a user, that filled a form with a “Restrict access to an email domain” activated? When this feature is on, the user must sign up and login into AirTable to fill the form. If the user’s email domain belongs to the one accepted at the form settings, then he can view the form, fill and submit it. So my question is: since the user have just signed up and login, is there a way we can save the email address used, inside the created record? Thank community!

When using a form, I want to offer specific choices for students to choose from, but I also want to offer them to option to fill in some option that we haven’t thought of. (As in, “how did you hear about us? Internet search, friend, Facebook, other- tell us how”) Thanks Linda

Is this scenario possible?I want to automate a task on my team in which a team member would create a record and attach a word doc to it. The team member would then fill out a form which allows them to attach the record they just made (or any record via the dropdown that lists all team member-made records). Once they submit the form, it triggers an automation to send a pre-determined Teams message with the record chosen from the form. I successfully created an automation to make part of this happen, but i can’t get it to attach the record (because the message is static and the attachment is dynamic?) Is there a way to make this work??

Hello all,So I have been uploading attachments to a field through a google share link and have made sure to make the file and folder public but for some reason when i click on the attachment it just comes up as a blank screen and says loading but never loads. The share link is fine as when I put it in the url bar it works perfectly. Im unsure what is causing this??

Does anyone know the names of the colors in Airtable? Thank you.

Trying to figure out how to have the Interface “Button” When clicked it will go to the form I built? Do I use external URL?

Hey folks, I’m trying to figure something out.I’ve got an old CSV doc that I’ve integrated. Unfortunately, it’s a mess and I’m only a “enough to get by” kind of Airtable coder. I’m a bit stumped.So, I’m trying to make a formula that combines multiple cells to make a condensed long text field for mailing addresses (if possible). Unfortunately, many of these individual cells are empty and there are 562 lines of them. There’s no good rhyme or reason as to what is empty, either. Sometimes it’s address 1 and address 2, sometimes there’s a city and state and nothing else, sometimes all of the information is filled out, so making a straight hierarchal system like I’m more used to seeing doesn’t really work.Example:IF(address 1, <all the info>,   (IF(address 2, <address 2 down>,    (IF(address 3, <address 3  down>,)))Here’s my best effort at what I want to do:Any advice? Thanks in advance!

I’ve been playing with Omni.  I asked it to merge two multi-select columns.  It created an AI field, which didn’t solve my needs.  I asked it to undo and it could not.  I can’t find one of the merge fields. I’m pretty sure I didn’t delete it.  Which makes me think Omni is not super safe in terms of preventing data loss.Maybe I am imagining things.  Has anyone else accidentally blown away data while using?Thanks!

I have been trying to help my son (13) start up his lawn care business.  I'm familiar with, and use airtable regularly for some small tracking.  I love its accessibility, range, and adaptability.  Thought it would be a good fit.  Created an easy to use base with services available (with fees) table, service provided and dates table, and client table.  Then created an invoice table that he can simply add the services provided to certain customers from the "services provided" table.  Works flawlessly.  He has grown the business and uses written invoicing.  Tried to help him save a step by automating the invoice so he could send it as a text to the clients each month.  Page designer creates the invoice.  Is there a way to send the invoice created as a text or email to an email in the invoice? To sum it up, use page designer to create a document.  Send the document via text or email.  Solution needs to be simple, and low cost

I'm wondering if there is a way to restrict a date field to a range of dates. We have a base that grants people access to our website. In order to get access, they need to fill out a form saying how long they need access for, but we want to restrict it to dates that are 1 or two months from now so they don't put 2025 or something ridiculously far away. Does anyone know how I could accomplish this? Thanks!

I'm setting up an automation triggered by updating a field in one table, which updates a field on the linked record in another table. I'm using "Find records" to search the linked table based on condition that the record's name/title matches the name/title of the linked record from the source. Essentially, I'm just trying to find the record linked to the updated record.However, when selecting "Dynamic" for the condition value, the name/title field to be used is not selectable, with the pop-up message of "no valid nested values" when hovering over the field. It really seems like this should work, and this error message is cryptic and not helpful.Does anyone understand this "no valid nested values" error?Should I be grabbing linked records to be updated in a different way?

I’m building a database for products that sell on multiple marketplaces (Etsy, Creative Market, and my own website). I have one table for the products and another for the marketplaces. I have URL fields for inputting direct links to product listings (separate fields for each marketplace), and fields for linking the products to the marketplaces they’re listed on.Currently, I have to manually add both the URL and link to the related marketplace, but I’d love to create an automation that updates the marketplace link to include all marketplaces for which the URL field isn’t empty. For example, if a product has only an Etsy URL, it should only link to the Etsy marketplace record. If it has both an Etsy URL and a Creative Market URL, it should link to the marketplace records for both. I was able to successfully create an automation that linked to a single marketplace based on a single URL, but when I tried to update it so that it would also link to a second or third marketplace when addition