Ask the Community

I want to build a button in the Records Picker interface that public users can click on, and it pops up their email app with a specific subject. I know Airtable's HTML tag capabilities are limited but I want to embed something like this inside a button: "<a href="mailto:example@example.com?subject=Your%20Subject%20Here">Send Email</a>"Above is what it looks like to the user, but when they click on the red button, it should open up an email with the subject line pre-filled with this keyword. The goal is to have our customer service inbox to filter emails with this keyword as high priority. 

Hello Community,I want to sync all Airtable data into Power BI to create a dashboard. Is there any other way to fetch data from Airtable to Power BI besides this method?https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-queryThanks.

I'm having a really hard time with making a formula field only calculate a value if the input field is not empty, including if it's 0. For some reason Airtable seems to treat 0 and empty value that same.Here is my current formula: IF({Monthly Actual} = BLANK(),BLANK(),{Monthly Actual} - {Monthly Goal})In the attached screenshot, I want the fields with monthly actual = 0 to have a difference calculated, and I want the empty monthly actual to not have a difference calculated. The latter works, but the former doesn't. I've tried ChatGPT, Perplexity...etc. all types of AI and can't figure it out!

The Template M Query provided by Airtable at this link which integrates Airtable with Power BI, does not allow scheduling refreshes in Power BI:Instead of allowing you to schedule the refresh, Power BI shows this message warning that the "dataset includes a dynamic data source."Previously, the other Template M Query, with the past API_KEY, allowed to schedule refreshes. Therefore, I think there has to be a way to ensure scheduling with the recent personal_access_token.Has anyone had this problem as well? If so, does anyone know how to change the template to make it work?

Hello Airtable Community!I'm facing a challenge with constructing a filterByFormula and came across a similar issue discussed here: https://community.airtable.com/t5/formulas/formula-with-multiple-values/td-p/174768.I have a column named Klasse, which can contain multiple values. I want to check if my search terms ('A', 'A1', or 'A2') match any of the entries in the Klasse column. Using the method suggested in the linked discussion, I crafted the following formula:  OR(FIND('A', {Klasse}) > 0, FIND('A1', {Klasse}) > 0, FIND('A2', {

Upon pasting the data, I keep getting this error. Please suggest how to resolve it.

I want to block certain users from seeing entries within a base that are for a specific client without making a second base for that client. Is this possible?To elaborate, I would like to use ONE base as this is a hub for all company work orders that everyone needs to use, but I want to block some entries within that base that are categorized for a specific client from certain users who need to be restricted. I would like to avoid having to use multiple bases to do this as it just generates a level of complexity and jumping around that users would need to do to go about our day-to-day.

Hi community,Has anyone encountered the following issue and what may be causing it. I have a record - Unique prospects contacted in my database. The sum of all entries in this column is correct showing 18516In the designated Interface I have created a Number to illustrate it. I have now noticed this number is showing an incorrect valueI have not set any filters or exclusions. I even deleted the original Number and defined it from scratch but the output is the same. Has anyone encountered an issue as such and what did they find as a resolution. Is it something I am doing wrong 

I am building a complex workflow for a project-based business. In this workflow, if multiple customers are associated with a job, the job is duplicated for each customer (City Building 1, City Building 2). Furthermore, if multiple versions of the job are required by customer A, there might end up being City Building 1 and City Building 1.1, and then City Building 2. In the end, there will just be one job selected (ex: City Building 2). I know that comments copy over at the time a record is duplicated, but I'm wondering if there is a solution for somehow keeping all the comments for City Building together without a bunch of annoying copying and pasting. Sometimes there are addendums etc, in addition to the multiple versions of a job. Basically, I'm trying to preserve the historical record inside the record (rather than in email threads). I also don't want to just use a notes field because then users cannot @ each other...Is there another out-of-the-box solutio

