Ask the Community

Hello, I would like to know how I can create fields that would belong and update to two tables at once.Currently I can only have one field linked to another table. For example I want my Deal table to serve as input to a Contacts table and be able to input the Name, Last Name and Phone number into this Contacts table, from the Deal tableie : When I create a new Deal occurence, I can simultaneously create a new Contact occurence related to this deal without having to change tables)Thank you for your help

I have noticed that when creating an Interface, if you chose the "Record Review" template for your interface, you can opt to show the Record Revision History on the interface (screenshot of the setting attached).I have a use case where I need to display this information on a Interface that I created from scratch. Can this be done? If yes, how?  

Hello! I've downloaded the app on my iPhone. The first thing I see is the login section. I choose my email and they would send me an email with a 1-tap link. If I open the link on my phone it's says "Sorry, this link won't work on a phone or tablet. Please, open the confirmation link on a laptop or desktop computer to finish signing up". So that's exactly what I do, I go to my laptop and click on the link and it just opens the app normally but on the laptop, the app on my phone remains without logging in, and I can't use the app.

Hi Community, this is a little brainteaser for advanced formula wizards. I am stuckHere is the situation:Up to 3 "quality checks" need to be done for some workflow. Each "quality check" has a check box fieldQC1QC2QC3Each quality check also has a single select status field "In Progress", "Review" or "Done".I want to show in a cell a quick overview of what quality check is still outstanding and if all are DONE it should show "ALL CHECKED"- If a quality check "QC A" is required AND QCA STATUS is NOT done -  it shows the letter: "A" (to signal that QC A still needs to be done)additionally to the letter A possibly shown:- If a quality check "QC B" is required AND QC B STATUS is NOT done - it shows the letter: "B"additionally to the letter A possibly shown:- If a quality check "QC C" is required AND still outstanding (not done) it shows the letter: "C"Once all REQUIRED Quality checks are marked DONE, the A, B and C (if required) should dissapear/not show anymore and instead the cel

Hi, I recently ran into several such issues where the records of the Linked field shows up empty. Here Session is linked from another table. Notice that the drop down is empty. Anyone facing such issues? 

Hello,I am using Airtable in conjunction with a web app. On my web app, I have a page for a section dashboard that shows communal information. Additionally, I have an individual dashboard, which displays information about a particular user.My problem is that I need a universal link to point users to their individual data.For example, airtable.com/{project}/individual_dataTo further explain, users on my web app can submit data via an embedded form. They can view communal data via an embedded dashboard page. However, they can not view their individual data via being signed in to Airtable. Is this possible via Airtable or an Airtable extension? I would appreciate any help that I can get. Thank you!

Hello,I'm trying to run a script from BaseA to create a new record in BaseB. The new record in BaseB has a linked field, I followed this convention to reference it: Field_Name: [{id: record_id}]. I get INVALID_RECORD_ID error, though I've double-checked it and the record id is correct. What am I doing wrong? let createRecordInBaseB = await fetch( `https://api.airtable.com/v0/${targetBaseId}/${targetTableId}`, { method: "POST", headers: { Authorization: `Bearer ${baseARecord.pat}`, "Content-Type": "application/json", }, body: JSON.stringify({ fields: { "👀 Projects": [{id: projectRecordId}], }, }), } );   

