Ask the Community

Hello everyone,I'm new to Airtable.I need to administer a standardized test consisting of several questions to several people every month.I would like to be able to record the answers so that I can follow the evolution of the answers over time and according to the people.I can create the list of questions and record the answers, but I can't create separate entities for each date on which the questionnaire is taken.Could you help?Thank you in advance for your help!

Hello,I'm new to Airtable, and have been struggling to find the best way to solve my problem.I apologize if there is a similar post for this problem, but I couldn't find any that helped me to solve mine.I'm currently designing a base with multiple tables where there is a repeated and fixed information that needs to be reflected in different tables and different tables have different purpose and calculation. Thus, I would like to know if there is a way to create a reference table where I can update the data once and have it flow to other tables as needed.To give more information about what I'm trying to accomplish, let's assume that there are 4 tables.Table 1 - Reference TableTable 2 - InvoiceTable 3 - BillingTable 4 - ReceiptIn tables 2, 3 and 4, there is a fixed amount that needs to be repeatedly reflected for different calculations called and let's assume that the field is named as 'Gross Item Price'. Instead of creating a formula field to reflect the 'Gross Item Price' of $500 (whic

Hello there,I'm starting to migrate from an old Access database to Airtable.  Part of this Access DB was used to track a number of groups and the days/times they meet per week.The data is in two tables, Groups and Meetings.  Groups is just a list of groups which has a one-to-many relationship with Meetings which is a matrix of a time-of-day and day-of-week:It shows in a report like below.  The letters in the boxes are different meeting formats:I have imported the data into AT and linked the two tables.  The issue is that all of the time-of-day and day-of-week data is getting combined into fields.  I understand that is what is supposed to happen.  Is there any way to link records and keep them separated in a one-to-many relation?Here is a link to a Base with the sample data: https://airtable.com/applQ22GX9Mh4QaAI/shraUgGlLA5zlOKoiThank you for any insight you may be able to provide!Jason

Hi, i'm a total novice and really struggling with an automation, any help greatly appreciated pls 🙂My client hosts quarterly events, attendees register via airtable form. I am familiar with creating the form and the automated email reply. But thereafter the client would like to check the existing 'Contacts' tab to see if the attendee is an existing contact:If so, do nothingIf not, create a new contact in the 'Contacts' tab.I am stuck on the find records step, I'm not sure how to ask it to check the contacts table. When I look online it says to do find records, but I'm not sure of the conditions.Thanks in advance for any help

I have a single base with a single table, that we use to track a large number of to-dos that we then assign to a handful of different users. There is a "boss" who has access to an interface that has a view that can see all of their tasks that he has assigned out (Master Interface). He will go through and leave comments from the Master Interface interface within the record, and tag the individuals so they are notified via email.We have separate interfaces so that individuals can only see the tasks assign to them, but when they are trying to open the link notifying them of their comment, it is trying to bring them to an interface they don't have access to (the Master Sheet).Can someone please help me figure out a way to use this functionality the best that will keep the following true:- Each individual can only see the items assigned to them- They will be notified of comments they are tagged in via email- Clicking the link the in the email will bring them to the correct record in an inte

Hi,I am looking for consultants to help with building a relational database in Airtable with our data. I am looking for private consultations and not courses. Please email nishanthi@redabbeylabs.com with details in addition to replying here. Thanks a lot!

Is there any setting to mess with or extension to install that allows you to have an attachment open, but not fill the entire browser? Unfortunately some of our uploaded attachments are scanned & handwritten PDF forms, but ideally I would like to be able to open the attachment easily in a side panel so I can both view the PDF and still access the grid view of the records and edit a few of the fields. For example, the PDF may have a date on it, name of who prepared the form, and a task all handwritten on it. It is uploaded to the table which creates an essentially empty record that just has an attached PDF and I need info from the PDF to fill out the rest of the record. Side by side would be ideal (some of the handwriting is beyond any type of attempt at image rec).

How can I fix this? It is a mobile made interface. On desktop I can see DATE as part of the dropdown options, on mobile I can't. On mobile even if I click the three lines icon to display more DATE is still isn't there. Any help is appreciated. Thanks

Hey Airtablers,I want my sales guys to be able to click on a button, and have it perform the following functions:- Update the 'last contacted' field- then create a linked record- then open that record into expanded view <-- This is the step I'm having issues with.I can't find a script or automation that opens records in expanded view. Right now they have to click the + in the linked record field, then click the + in the drop down menu to create the linked record. It 'works' but there's room for error and I want this to be as simple as possible for them while they're on the phone. This is what that looks like:Any ideas would be greatly appreciated!Paul

Hey guys,I would like to display a URL preview of a Figma board on my interface.I have stored this Figma board in a URL field in the data area. I can display this URL as a PREVIEW in the data/base area via extensions.Now I would like to do this myself on the interface so that the employees can see it there directly.Is there a way to do this?

Hi,I have successfully set up automated emails via Gmail on Airtable.  Everything runs perfectly except that I can't work out how to change my sender name.The screenshot below shows the problem, it needs to be capitalised and include my surname.Just to reiterate, this is when sending via Gmail not from Airtable's own service.Many thanks in advance!  

We are using a Page designer extension in our base and now we are moving towards interface. In the page designer document we have designed in a way that all the columns in a record are set in a proper manner so at the end we can save a pdf.Now moving to Interface, is there any option where we can provide direct download/print option instead of going to the base and downloading from extension?

I got a MAKE scenario that reads AT. It runs fine.I copied the table and the scenario now does not run (even with no changes whatsoever to the table). All I've done is point the AT module to the copied table.The message I get in Make is: The operation failed with an error. [422] FAILED_STATE_CHECKI reached out to Make support, and they couldn't find anything wrong. Said the error is on the AT side.Here is the RAW log you can share with them: {    "response": {        "status": 422,        "headers": {            "date": "Fri, 20 Oct 2023 06:31:56 GMT",            "content-type": "application/json; charset=utf-8",            "content-length": "39",            "connection": "close",            "set-cookie": [                "AWSALB=+U/EsIQfxd

 Hello Airtable Community,I’m seeking advice on dynamically generating a table in Google Docs based on data from Airtable, using Make (formerly Integromat) for automation.Here’s the challenge:I have a fixed table structure with predefined columns (e.g., Product Name, Quantity, Price), but the rows need to be dynamically added based on the number of items in a purchase order.I’ve successfully mapped Airtable fields to a Google Docs template using Make, and it works well for a single row. However, I need the table to accommodate up to 15 entries (or more) dynamically.What I’ve tried so far:Using Make to automate the data transfer from Airtable to Google Docs.Outputting a single row in the table, which works fine, but I can’t figure out how to dynamically add rows for multiple entries.Exploring the Page Designer in Airtable, but it’s limited to a single page and doesn’t meet my needs.My ideal solution would:Allow dynamic addition of rows in the Google Docs table, depending on the dat

I have many different bases which will have a table that has attachments, and then linked records to other tables within the base which then lookup the original attachments. As of yesterday and all days prior, I could open the attachment in the lookup field in the linked table directly. As of today, I can still see the preview for the attachment being looked up, but when clicking on it the cell goes blank and it won't open. My attachments are mostly PDFs but I'm seeing the same "won't load a looked up attachment" in other bases with photos and word docs as the attachment as well. Looks like it is an issue in the web interface and desktop app, possibly not in the mobile app (android) though.

My record is an account with multiple individuals and I need a way to use SendGrid to send an email to multiple recipients on that account. I’ve tried using a long form with "email1@email.com; email2@email.com;" as the Email Address Field, but it only sends to the first email. However, the email that is received does show multiple recipients in the “to” field. Is there a way around this, or is Airtable just not parsing the subsequent emails. I looked at the SendGrid API and it looks like you need to compose your JSON API call with multiple “to” recipients and so I’m assuming that SendGrid is also only parsing the first email for actual sending. Really really important for us.

Hello, I need to figure out how to display multiple select options in a cell that is contingent upon another cell. I’m making a list of corporate goals, then under corporate goals I have department goals. I want my cell to display only goals that I choose from within the department goal category. I have one column for Strategic Goals, another column for Department, and another column that I want to use to display Departmental Goals. I want to be able to search within the Department to select the goals I want displayed within the cell without it showing me every department goal. Is this doable? Please help asap! Thank you.

Hi Airtablers! I have started a self-study to record day to day activities in my home-based caregiving initiative - taking care of my 91 year old Mom. I am using the default time setting in Airtable - 1/2 hour increments - is there a way to set it to 1/4 hour increments - ie. every 15 minutes instead of every 30 minutes? Thanks!

Hi :slightly_smiling_face: I am building portfolio database for crypto trading. In my base I want to have live coin price, so I can track movement from current price and the price at which I initially invested. There are few websites that support API, but I am not sure how to use it and if that can be done. Is that possible to achieve, if yes can you please help me do it? Also, I am on Pro plan on Airtable. Thank you for your time.

I want to use different colours for column headers to differentiate between those that must be changed manually and those that will automatically be updated from automation when certain conditions are met. Is this possible?

Hello,I'm looking for a solution that would allow me to build a front-end for my Airtable bases. I've already tried several solutions but I still have the same problem: I have a lot of buttons that trigger scripts (scripting blocks).I may have missed some features or solutions that offer this, but today if I have to migrate my scripting blocks to automation (to go through Interfaces) it will take me a lot of time. Solutions like Softr and others don't seem to allow this either.If you have a way of doing this without too many complications, I'll take it, otherwise I'll roll up my sleeves 🙂Thanks in advanceKevin

I have looked at a few of the prefix scripts but cannot find one that fits the bill for us.When a new record is created, our Ref field is manually inputted as:ABC2025-01 (Enquiry identifier - always the same 3 letters, Current Year, sequential number)Occasionally, the Ref field is filled with a subnumber, usually if a project gets split into phases. This is always manually inputted, so in theory the last project could end up being ABC2025-125-01.All we are looking for (hopefully) is once a new record is made, the Ref field is automatically filled with ABC2025-02, next record ABC2025-03 etcAny help appreciated  

We have an Airtable form to submit internal orders, and it would be very helpful for our team to have a field that shows the last record number before filling in a new order. Not to create the order number – we have autonumbers set up – this is because they have to add the current PO to one of the files that gets submitted in the form itself. Right now they’re going and checking the latest order number in the normal Airtable view before submitting the form, but if they can cut that step out it would be helpful! Is there any way to add in a view-only or read-only field? I looked at trying to integrate the interfaces with forms too and that didn’t quite get what I was going for. Thank you!

When we embed forms on our site, we write the title and description on the page for brand consistency across pages. I do not need the form title to be repeated in the embed portion. AT adds the form title by default in any shared view and there seems no way to delete it. Is there a work around?

Seems to be working fine previously but now when I am making consecutive calls with remoteFetchAsync, I get `TypeError: Failed to fetch` after the 1st, 2nd or 3rd request.Is there a change in behaviour in a recent release? Code example:```for (let invoice of requests) {  let response = await remoteFetchAsync(ENDPOINT_URI, {  method: 'POST',  body: JSON.stringify({ 'invoices': [invoice] }),  headers: {    "Content-Type": "application/json",    "Accept": "application/json",  },});// Wait for 0.2 seconds before the next iterationawait sleep(200);}```