Ask the Community

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

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":

 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 sin

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"

Hi everyone! Newbie here still getting my head around Airtable. I am creating a form with 14 questions. The answer to each questions is a scale from 1-5, 1 being none of the time 5 being all of the time. When the form is complete I would like to be able to total the 14 answers for each respondent (so if someone answered 1 for each answer their total would be 14). How do I do this?! Many thanks

Hi there, I have used the following formula based on a guide, however, I would like to use standard fiscal years/quarters and this formula is not accurate somewhere. For instance, I have a date set in my table as 11/9/20 and it displays the quarter and fiscal year s Q1 FY’21 - the formula is below: IF(OR( FIND(01,DATETIME_FORMAT({Date},‘MM’)), FIND(02,DATETIME_FORMAT({Date},‘MM’)), FIND(03,DATETIME_FORMAT({Date},‘MM’))),“Q1”, IF(OR( FIND(04,DATETIME_FORMAT({Date},‘MM’)), FIND(05,DATETIME_FORMAT({Date},‘MM’)), FIND(06,DATETIME_FORMAT({Date},‘MM’))),“Q2”, IF(OR( FIND(07,DATETIME_FORMAT({Date},‘MM’)), FIND(08,DATETIME_FORMAT({Date},‘MM’)), FIND(09,DATETIME_FORMAT({Date},‘MM’))),“Q3”, IF(OR( FIND(10,DATETIME_FORMAT({Date},‘MM’)), FIND(11,DATETIME_FORMAT({Date},‘MM’)), FIND(12,DATETIME_FORMAT({Date},‘MM’))),“Q4”)))) & IF(AND(VALUE(DATETIME_FORMAT({Date},‘M’))>=6, VALUE(DATETIME

Hi everyone,I desperately need help as this formula is driving me crazy! Basically the formula works except for Jan - Feb and March 25 and shows them as Q2 24 instead of Q$ 24. This is the fiscal breakdownQ1: april24,may24, juen24 ->  Fiscal year (e.g., for May 24, Q1 FY’24)Q2: July24, August24, September24 → Fiscal Year (e.g., for July 2024, Q2 FY'24)Q3: October24, November24, December24 → Fiscal Year (e.g., for October 2024, Q3 FY'24)Q4: January25, February25, March25 → Fiscal Year (e.g., for January 2025, Q4 FY'24) Here is the formula:"Q" & ROUNDUP(  (MOD(MONTH({Month})

I am using record templates to create deliverables and tasks. I am setting due dates relative to the "current date".  For example, I want the deliverable to be due "1 day after current date". When the template runs, it adds 3 days to the current date. If the current date is 6/30/23, it will put the due date as 7/3/23 rather than 7/1/23. If I use current date alone, it puts in today's date. Does anyone know why this is happening and how to prevent it?