Ask the Community

Hi all, I am building a base that should help me build diets for my customer. In one of the tables, there are all the foods I can use (800+ records), each of them with nutritional data, as the nutritional tables on the foods boxes, to be clear. In another table, I would like to link records from the food table, and summarize nutritional facts from each of them. This is easy, also with multiple records linked, using the rollup field. The problem is: I would like to add a specific amount of each food (a quantity, so to speak), and calculate nutritional facts from each linked records and summarize the results. For example: I would like to add an apple to my diet, but the food table has nutritional fact for 100g of apple and I would like to add 250g of apple in the diet table. If I have to link just one record, it would be simple, I add another numeric field and use it as a multiplier for the nutr

Hi there!I have the airtable with employees' timesheets (start & end of shift, hours worked, location) and I want to automate (or by clicking something) the shift summary from a certain day (e.g. today). For example, I want to see the timesheet summary from today and see all the details there - name, start and end of the shift, hours worked, and location. How can I do it in Airtable and send it via telegram messenger or email?Thank you in advance!

Hello,I have two tables that I am trying to link together.One table is an instructor table called Instructors AY25 and the first column contains the instructor name and the other columns contain instructor information, including the catalog number for the course they are teaching.Another table is a course table called Courses AY25. The first column is a catalog number and the other columns contain course information.In the Instructor table, I have tried changing the catalog number to a linked field and linking it to the Course Table. This works and allows me to look up fields from the Course Table, but the new column that is created on the Course Table that should link back to the Instructor table is empty.Here's the instructor table catalog number:I have linked this to the course table:

Hi there, I've been trying to upgrade my Airtable account from the Free plan to the Team plan, but I keep getting an error message that says, ''We were unable to upgrade you at this time. Please refresh the page and try again. If you continue experiencing problems, please contact us.'' I have tried refreshing the page and attempting the upgrade again, but I keep encountering the same error. Here's the screenshot of the error: I have checked with my bank, and my card has the required transactions enabled, so I'm not sure what th

I'm new, so apologies for any blatant errors. I'm trying to create a SKU in the table primary field using the SWITCH function based on other fields in the table. My initial try included a lengthy list of colors (all unique) and the 5-letter results (not unique) for output, and the formula failed to even load. Removing the color section, I was able to generate the appropriate results based on the other columns. However, after struggling with the color field and failing, I reset the formula to the original (no color), and now get #ERROR!. I cleaned up and sorted the color entries to perfectly match the fields, and now get #ERROR!, which is progress, I guess, as at least the formula loaded.Next, I added a lookup field for the color code I want in this table and changed the color SWITCH section to reference the lookup field, but I still get #ERROR!. Here's my new formula:SWITCH({Product Type},"Apparel", "APP","Accessories", "ACC","Blankets

Hi, I would like to request allowing the fields to become collapsible in the detail view.This is both on the web and on the mobile all.When I click to expand the record, I get the whole view of the record and the fields expand to show all contents in the fields. While this is great, it poses issues if text in the fields is long and if there are multiple fields with long text. The same issue (even worse) is on the mobile application for Android and iOS because there it requires tons of scrolling down to get to the field I need in the record expanded detail view. What would help is adding a collapsibility to fields. I do not want to hide fields from the view but if select very long fields can be preset as collapsed, whenever I view the record, that would allow me to scroll faster and find what I need and then click to expand the collapsed field if I need. 

Hi I was wondering if anyone would kindly help. I am creating a form from a grid view I have created. One of my fields in the grid view allows me to link with a master data base and pull all required info through using added lookups. This doesn't seem to be something that forms allows or am I missing something? Thanks for any advice.

I believe this is an automation question, but would be happy to learn any solutions!We use Airtable for a CRM that has 4 tables: City, Account, People, and Activity. (Cities have Account linked to them; Accounts have People linked to them; and People have Activities linked to them).When creating new Activity records, we have "Activity Tags" that are multi-select for our different organizational programs.We have already created a lookup field in the People table to see what Activities our various People have participated in. HOWEVER, we've found that lookup fields aren't the actual solution we need, because there are times where we need to associate a Tag with a People record outside of them formally participating in a recorded Activity.So, we duplicated the same multi-select list Activity tags (i.e., the programs we offer) to the People table (and named the new field "People tags") and also to the Account table (and called them "Account"

Looking for some help regarding a formula. Here's a little context of what I am trying to do. I am working on importing my teams marketing budget plans into Airtable, and so far everything is working well. As a final step, and in order to avoid have two column with repeated numbers for Actual Variance to Budge and Planned Variance to Budget, I wanted to create a formula combining the two numbers and then group by that column (and hide it), so that it is always present but it doesn't need to be repeated. The look that I am going for is ($ x,xxx,xxx.xx | $ x,xxx,xxx.xx)I ran into the same issue that I found a lot of people here have faced. Once I use the currency values in a text formula, I automatically lose the "$" symbol and the number separators. The symbol (even with my limited knowledge) is easy to put back, but the separators were not. I found this solution in the forums. I can't take any credit for it because I simply do not understand it, but it

Hi! I'm working with a customer who needs a general warehouse control for his business. I have created the base and all works fine. Here is my problem...When merchandise enters his warehouse, it goes into his inventory. Currently, he adds 1 or 2 products manually in a form(Writes 1st item, clicks submit. Writes 2nd item, clicks submit). The issue comes when he needs to manually input 5+ items. Is there a way, a form or a template, where he can add X number of rows, click “send“ and for them to load to a page? *As a reference, the input is in an “inventory“ tab that is linked to: product tab, supplier tab, invoice tab.

Hello everyone,In an interface page I created an automation that is launched when I click on a button.The automation will allow me to duplicate a record.However, when this automation runs, I stay on the page of the record I've just duplicated.Is there any way of adding a step in the automation, or whatever, so that the new record, which is the duplicate, is displayed?Thank you for your help.Julien

It would be really useful to be able to select more than one record/element at a time in the Timeline view. It is not uncommon to want to move 10 days of bookings 'up' a day, and currently this can only be done in Gannt view (which is not available in the Interface designer - very frustrating).  

I have a rollup cell that is pulling a range of data from another sheet.  Is there a way to:1) Format these so it's easier to read : MM/DD/YY-MM/DD/YY 2) Format these so I can create a calendar view that would show these dates in a row on the calendar?Thanks!!

