Ask the Community

Hello everyone!I'm new to AirTable but I have 20+ years of experience with SQL, but I'm stuck with the interface design here.I'm helping a friend setting up a project to keep track of orders and AirTable seems to be the perfect place.I have created a "product" table, an "order" table and a junction table "order_product" for the many-to-many relationship between them.Now I need to create a form or an interface to execute the following process:I need a page where I can choose the client for the order and add multiple products with quantityWhen the form is submitted it has to create a new record for the orderWhen the form is submitted it has to create a new record for each product in the order (linking the new order that has been created)Any idea on how to do that? Thank you so much in advance and greetings from Italy! 

Hey folks, just wanted to share that we created this pipeline which is free to use.It has schema inference and evolution, so the column names and data types will automatically be normalised to fit the destination and also adapt to any additions etc.you can configure it to load fully or incrementally.If you have feedback, please join our slack and discuss there or open a git issue. Pipeline docs: https://dlthub.com/docs/dlt-ecosystem/verified-sources/airtableour slack: https://join.slack.com/t/dlthub-community/shared_invite/zt-1slox199h-HAE7EQoXmstkP_bTqal65g

Greetings to all,I'm looking for an efficient solution to a problem concerning the organization of my to-do list for different events during the year.We've drawn up a list of tasks (110) to be repeated at each event.I'm facing 2 issues:1 - When I create a list view, I link the tasks with the event; the task remains a single record, so if I validate a task for an event, the task will be validated for ALL events. It doesn't matter what the hierarchy of my list is (or did I misunderstand?).2 - In a previous version with 89 tasks, I was able to get around this issue with record templates. When we decided to take part in an event, the 89 records were created, and then I pressed a button to launch several automations linking the new records to the congress. Not the most refined method, but it worked very well. Problem: record templates are limited to 100 records per base.I'd like to avoid recreating a table for each event to keep a clean

Hi, im trying to create an automation that will move data from a field with a formula to another tab whenever a trigger is activated, but for some reason, i get this error - “Fields” could not be converted to a string. can somebody help solve the mystery? Thanks, Liran

I have an Airtable form link but I'm not sure what base it's attached to. Is there a way to find the attached base without going through every single base and table in my workspace?

I am trying to create a field that tells me is a date field, called Purchase Date, is before a specific date, 04/09/2023 (did/mm/yyyy, same format as the date field). This is my formula so far, but it returns a “0” (ie false) on all records so many what date I enter between the “ “ in the formula. IS_BEFORE({Start Date}, "04/09/2023")How do I fix this? Thanks!

Looking for a way to use Conditions to view something like this: Where Lookup Field  matches Linked Field I want to show all the date/times from a lookup field that corolate with the same employee who completed a form. Hopefully, the screenshot below helps explain it better?  

Hi, does anyone have any ideas on how to write a formula to mark a previous date for each person?

I am looking for a way to split expenses amongst people in our company without duplicating the total. We purchase company merch/promo items and that expense goes under our expense table and is assigned to 1 of our 7 offices, or corporate. We assign all promo expenses to "corporate". We then have an Inventory and an orders table. I add the inventory in as we buy more and add that to our expenses. Then, as the items are distributed to employees and partners those go under the orders table. The issue is the full expense amount remains under "corporate" instead of splitting it amongst the employees (who are assigned to a branch in the employees table) based on what is distributed to them in the orders table.

Good day to allI am looking for some help for my problem after spending all morning on it. My table is an 'audit table' for blood tests. I have a colum that is a linked field to another table that allows me to select the blood test requested (Samples requested). With each Sample there is an associated turnaround time from the lab. I have set this up as a single select and it is either 24hrs, 48hrs, 72hrs or 5 Days. To view these TAT, I have a colum with 'expected TAT' and this is a lookup field. However, when I select several Samples, I can have several TAT. I only want to see the longest TAT ie if I had 24hrs, 24hrs, 48hrs - I would only see 48hrs. I have tried several different formulas and scripting and not wining at all. Any help is appreciated.

I have a Customers form and I want them to be able to add their pets. When I click +Add under Pets, I just get a list of currently entered pets. How can I actually add one? Thank you. 

I'm having trouble creating a Form that I can use for Performance Ratings, and having that Form's fields update the Record field for the table. I believe I might have this architected in not the best way. Let me explain below.I have a Table that list Vendor Records. Each Record tracks, names, locations, services, cost, etc.Additionally, these Vendor Records also track 4 Performance Rating Fields.In the Table Table, I created a Form, with the intention that I could provide this form to managers quarterly, and Have them fill in the 4 Ratings fields for the Vendors they manage. The full intent is that I would automate a quarterly email to send to the manager, for each Vendor they manage.When I test the form, I feel like I have set something up incorrectly, because there is no way for me to select a specific Vendor record, or even Default that for the Manager.When I fill in the rati

HelloMy brain is stuck on an operation that doesn't seem so complicated... butI have an "Event" table   and a "Days" table   Is it possible, or how can I achieve this result ("expected" page)?   I have a project in which events are created over time. When I create these events, I don't yet know the day(s) on which they will take place and their quantity (number of days).Would it be possible that when I add 1 day (or more) to a project, it creates a new record on another page ("expected" page)?

