Ask the Community

Hello, I feel like this is relatively easy but I am stuck. I have automations set up to send out a welcome email each time a project is sold. I have spec sheets and standard documents I want to send with each email. They are standard forms that are the same for each project. I want these to automatically attach to a record when it is created. I have the forms set up as their own table. How do I get Airtable to link these forms whenever I create a new record? thank you

I am using a DATETIME_FORMAT formula to reformat a Date input field and make it pretty. For some reason no matter what time I put in to the Date input field the formula field spits out a time exactly four hours later. Anyone know why this is happening? 

Hi everyone,I am wondering if there is a workaround/solution without using make.com or scripting.I have data in one column for example. The column is a linked field.Items | Qty_to_BuyA|5A|1B|1B|1B|6C|10 I want to create a table with the following output.A | 6B|8C|10It is basically grouping by item but I want the output to show up as separate records. If possible I would like for it to be in the same base but a sync to other table also works. I would appreciate any suggestions. Thanks.

Hi All,So I have a question about the best way to merge data. I manage a scholarship program for a festival that happens once a year. We've been using airtable the last few years to manage the staff, artists, and scholarship recipients. We saw a lot of success converting our emails into Typeforms last year and want to expand on that.We use a typeform application for people to apply and then pull those who are selected into an 'Accepted' View. We intend on sending 4-5 typeforms with questions so we will need to merge their answers into each of their 'Applicant' profile. The typeform will ask for the same email address they applied with and I would use that to direct the merge. This is going to create a lot of multiple 'accounts' and I want to make sure our data stays tidy and manageable. Rundown:1. John Snow is accepted.2. We send out  Typeform 1, 2, 3, and 4 out to John3. John fills out the typeformform as he recie

Hi Airtable Community,  I have two questions regarding the interfaces.How / where can I set who can share an interface? I don’t want everyone to be able to share informations.   Can I set that certain users / user groups can only see certain pages of an interface?  Thank youBestMirko

Hello,In the photo below some of the names in the linked field are cut off. This is extremely annoying and I cannot figure how to get the entire name to show. On the desktop this is less of an issue (2nd photo) but I think it has something to do with the formula and the line break in the Pallet ID field. In the base, the pallet id and materials fields have no line breaks in the content. Does anyone know how to get rid of this annoying and inconsistent line break? Or just show the full name?Thanks in advance for any help!    

Hi thereAs in the title, the error "Cannot access this data" has started appearing on some Interface pages.I have base access and am not seeing this issue. The issue has only occurred for collaborators with Interface-only access.It's happening on Interface pages that were created as Lists and Grids.Duplicating the page with issues fixes the issue. 

Hi.I have two Date files with Time Called Start and Ende.g.:Start=08.05.2024 09:54End= 08.05.2024 12:00in another filed I'd like to calculate this into hours rounded to full 15 minutes using:IF( AND({End}, {Start}),ROUND(DATETIME_DIFF({End}, {Start}, 'm') / 15) / 4) the result of this is 2 which is correct as I used "ROUND"But I'd actually like to ROUNDUP, so the result should be 2.25But when I change ROUND to ROUNDUP in the above formula, I just get #ERROR back Further down the road I'l

id like to format my "price" field as follow : 100€ not €100How ? 

I have been using Airtable and created a column in which I have added links to Twitter, Facebook, LinkedIn, and Instagram profiles. I manually added the follower count, but I want to know if it is possible to update the follower count automatically for these social media platforms in real-time. Can you please help me with this?

Hi everyone,An interesting Restriction / Bug I've found but unsure if anyone can help?I have a basic list view that lists Tasks, with associated Subtasks as drop downs by using the 'Levels' setup.With this basic, 2 level setup I now can't Group my Tasks by Status?  Anything I add in the 'Group' option on the right (no matter where I have selected on the window) only affects the Subtasks that are nested, not the parent TaskAny ideas?Thanks!

Hi, I have researched the forum but cant find the problem to my solution. Every time a record is updated in UseCases, I calculate a field call Environment_textual (example value would be "Negligible risk").I have another table called Environment_pics where I store pictures for each rating (e.g. there is a pic for "Negligible risk"). I want to create an automation which takes Environment_textual and copies it over to the linked field, so I can the picture in the UseCases list.I get an error for the last step.Should I copy the result in the linked field in UseCases or in the linked field of Environment_p

Hey my Gmail automation appears to be set up correctly with a publicly hosted web image that should send in the body of the text. It works in the preview but when I send the email it doesn't show. Could anyone point out where I'm going wrong please? The subject and body of text pulls from my airtable and sends in the actual email, then I use (<img src="image web address">) to attach the image (This does not send). Does this need to be configured in a particular way to send via Gmail that I'm missing? Cheers! 

Can someone help me figuring out how I can copy all the options in a single select (my example has 5 options, but assume a have a sigle select with 1000 options), and paste it in another table, as a regular text field? i need this because I want to create a db with all those options, and use link record.. as this info is in many of my forms, and get updated regularly , thanks! 

