Ask the Community

Hi friends,I built a pretty robust Interface app for 4 types of users. I applied permissions so the Interface shows only records that are relevant to the current logged in user only. However, I can't get rid of the option for the users to view the Base data (they have the "View Data" option when clicking on the upper left icon in the Interface suite.This jeopardizes my whole Interface app, as users being able to see other users data is a business show stopper.Please advise!

We have an integration with airtable that leverages oauth. In some cases we have been seeing intermittent failures when trying to get a refresh token for the same user, without auth edits. The refresh flow will work but then in some cases will return an `invalid_grant` error with the description `Invalid token`.What are the reasons this might be happening, and why would it work for the same user/auth and sporadically break?

Hello! I want to add something to the formula below. I want to add the condition that IF the column 'Fixed exchange rate' is not empty (there is a number filled in) THAN that number should be used BEFORE using the Forecasted exchange rate. IF the Column 'Fixed exchange rate' is EMPTY, than use forecasted exchange rate. Current Formula: IF(AND(   {(Hide) Weighted Historical Exchange Rate ⚙}=0, {Bankbook historical exchange rate}=0),{Forecast exchange rate ⚙},IF(AND({(Hide) Weighted Historical Exchange Rate ⚙}=0, {Bankbook historical exchange rate}>0),{Bankbook historical exchange rate},{(Hide) Weighted Historical Exchange Rate ⚙})) Thank you!

Is it possible to limit the filter option (tags) in one field based in the results of a filter set on another field?Example: I've created a view and shared the link. The user comes to my view and wants to filter the results displayed. Assume user wants to filter on two different fields (both of which have 10 values/tags each).User selects 1 filter out of the 10 options available in Field 1.User then goes to select a filter from Field 2. Is it possible to have the options available to select in Field 2 limited to just those that remain associated with the results of the Field 1 filter rather than showing all 10 of the Field 2 options. Let's say only 3 of the 10 Field 2 options are associated with the items in the result of the first filter. Can the filter selection view simply show those 3 or does it have to show all 10 even though 7 of them would result in an empty result set? Thanks!

Hello! I have 2 tables in my database:'Employee Directory' with fields: Name, Seniority, Department, and Email.'Equipment Requests' with fields: Request, Employee (linked), Department (lookup), Email (lookup), and Status.I would like to create an automation where, upon the creation of a request (trigger), an email is sent (action) to the manager of the same department where the employee works.After setting up the trigger ('when a record is created'), I attempted to configure an action ('find records') that operates on the 'Employee Directory' table, finding records based on a condition. The condition should be 'where Department is' some dynamic condition. However, I am unable to select a dynamic item for the Department; it appears grayed out and states "Cannot assign list of string to string".Could you please assist me with this issue?

Hi!I'm trying to remove whitespace on the sides of a full-screen expanded view of a record in my interface to make the expanded view of a record more condensed - is there any possible way to do this? I think it was a possibility in the old interface designer but I haven't figured out an intuitive way to do it in this one.

Very new user here.I have a simple base with one table and one form.  It is designed to add new people to a mailing list.  I created a form to add new records, and that seems to work fine.  Now I need to create a navigation.  I would like to see a sidebar which includes 2 items, the table and the form.  Is it possible to have the table and the form in the same sidebar?  I don't really need to see the buttons at the top (data, automations, interfaces).How can I add the 2 items to the sidebar, then reliably cause it to appear?  While playing with this, I saw a sidebar, but once I left it, I can't figure out how to bring it back.  Can anyone help?  Thanks...

Hi All,Newcomer to Air Table here.Can someone assist and let me know if I have created a base and, in that base, I have four tables.Is it possible to share just one table from that base but allow that person to be able to edit and add to that table but at the same time not be able to see or edit or add to any of the other tables in that base?Appreciate your help in advance

I am using Airtable's "Project Tracker" template which has two tables: 📝 Tasks, timelines, and assignees and 👀 Overview.I adapted the template to my team's needs. I want to accomplish the following,I want my team to update the status column in the 📝 Tasks, timelines, and assignees table.This table is organized so your tasks are grouped by project. There will be multiple tasks per project.In the Overview table, you can see the projects.The 👀 Overview table has a status column (or field) that should automatically update to COMPLETE, when all tasks under the project in the  📝 Tasks, timelines, and assignees have a status marked to COMPLETE.

I’m pulling in 10 urls from Zapier in one field. (I can’t seem to split them despite trying the split text formatter) I have seen some similar formulas to split text but can’t get them to work either. I need some help so I can separate the URLs out.

Hi all!I have two tables, the first is Stores, the second is Customers. They are linked. Customers has a Region single select, Stores a Region multi-select. All of the Region single selects are populated for the Customers tab. I need some help creating an automation or bulk update for the regions of the linked Customers are visible in the linked Stores region field. Thanks in advance! 