Hello everyone. I am new to the Airtable world and I have a question that I would like your help with. I have 17 number fields. They are called A, B, C, D, E ...I want to have 5 fields called max1, max2, max3, max4 and max5. Max1 field is going to be the highest value of those 17 fields. Max2 is going to be second highest value of 17 fields and so on till max5. (They don't have to be unique.)I could find the highest value with the formula MAX(A,B,C,D,...) but couldn't find any info on how to find the other max values.Example:ABCDEFGMAX1MAX2MAX301.316.8503.45.38.58.56.855.316.27.22.3004.47.26.24.4I am not even sure if it is possible to do what I'm asking. But I hope I can get some guidance.

Hi all, I'm trying to extract the first set of data in this single select field using LEFT() and then converting that into a date field. The data extracted will be in Chicago time. When I run this formula, it assumed that the date is in GMT,  and doesn't respect the SET_TIMEZONE. (note last entry where the time should be 3pm but the formula returns 10 pm central)Any ideas what I'm doing wrong here?Thanks! 

Hello, I’m trying to understand the AT API when it comes to getting the values of a linked table. For example, in Table one I have the following fields: ID Entity Name List of Part IDs In Table 2 I have the following fields: ID Part Number Part Name So when I create the URL to pull the values in Table 1, how do I “lookup” and show the Part Number and Part Name from Table 2 for each Part ID in Table 1? I’m new to Airtable, and have spent hours and hours trying to figure this out, but so far have been unsuccessful. All help will be greatly appreciated. Thanks, George

I'm trying to use either a SEARCH() or FIND() function to locate a comma within a string. Unfortunately, these seem to be broken on Airtable right now. Am I missing something? This should be pretty straightforward, right?

I am looking to send information stored in a Google Sheet as an Airtable automation (using Gmail as sender).I've attached a screengrab of the ideal format to be sent  

Is there a shortcut to switch to the next/previous table? Like Ctrl+ Page Up/Down in Excel?

Hello, I'm using the list view in interface designer for a project management tool, which is really good. However, when I am trying to use the nested hierarchy, I can't create a second and third hierarchy level. I want to stress that I am using the NESTED hierarchy, i. e. the hierarchy using a child task column.Can you please fix this bug, so that we can create more NESTED hierarchy levels? This is a basic feature in project management tools like Todoist or Clickup. Thank youRegards,Chris

Hello altogether, this is driving me crazy. I am entering some formulas in my field and while I am adding fields, they disappear. This behaviour is consistent for all the fields. What is going on? Is it because there are too many referenced fields?  

Hello everyone,We are using an Airtable base with two accounts: an administrator account and a team account. Until yesterday, everyone had access only to the “data” page, but I recently switched the team account to an interface that I created.However, we have encountered a major issue: when we modify information in a record, these changes also appear in other records. This problem seems to only be visible on the interface, not in the database itself, which leads us to believe it's a display issue. So far, it seems that this problem only affects certain records linked by the same person responsible for the record.Has anyone ever encountered this kind of situation? Please note that several people are using the interface through the same account.Thank you in advance for your help!

Hey all,Am I going crazy, or did the Overview interface page get changed and now it's all left-aligned? The bookmarks, titles, and side panel all used to be center-aligned, and there's no setting (unless I'm blind) to change it.

I am struggling to connect Airtable to PowerBI and was wondering if anyone was able to accomplish this?Here are my steps following the write-up from here: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable SupportOpen Blank Report in PowerBISelect Get Data > Blank queryFrom Home Tab click on Manage Parameters > New Parameter.Add the NameType > Select TextSuggested Value > Any ValueCurrent Value > Enter Token ID      This is done for PERSONAL_ACCESS_TOKEN, BASE_ID and TABLE_IDPlease note, TABLE_ID was taken from the URL as marked in red belowClick On Query1 as shown above, click on Advanced Editor and delete a few default lines.From the Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support, copy M Query, paste it into Query1, and select Done. At this point, I am prompted to Authenticate:On Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support page, it is suggested to use A

I have a base that has client names in a table and appointment date on another table that is linked to the specific client. I am trying to create a formula in the client table that will display the last appointment for that that client that was scheduled and another formula field that will display the next appointment date for that client. When I try to create a formula to look at the linked appointment date table from clients, it says it can't be calculated because it's not a date. Is there any way to make this work, which I am missing? Thanks in advance.

I have two tables Projects and Approvals. Projects are "approved" through an approval form that feeds entries to the Approval table. I have setup an approval form that dynamically pre-populates a record identifier in the URL from the Projects table. I have setup an automation to run when a new entry appears in Approvals table When I test the Find Records step using the dynamic Record Identifier filed from the form - the test shows me 0 results. But if I copy/paste the same record id and use the static mode - it returns 1 result correctly The automation ALSO works when it is Live - I'm just not able to use the testing function as it always returns 0 results. Any ideas please? 

I've been searching airtable forums off and on and yet I can't find a solution that clearly explains what I need to do to achieve my desired results.With the search extension, I have configured the extention to search all tables and sometimes it works fine and other times I get a spinning ball where the search never seems to conclude and fails to reverting anything, even when I search on a known preexisting record. I have tried closing and reopening my browser, closing and reopening airtable, opening airtable in a different browser. Sometimes it starts working again and sometimes nothing I do works until seemingly randomly it starts working again. Any solutions, Work arounds?PS: I have roughly 11,000 records, working via Mac OS and I truly need the global search feature to work (and suspect I might not be the only one experiencing this issue). 

Hi everyone! I'm posting to ask if there's a way to do a search within an interface page that features a list view. thanks,Megan

Hello, I am looking for fairly simple workflow: User fills a from User Receives an email with a file with their answers with some minimal formating Airtable has a page designer that has some bare bones features that are sufficient for my use case. On my action “Send email” I would love to be able to select my attachment as a “page designer PDF” form the same record. All the parts are there but I just cant see the integration between apps and actions. Am I blind? It really looks like I am missing it rather than it being missing. P.S. Formstack has an app that generates PDF into an file type fields but I can’t find a way to tiger it on new record creation…

Hi! I’m new with integromat coming from Zapier. I have one scenario (zap in Zapier) with the following workflow: Webhook > Find Airtable record >Find/create a Gdrive folder > Create a google doc from template > Update record in airtable > Upload file in gdrive using export link from google docs I’m trying to replicate the same workflow in integromat and I was able to accomplish until updating record in airtable but when it comes to uploading a file using an export link from google docs it churns out a file.html document and not a pdf file. Below are screenshots of my workflow in integromat. Looking for any guidance on how I can make this work?

Hi guys!I have a free AT plan, because I currently lost my job. At my last job I had Business plan.Currently I'm working on automatically creating PDF inside AT. I have google docs, connected with DocsAutomator, and I want to create PDF once one field is updated. I have one form for holiday request. Once employee submit it, I receive the email with the request. I can either approve or deny it (with webhooks in Make.com). Once i approve it, the record in AT is updated (in Make.com) and then I want that PDF to create itself. This was possible in my previous job, because we had paid plan.Is there any way to automate this? Maybe with some other tool that I can use and automate it make somehow? Thanks for your help!