On April 4 my entire base disappeared.  We had been using this to track our inventory for the entire business since October of 2021.  I immediately contacted support and have still not heard back.  It has been 3 weeks.  This data was extremely critical for our business because it tracked all of our inventory.  I am hoping that the support team will be able to recover the data.  This happened to occur at the same time that Airtable released changes to their user interface, so I am not sure if that is related.  Please help!  Hopefully Airtable can access a "snapshot"  but I am not able to see them because they are accessed within the base, which is gone.

I am attempting transfer checkbox data from Webflow form using checkbox fields for multiple selects it returns a value of TrueTrueTrueFalseFalseFalseFalseFalseFalse via webhook what is the best approach to convert the true false value to multiselect - Thank you 

I am stuck 😫I am attempting to configure a webhook, but I continue to encounter a 401 error that seems to be related to the API token. I have thoroughly reviewed all the settings and ensured that I am inputting them accurately. Additionally, I am utilizing an Airtable pro plan, and there are no other users associated with my account, so I have all the permissions. Also if I put "Bearer" in front of the token it turns into a 403 errorAny guidance would be amazing!  

Hey All, I'm getting an error message about the Record ID when the IDs are the exact same. All automations are failing with the note "Record does not exist," yet the trigger is succeeding with the same Record Id. Photos below show the failing automation message and matching record Id from the trigger.   The Automation itself is based on formula fields which are populating correctly- photos below. If the Created Time (field) is within a certain Quarter (formula)- then update a single select field in the same record. I have this in 3 tables and for 1 everything is running correctly but for the other 2 everything is failing. Any advice before I submit to Airtable as a bug/glitch? 

I have a lot to learn in terms of building formulas, and I'm found myself stuck and not sure what I'm missing.What I'm trying to accomplish:If the Completed column checkbox is ticked, display "Completed"If the checkbox is not ticked, display the time difference between the 'Ready for Pickup' Timestamp column timestamp and now in days.My current (not working) formula:IF({Completed}=TRUE, "Completed",(DATETIME_DIFF(NOW(), {'Ready for Pickup' Timestamp}, 'days')) Thank you!!

Hi, I'm feeling a little stupid in this moment, because I know that I'm doing a little mistake🤣 but I can't find it!I need to print the actual hour, so if now it is 10:31 am, I need that the result is 10. I'm trying to use DATETIME_FORMAT and SET_TIMEZONE.. but it gives me error. do you know how can I solve this problem? 

Hello,I'm reaching out for ideas for doing an Accounting Forms (like a Check Request form) through Airtable. I love using forms to reduce data entry, however, I haven't been able to find a form that I can use to complete something as "complex" 😂 as a check request, specifically with multiple itemized lines presented in a Grid Format. Among other things, this Check Request Form would need Account Code, Description, and Dollar Amount *for multiple lines*. For example:Check #234 paying a contractor for services, expense reimbursement, and materials.Line 1: Fee for Services: Account: 100 - Description: Services - Amount: $1,000Line 2: Expense Reimbursement: Account: 200 -

Hi everyone! Well I’ve been using AirTable to help me organize my inventory and sales orders. But now I’m trying to build a template to help me organize my construction project. In general I’m trying to set up a tab in my table that tells me how much money I have available, so that it takes all of the money we’ve received from the client in different instances and subtracts all of the money given to different contracts and shows us how much is available. Is this possible? Thank you everyone beforehand!

I'm working with a long-text column in Airtable and need to insert line breaks into my text to help improve readability. Could anyone guide me on how to add a break (\n) in my text within a long-text field in Airtable? Any help or guidance would be much appreciated. Thank you!

When using linked records, is it possible to apply a value to only the first linked record in a cell?So if I have two tables.Table ATable BWith Table A, I'd like to find a way for the Revenue to only be a logged against the first linked record in the Products column. Is there a way to do this?(I can't do it the other way around - so applying the rollup to the first linked record only in the Sales column on table B, since I do need to be able to sum multiple Sales in this column). Effectively, I need to be able to roll up revenue from sales against each product, but in cases where multiple products are placed against a sale in Table A, I only want the revenue to be assigned to the first product in the list. Hope tha

List A: the, cat on, was not, sat onList B: cat on, sat onoutput: the, was notEDIT: List A & B are linked fields. Linked to the same original field.I want to implement this functionality. It is achievable using a SUBSTITUTE on list B to add the relevant REGEX characters []* etc.This substitute would be placed in a REGEX_REPLACE to remove all the words in list B.I know it’s doable - but I struggling with the regex. Can anyone help please?

I want to be able to extract capital letters from a string (name of a type of event) to create its ID CODE.This way I can keep my ID CODE as a formula, not manually, and still control how it comes out through the capitalizing of letters in the name.For example: NeuroGym = NG Business Meeting = BM Annual global Event = AE Monthly internal Event = ME Business Event = BE