Hi, I am trying to automate a process whereby if a record in one table is not empty, it will automatically create a duplicate record in a different table, filling in some select fields.To be specific:I have a table called tasks. It has a URL field called "output" which typically links to a google doc:I also have a table called "Resources" which I will usually populate independently, but in the cases where there is a task connected to the resource, I want it to automatically create a new record.I was able to make it work in a test, however it only worked for the test record.How do I make it such that all records that fit the condition "not empty" will trigger the creation of a new record. The automation is already set to "on".

Hi all, I would like to create a formula field (or any other way) that takes a number field and “translates” it to a text. ex: 1053 --> One thousand and fifty three. any idea on how to achieve this?

I am a beginner and wanted to make a few custom changes through formula’s and other customisation’s. I need help with the two doubts below. Also take reference from the two photos. 1. How do I setup the “Hours” formula field such that even if its 10 mins more than a perfect hour it will round it off to 2 hrs and so on for any more amount of time.2. In the first photo, is it possible for the “End Time” to solely be a time field Instead of Date and Time.Would be really helpful I could get some solid advice on this!

Does anyone know if I can lock only ONE column in a grid/table so users can't sort just that one column?I understand I can lock all the columns, but I thought I would double-check if I could just lock just one. Thanks!I'm new to Airtable, so please forgive if I categorized this question in the wrong question.

Hello! I am trying to create a template that will do the following: Any person can "register" an event via the "Forms" link to a calendar. When the calendar moves from month to month, the previous events "drop off" the grid view, while the upcoming events remain. I wanted to know if this was possible? Thanks!

HiI think I've been overthinking this and have brain freeze.Two tables Contacts (all contacts) and Students (people who have been trained, should exist on contacts)Both tables have email address as Primary fieldContacts has a Verification field which I want to show on the Students table for each studentI just can't figure out how to link the two tables! I did the straightforward link and nothing appears to happenThanks in advanceMike

When click 'open' in an interface, why two forms are shown?Sometimes only 1 form is shown (which is what I expect), but often two same forms are shown.Anything I did wrong?Thanks!

HelloI have a typeform with 50+ questions. When I am mapping it to AirTable, I am required to map it field by field - which requires me to go into AirTable and create a header for each individual question. This seems quite cumbersome, is there a faster method that I am not figuring out? Secondly, what happens in the future if an additional question was added to typeform - I assume without it being mapped, there would be data loss. I am doing this for a client and need to ensure best practices. This process also exists in reverse where I've got the typeform extensive from the AirTable database.  Thanks in advance. 

Hi everyone! I was wondering if it's possible to recover lost data after importing bases. When I copied and imported a whole table to a new blank one, some of the data was imported, but some other was lost and I have blank fields now. Namely; the attachments (pdfs). Does anyone know if/how I can recover those at all? Thanks in advance! 

Per day, the employee works 8 hours and can be distributed in one or more projects (tasks) in this period. If he worked on only one project it would be 8 hours allocated to the project (easy), however if he worked on two projects it would be 4 hours each and so on. I need to generate a report of each person’s allocated hours by project. The challenge is that the tasks from different projects overlap for a period of days and I don’t know how to evenly subdivide those 8 hours by the amount of overlapping tasks.

Apologies in advance if this was answered elsewhere, I did try to find it.I have a lookup cell that is pulling information from another sheet.  In that other sheet, the cells all share an attribute called “Daily Flow.” I’m wondering if there’s a way for me to format this cell so that if there are duplicates, (like you see “An insect’s world” is shown multiple times), that it only lists it once?Thanks for the help!

I have been using this formula, and it works: IF({Company (from Distribution Locations) (from Invoice 2)}="Key Fresh 8890",{Cost *1 (from Products 2)}, IF({Company (from Distribution Locations) (from Invoice 2)}="Marathon 16050", {Cost *4 (from Products 3)}, IF({Company (from Distribution Locations) (from Invoice 2)}="Chevron 10255", {Cost *5 (from Products 4)},IF({Company (from Distribution Locations) (from Invoice 2)}="Chevron 3251", {Cost *2 (from Products 5)}, IF({Company (from Distribution Locations) (from Invoice 2)}="Marathon 5", {Cost *2 (from Products 5)},{Cost (from Products 2) 2}))))) Now I want to add another nested IF; however, with "and," it is not working for me. I want to include the following: if(AND({Company (from Distribution Locations) (from Invoice 2)}="Chevron 3100",{Date (from Invoice)}<"03/19/2024"), {Cost *4 (from Products 3)}, {Cost (from Products 2) 2}) When I add this last