Ask the Community

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

Hi,I was wondering if it's meant to be possible to sort the cards manually within each stack in the Kanban element in an interface. You can do it in the Kanban view but I don't seem to be able to do it in an interface.Erik

Hello.I have a cell that we input text and then in another cell that text in converted to an urlIF({LINK}=BLANK(),"","https://example.com/"&{LINK})Ex:CN-349302 -------->  https://example.com/CN-349302  But what kind of formula can I create to convert the text to an url if we put more than one "string" ?Ex:CN-234398, CN-23454I'd like to convert this to https://example.com/CN-234398, https://example.com/CN-23454   T

I need to understand one thing regarding billing per user per workspace. If I am the owner and at the same time creator/editor/everything of 3 different workspaces, am I charged as “one user” or “three users”? There are three of use in the team who will need access to many different workspaces. Will we get charged per email address (even if that user uses 4 workspaces) or per number of workspaces that user uses? I hope this is clear! :slightly_smiling_face: Thank you in advance for your help!

It's possible to "Link/Unlink Records" and "Add records through a form" on Android. But when I login to my Airtable App on the iPhone it doesnt show the X grey button on the upper right corner and the "add Record" button below. I'm using the same account to test the same interface on Android and iOS. Both have the latest version, but iOS wildly has a big difference and lacking in features on the linking / unlinking records.Screenshot from Desktop Interface Editor of what I need:Screenshot from Airtable iOS app that has the "Add payment" button and "grey X" button missing: I also saw that this user had the same problem last OCTOBER 2023 but no one responded since. 

I have a formula in the primary field of my table that combines a Date/time and the name of the brand in the appointment.  Formula I am using: DATETIME_FORMAT({Appointment Time},'MM/DD, H:MM A')&" - "&Brand results are randomly adding 2, 4 and 6 minutes to the time format, ex:04/09, 9:04 AM - Gregory(appointment time is 9:00 am in the calendar column) I'm lost, what am I not specifying that would prevent this? Thanks!

Hi, We have different bases in a single workspace that correspond to specific projects. One tab in each base is the project schedule. We would like to link all of these up in a separate ‘master-schedule’ base that can house a Gantt chart to keep track of our project pipeline. We would rather not have all the projects (dozens of tabs) in a single base. Is this possible with Airtable?