Ask the Community

Hi everyone.I'm helping a teacher to manage student's lessons.Let me tell the need:There are lessons that students have to assimilate.Each student is in a group.Each group has courses.During this course, teachers note progress for in lesson for students (students are following different lessons in the same course).A teacher should be able de note easily the student's progress.It should be possible to check the global progress of each lessons for students.I don't know how to do it, I tried different architecture with no success.Please, could you help me?

Hi everyone, a coworker and I are designing a new AT system to help our communications team manage content production, marketing campaigns, and individual tasks related to both content and campaigns. To solve for multiple needs and use cases, we're thinking of creating a standalone base for each one of those buckets (content, campaigns, tasks) and using two-way syncing to make sure they're all talking to each other. The issue: When our team leaders create a new campaign in base 1, they also want to create new pieces of content (stored in base 2) and assign that content to team members as part of that new campaign. They want to be able to fill all that information out in the same place. Is it possible to design an interface form (or just a form in the data layer) in base 1 that could be used to fill out both campaign info housed in base 1 *and* content info housed in base 2? And if so, could someone show me how? Thanks in advance for any help!

Hi, my interface was working fine before (like a couple of weeks ago).I created an interface where I can add a "payment" to a given "instalment".As you can see in the screenshot : allow users to create new records is activated.But in reality, I cannot... To me this is a bug... How do I report this for a (fast) fix please ? 

Hi guys, I'd like to share a section of views (these 14) is there a smooth way to do this without sharing all of them individually?I don't really want to share the whole base as there are tables with sensitive info in themAny and all help appreciated!

Hello, I am trying to set up an automation that is sending out all our Purchase orders as an email via a shared distribution list.I can link my account, but I do not have the option to choose the "send as" Example: me@test.com  is my account and I also have access to the procurement@test.com distribution list. I log into my account in the "send email via gmail" automation, but after that it is linked to my private email. I can choose the distribution list as a sender via Zapier, but I would like to cut that out. Thanks for any help and advice

Hello All,I wish to create an if formula which will return a Month Year result based on if a date falls on or between two dates.For example, if date A is on or between date X and date Y then return Month YearThink along the lines of budgeting and expenses:if Paid Date is 01/02/2024 (Date A)and because Date A is on/or between 15/01/2024 (Date X) and 14/02/2024 (Date Y) (Budget/Expense Period)Then return January 2024 (because January period is 15/01 to 14/02)

Hi Everybody! since start of the year I've noticed a change in the behaviour of one automation, that is causing me a lot of trouble.In a table I've a formula field that generates the ID necessary to link the record to another one in another table. The automation copy this formula field in the link field and the association is done. The link field as the selection limited to a specific view. Up until recent, this automation as worked very well, but now is not selecting the linked record only in the specific view, but outside of it.Sadly in the table that need to be associated, there some ID that are identical, so the association is not correct anymore. For this reason the selection on the link field on the first table was limited to a specific view, and it worked just fine, but now is not the case anymore.I know that the better solution would be to change the formula that generates the ID of the second table, so that they are unique, but this have implications on all the base, and

Hello everyon, so I have created this project management based on the template. I have got around 10 people in the group and how can I do that when each person logs into that base it will show tasks by name individually? Cuz for now you have to do it in condtions 

I’ve searched, googled and tried all the formulas I’ve found and nothing is working. I feel like I’ve spent more time working on these dang formulas than the table itself. Any help is greatly appreciated. Also, if anyone knows anywhere I can test a formula or understand what each means in the order it should be would be a huge help. I just don’t understand Airtables examples (its just words…no way of linking) which is where I think I am failing. I have a scheduled tab with dates (no times) for upcoming projects. I’d like to have a formula that shows if the date is today - the formula reads - DUE TODAY. if the date is within a week - Due next week If its due in 1 day - due tomorrow If its past due - Past due. I know its simple, but again - I loose it on the commas, parentheses and quotations. Maybe if i can figure this out with some help I can add some emojis. Thank you.

Hi everyone, I'm trying to reproduce the following Excel formulas in Airtable, which returns the third column from the "Tabella gest" table if the match is satisfied. INDEX('Tabella gest'!$B:$D;MATCH(1;('Tabella gest'!$B:$B=G2)*('Tabella gest'!$C:$C=BX2);0);3)I've two tables:- "Tabella gest", from which I have to retrieve the third column if the match is satisfied and use the columns B and C in the match, called respectively "Canale commerciale" and "Classe ABC" - "Input", which has the columns G and BX for the match function, respectively called "Tipo codice materiale" and "ABC ordinato" I don't have any idea if this is possibile and how I could do it, so I would appreciate anyone's help. 

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 not even sure if this is possible or how to go about doing this. Any ideas? Screenshot of the 📝 Tasks, timelines, and assignees table highlighting how tasks are organized by project and the status column. Screenshot of the Overview t

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, per player) which links to a round & player, and adds a scoreThen in an interface i want to se

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 & player, and adds a scoreThen in an interface i want to select

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.