Hi All,I'm having difficulty automating a task that I need for my database. Essentially what I'm trying to do is to have a default value in the "Link to Field" selection, which is then removed when another option is added. The data is currently pulled in from another table using a 'Link to Field' column, I currently have the automation working to add default option back when options are removed but having difficulty creating the script to remove the default option when a second option is added.Below is my current code, which pulls the current options from the cell and checks whether they are the same as the field being updated, which then passes those choices to an updateOptionsAsync, from which my understanding is the wrong function to be calling.Any help would be greatly appreciated!! let inputConfig = input.config();

I'm sitting with a client who needs have a massive library of materials that is put into subgroups depending on category. I thought the AI search could be a potential game changer, however they don't want to switch it on before they have an idea about cost.We've been trawling the Airtable AI and billing section, but so far haven't found where it says how much credits the search functionality takes. Does anyone know?

Hello everyone, does anyone know if it is possible to use the Gemini API Generative Language to create an automation in Airtable? I would like to use 1 column to receive data input from my users app and serve as a kind of prompt. And then use 2 more columns for output with AI responses.Additional notes:

Hello all!  I need some help please.  I can work spreadsheets all day long but database creations is not my forte, far from it.  I started using AT a few years ago to track my business whole goods by serial number.  Thankfully, someone helped me here and re-designed the mess I had created.  It has been working great so far, but I would like to change the way I enter the data.Currently, I just use a main grid and enter all the information, it then populates to combine all the same parts together.  From there I have managed (with some help) to create 3 other tables, one for each manufacturer so I know what is in stock. The reason I want to change the design is I am much more busier with the business transactions and I'd like to reduce the redundancy that I find the current design has.  When I set this up, it was basic and understandable to me. The main table currently has model, brand, part #, serial no., accessory, ven

Hi, I wanted to provide a link to a separate site in the help text of a specific form field. Is there a way I can add links to that or is it all just plain text?

Hi everyone, I'm building a personell planning Module where you have your Project and you can assign workers to the project for certain time periods. The basic Idea/Tables behind is: 1. Projects: All info about the project. Start & end Date coming from "timeslots"2. Timeslots: Can be either a project or work term. Work terms are linked to projects. I then set up a timeline view and see my project and am able to plan out work terms beneath it (grouped by project, sub grouped by type). This is all nice and well. However there is one fundamental Problem: If I group by Project, sorting by date suddently does not have any effect anymore. Ideally I want to have the current projects at the top and the further down i go, the further they are in the future. But like this I have lots of projects inbetween that only start sometime in the future. Is there any way I can so

Any tips on how to make React DevTools work when developing locally?

Probably a niche use case but wondering anyone can think of a way to make this happen.I'm trying to use airtable to organize some wire and cable take-off quantities and routing for a large scale construction project. The main entities (tables) are wire/cable, conduit, and pull/junction boxes. The boxes are like the nodes, the conduit link nodes together, and the wire runs through the conduit and boxes from an origin box to a terminal box. There may be many levels of branching. Possible that there is some spider-webbing as opposed to just straight branching but not positive yet (rare if so).I have the table setup so that there is a record of conduits, with an "origin" and "destination field each linking to the table of pullboxes. This link defines the end points, or nodes, of the conduit IE Conduit #1 goes from Pullbox A to Pullbox B. Conduit #2 goes from Pullbox A to Pullbox C, Conduit #3 goes from Pullbox B to Pullbox D, Conduit #4 goes from Pullbox D to Pullbox E, et

Hi all, I have the following issue:I have 3 different Interfaces: WorkTeamProduct RelatedEach with multiple Views. The "Team" Interface is more like team internal.So I want to share the "Work" and "Product Related" Interface with most of the company via a link. However, as soon as I select more than one Interface, the "Invite by link" option is gone. Is there a way to do it? A colleague with the free plan mentioned that he is able to share multiple Interfaces at the same time. We didn't figure out what is different though. Would be little bit annoying/confusing if everything has to click on 2 links. Single Interface selected: Multiple selected: 

Hi,I want to automate my work with emails to clients every 3 monthes.the problem is my languge is RTL (right to left).how can I send the clients emails that are RTL?with HTML it doesn't work since the variables doesn't work in HTML.

I have a CSV file delivered weekly with information about grant opportunities. I've been importing this file into Airtable, however, many of these grants include multiple submission deadlines throughout the year so I'm struggling to find the best way to be able to use the submission deadline as a true date field for sortability.The CSV file has a text-formatted column for dates. The cells also include "Submission: " before each date. I was planning on find/replacing out the "Submission: " text and then formatting the text as a date, but some of these cells actually contain multiple entries. For example:GrantDeadlineGrant 1Submission: November 15, 2024Grant 2Submission: September 01, 2024Submission: March 01, 2025Grant 3