Hey all, new at the community. Been using Airtbable since many years and love it. Just have been pushing it further wiht scripts, automations, and integrations. Many springs ago (25) I used to be a developer and the database thinking runs still through my blood. So when I make an base with some use case in mind (probably not wherefore Airtable is intended for) I think of tables that have the flexibility of SQL. Imagine thisBase to keep scores me playing boardgames with friends (because we're nerds and we wnat to know who is the ultimate better player over the years etc.) ps. I actually do also serious things with Airtable but this is simple for people to imagine 😄Table: players (list of people)Table: board games (the actual game, eg. UNO)Table: games (a session until someone wins)Table: rounds (all the rounds played in a game until its over)Table: scores (per round

For the automation above, I kept getting an error OR inaccurate output. When I would test it out and submit a 90% score, it keeps creating a record as if the score was less 89.99 

Hey all, new at the community. Been using Airtbable since many years and love it. Just have been pushing it further wiht scripts, automations, and integrations. Many springs ago (25) I used to be a developer and the database thinking runs still through my blood. So when I make an base with some use case in mind (probably not wherefore Airtable is intended for) I think of tables that have the flexibility of SQL. Imagine thisBase to keep scores me playing boardgames with friends (because we're nerds and we wnat to know who is the ultimate better player over the years etc.) ps. I actually do also serious things with Airtable but this is simple for people to imagine 😄Table: players (list of people)Table: board games (the actual game, eg. UNO)Table: games (a session until someone wins)Table: rounds (all the rounds played in a game until its over)Table: scores (per round, per player) which links to a round

I know we have a "Contains" operators which works, but it would be nice to have a "Starts with" operator, for example when dealing names that contains the some or more of the same letters but doesn't start with the same letters.

I have a screenshot above where the linked record displays Tags and Employee ONLY. I discovered that they normally pull the displayed fields from the primary view of the table. However, I already checked my Tasks table but I really cant find the view where this is being pulled from. It's not accurate at all. Can someone please help?

Hi, Could you please help me with a formula I have 3 values: Estimated start dateEstimated end dateEffective end dateToday's dateI want to display "in progress", if I have no value in my effective end date cell and if today is inferior than estimated end dateI've tried the following formula but it doesn't work: IF(AND(({Effective end date})=BLANK(), {Estimated end date (Deadline)} > TODAY()), "In progress")Could you help me please? Thanks,

Is it possible to identify if there are any duplicates in a lookup array? I have 3 tables, all linked together: Entities (companies)MeetingsMonthsEvery Meeting is linked to a month (for various uses) and to an Entity. From the Entities table, I have data as such - the linked meetings and a lookup of their linked months. What I'd like to do is identify if a month appears twice in any row. I don't want to eliminate duplicates (i.e. ARRAYUNIQUE). Instead I need to see if 2 or more meetings occurred in the same month for any company. Is there any way to do that? 

Hey guys, just wanted to check if the charts in the interface are showing for anyone in the iOS App?iPad App does not offer interface support currently?

Is it possible to add color to the automated email body copy. We are hoping to emphasize certain areas of content to our partners through the use of color. Thanks!

I have a field that includes:NameEmailPayment linkPayment_made (checkbox)Created at (Jan 14)Send_reminder_1 (checkbox)Send_reminder_2 (checkbox)If the payment_made is not "check" even after 3 days.I want a send_reminder_1 to be auto-check or something with a formula that will say true.-------If the payment made is not "check" even after 6 days.I want a send_reminder_2 to be auto-check or something with a formula that will say true.-------How can I do this using formula?

 [SOLVED]  Thank you for your help!UPDATE:I resolved the syntax issue.Hi Everyone! I just need help with the search filters.  TYI am getting an error message, when I run my scenario: “The operation failed with an error. [422] The formula for filtering records is invalid: Unknown field names: 321” I need help with:Airtable filter in the Search moduleI don’t know what the make.com filter syntex is for searching records. I am not a programmer, so I will need step by step instru

See an old discussion on this but nothing recent...any suggestion on best practices for copying an entire Workspace?  Built a workspace for a non-for-profit organization with multiple geographic chapters, looking for a means to give the tool we've built to others void of all data.  

HiI tried to get all the records in a table by the associated User.Im used make.com to get this information and when I entered this formula and is not working - SEARCH('user_email@example.com', {user_field_name})Does somebody know what is the correct formula? 

I'm trying to create the following automated options in a project management base:2+ days remaining1 day remainingdue today!1 day overdue2+ days overdueThis is my attempt, but I'm struggling to work out how to write the multiple IF statements required to make it happen: IF((ISERROR((ABS(DATETIME_DIFF(TODAY(), {Milestone Date},'days')) & IF((DATETIME_DIFF(TODAY(), {Milestone Date},'days'))<0," Days Overdue", " Days Lef