I am attempting to use a form to update a record in the existing table.So an account executive fills out a form with the new terms and rate amounts for 2025 2026 and 2027I tried coping a workflow shared by a community member (https://community.airtable.com/t5/other-questions/updating-existing-records-problem/td-p/187594) where they made a new table from the form and then updated the old table but that isn't working for me.  I think it was from Consultant @ The Time Saving CoBefore that I was bypassing the second table and that did not work either. Does anyone have a workflow similar to what I'm looking for they could share a screen shot of:Here is how far I got:  

I have a table of books with the following columnsBook Titleyear publishedAmazon LinkBookshop.org LinkI want to create a field that returns Book Title (Year Published) Amazon Bookshop, where the "Amazon" is linked abd "Bookshop.org" is linked.Is it possible to use a formula to return text with links? I tried creating columns for buttons, but when I include the button in the formula, the output is just the URL. For each author, I want to roll up a list of their books with the corresponding links. 

Hi there. I'm trying to create a formula that returns a numerical value (price) based on a dropdown field. So, if "Option Zebra" is selected in the dropdown, the formula returns a value of 250. If "Option Lion", then the formula returns a value of 300, etc. Would some amazing wizkid be able to help me with that?

I've been tasked to create an interface that serves as a self-help page for people who encounter common tech issues. I also want them to be able to rate whether the solution helped them, but seems when using record interface won't allow a public user to interact with the rating element even after making it editable. Everything else is working except this component. Is there a workaround for this? 

HelloSorry about the title. Actually, I don't really know how to ask it correctly.Basically, I want the circled value to be the sum of the above 'Max' values. In this case, I expect 500 + 100 = 600.Is there any alternative to achieve that since I cannot switch the function to SUM; otherwise, the MAX would be lost...I goal is to show that sum "600" somewhere. Thanks

Hi Community,I have created a form to let user fill in the fields. After some time I notice that there are some errors. The errors come from user..1. Miss out an alphabet or a number of a SKU2. Key in the wrong the wrong word.3. Select the wrong dateI'm trying to find some ways to validate the input.Is there anything that allows me to prompt user:1. Prompt user to key the field when he/she forgot.2. Remind the user set the date at X days after the initial date, if the user instead set it at any other days.Thank you!

I'm looking to create a leaderboard that's linked to a form customers can submit whenever they complete some action. Each logged action gets counted as 1 point, and moves the individual up or down the leaderboard. So I guess this has two components: A form and a leaderboard that updates in real-time based on how many actions each individual has logged. Any ideas for how I can accomplish this in Airtable?I'm also a bit stuck on this: When someone fills out the form to log an action, how can I make sure each submission is linked to their specific record in our leaderboard (rather than it creating a new record each time they submit)? 

I have created an airtable base to see what steps different organizations need to take. I have a list of all of the steps in one table. And a list of all organizations in another. I have a linked column connecting the two to show what steps each organization has taken. I am trying to make it so I can easily see the steps that an individual organization has NOT taken yet/ what they still need to do (They all have to do all of the steps). I don't necessarily care how it is done as long as I don't have to do it manually and can easily see what steps have not been taken by each organization.For example, I want Organization 2 to say that it still needs to do steps 15, 19, and 20 (the steps do not have to be done in order for the most part).Images and an example base are attached for a better understanding of what I am trying to get at. Link: 

Refresh Token logic intermittently failsWe're experiencing intermittent issues with the OAuth refresh token flow. While our initial token fetch consistently works (200 response from `/oauth2/v1/token`), some users encounter a 400 error during token refresh with:{"error": "invalid_grant","error_description": "Invalid token."}The peculiar aspect is that this only affects some users while working perfectly for others. The initial token exchange works flawlessly in all cases.I've compared our implementation with the official Airtable example repo and can't seem to find any breaking differences.Has anyone encountered similar issues or can suggest specific areas to investigate? We're particularly interested in understanding what could cause this intermittent behavior.Technical details of our implementation are available if needed.def refresh_airtable_toke

Using Zapier, I am trying to lookup the “full name” field of a linked record by using the record id of that linked record. The record ID is the relevant record is returned by Zapier - so I should be home and hosed, right? However, This post seems to suggest that I cannot serach by record id unless I first define a “record id” field in my linked table (using the formula RECORD_ID()). UPDATE This works RECORD_ID()="<TriggerValue>(Step 1: Record Id)<TriggerValue>"

I would like to have 3 tabs for each page in my interface. I want Tab 1 to display fields A-M, Tab 2 to display fields N-Z, and Tab 3 to be "All collections" and display fields A-Z. Every time that I try to change the fields that are being displayed in the tab, it also applies those same changes to the other tabs.How do I display different fields for each tab in the same interface page?

How do I allow users to search / sort / group within the list view in Interfaces?If I first start with the List view using the Wizard, it doesn't allow give me an option to add levels. The only way I can do this is to start with a blank interface, then select List as an element to add.BUT when I do that, I don't have any options for users to search / sort / group.Am I missing something here? Why are there two different sets of options depending on how I select the List view?First screenshot from List Interface through wizard (no levels option), and second screen shot from adding List as an element on Blank template (no sort option).One additional frustrating thing is that the only way I see to add fields from a specific saved view is to use the List option from a blank template.

Owner asked for a place to view all marketing assets. Mainly graphics at the moment. I added fields for ratings and feedback notes. Is it possible to display assets in my interface while also allowing him to adjust ratings and add notes? Otherwise it seems creating and giving him access to a gallery view is the best approach to gather his feedback.

The documentation seems to indicate that you can set a default value for one or more hidden fields in the Form Builder. This does not seem to work, at least for linked records."Default value - In most fields, you can insert a default value that the form submitter will have to manually adjust, otherwise the default value that is set here will return that value with each form submission. This can be especially useful when hiding the field from submitters such as a hidden status field. The formatting of the default value that you enter will depend on the field type." (emphasis added)I want to use this feature to create multiple unique forms from the same "registration" table for different events - the external client completes a record via the "Event A form" and the new record automatically specifies it is for "Event A" within a link

Hi Everyone.I am trying to create a two way sync with automations and running into a few issues. Here is the overall scenario:Table 1 is named "Jobs".  It has a long text field called "Job Notes". Table 2 is named "Action Items" and it also has a long text field named "Job Notes". I want the following to happen: Whenever someone updates the "Job Notes" in either the "Jobs" table OR the "Action Items" table I want it to be synced both ways so no matter if what table you are working on, the notes are the same within a moment of changing either side. I did the following that seemed to work until we tested it in real time and the dual syncing at the same time was creating alot of issues for my team who use these two tables. As they corrected typos / etc. it would erase some of the last parts of their sentences due to the syncing overiding eachother (at least that's how I undertood what was happening). On the Action Items table I made a linke

Why, oh why, do I not have control of how I order elements on a Dashboard interface? I want to put a list view first, at the top of the interface. There seems to be no way to do that. The first option to add is a count, then I can add bar graphs and pie charts, etc, and then lists and pivot tables have to go at the bottom. A list or pivot table can't be dragged to the top, nor the pie and bar graphs dragged below. This is a huge pain and I do not understand why there is no option to arrange elements the way I want them, the way they make the most sense. Am I missing something here? Doing something wrong?