Ask the Community

I'm having difficulties understanding how to link these two tables and would appreciate a little help.Table 1 called "Products" looks a bit like this:MakeLineModelTypeDellLatitude123LaptopDellOptiplex3231DesktopHPProbookA34LaptopAll the fields are Single Text except Type which is Single SelectThen I have another table called 'Processes' with only two fieldsTypeProcessLaptopBox AssemblyLaptopScreen ManufactureLaptopPSU TestingDesktopBox AssemblyDesktopCase Paint

Hi, I have two tables in a Database.One table: called "People". It has list of peoples and their Emails.Second table: called "Mailing" Has email from table one.I would like to set an new field in "People" (table 1) that marks "1" if an email is present in both tables. I called this field "Did_I_found_Email" (1 = yes, 0 = No).How do I do this?    

Hi allI have an Orders Table and an Order Line Items table.I have a Date Required field within the Orders Table which is linked to my Order Line Items table.I want to have an Updated ETD (estimated time of departure) field against each line item so it is separate from affecting the overall order ETD (i.e. each line item with one order can have a different ETD).Ideally I want to just show the format as mmm-yy (i.e. July-24)Any ideas on automating this so that the Updated ETD takes the Date Required data but can be editable? Thanks!

Is there anyway to change the “row Height” of the primary row? I have a sheet with a bunch of check boxes, but the rows are very wide due to the names (that can no be helped) It makes the checkbox feature seem pretty useless. Anyone know how to change that or be able to “:wrap text” in the primary row?

Dear all I have 3 tables.1. table is a list of construction sides.2. table is a list of for different services that we offer on those construction sides. Each record has the name of the service and the linked construction side. Here are all services of all construction sides listed3. table has one field where you can link to services from the second table and a 2. field where you can put the time it took to finish the specific service.This 3 Table should be populated through an Interface. Best would be a form. But i dont want the user to see all services of all construction sides in the menu for field 1 but allow him to filter for construction sides.Any Idea how to do this?I would be greatful for help!

I have two numerical values, A and B, that I am using to create a range field. Here is my current formula:CONCATENATE({A}, "-", {B}). So far so good. The tricky part is that not all of the entries have a B value, in which cases the result will look like {A}-. Ideally I would like it to just return the single value from A without the hyphen in this scenario. I have tried using an IF to say IF(BLANK({B})) but here is where I get lost.  Any advice is appreciated! I am very new to formulas... 

I have just started working in airtable and want to make a base for my highschools National honor society to start up a virtual online tutoring service but I am having problems with designing the forms for submission. Currently I have a tutoring sessions table, students table and tutor tables. I want to make a form that allows a student to input their name and email that will go as a record in the student table then link itself to a record in the tutoring sessions table that will have the date and time they want the session that the student will also input in the same form. Is this possible? Also I need some help on designing a way to make it so that existing students don't have to input their name for every form submission and just find it since we already have their names so I can do better tracking on the data. How could I do that as well? 

Hi AllMy apologies if this is too simplistic - I’ve only got six months or so experience with Airtable…I suspect use case doesn’t matter here, since my “issue” is at the record and field level. Here is the scenario:- a form with some fields pre-filled is sent to a Client for additions and updates, is submitted by them, and creates a new record in an UPDATE table, separate from the main, “real” table; Clients often have no regard for “garbage in, garbage out”…- a manual review of the two tables “side-by-side” is performed to make sure data in each field is the type of data expected - both in text and attachment fields- an automation does an “Update Record” on the main table, using the data from the UPDATES table record, hence moving the new data to the Client's existing record in the main tableThe result is that blank fields in the UPDATE table overwrite existing data in the main

Hi there, Is there a possible way to dissable a botton for certain records? Thanks

Hi,I'm afraid I couldn't find the correct Airtable documentation on this, please point me in the direction if there ready help somewhere.In an automation I have a conditional logic step. In that I have two conditions to be be met. One is a "type" kind of single select field, which translates to "Mini Day" in this case. This works.The other condition tries to look for text in a rollup field. Here is the problem, I can't get it to work and can't figure out how 'contain' works. In the preview field I can see the text I'm looking for, eg "Digi-Gold", but it doesn't work when tested.Here's a screenshot of the view:I also tried other text strings ('perusmaksu' and 'sessio') but nothing I tried works.What are requisites for "contain" to work? How does it work? Can I use use one condition to find several text strings, e.g. "sessio OR gold"?

Yesterday I was all of a sudden able to access interfaces from my ipad. This morning I saw an email confirming the feature. But when I went back in this morning the interfaces were gone. Can someone help here?

Hello everyone, In Germany, there is a regulation in the Occupational Health and Safety Act that states workers who work on Sunday or on holidays receive an additional allowance on their salary. This involves a complex formula, which even ChatGPT struggles with. Maybe there is someone here who is smarter than AI.My table includes a date field including time field named {Start} and a date field including time field named {End}. I want:1. Formula field = formula that calculates the hours/minutes that fall within the period of Sunday.Example : Max starts his shift at saturday 8 PM and works until Sunday 4 AM. The formula should now calculate 4 hours.2. Formula field = formula that calculates the hours/minutes that fall within the period of holidays. The holiday dates should be defined in the forumla itselfs = ( 01.01.2024 / 29.03.2024 / 01.04.2024 / 01.05.2024 / 09.05.2024 / 20.05.2024 / 03.10.2024 / 25.12.2

Hi !I'm new to Airtable and I created a base to help me manage some operations for a car rental company that operates in 2 cities.I have 3 tables with the same single select field (City : A or B) The tables are : Cars, drivers and Missions.The Missions table contains several fields including the city (A or B) and linked records fields to the Cars table and to the drivers table.What I want is In the Missions Table, when I select a city (city A) and then I want to choose the car, it only displays in the list the cars that also have the same city (A) in its single select field for the city, and also for the drivers to diplay only the ones in the same city (A).I don't want to create 2 different tables (one for city A and another for city B) and link the records to views in the cars and drivers tables.Is there a straightforward way to do it without changing the structure of the table ?

Hi! I created an Airtable to help plan my wedding. I have a table that's for Guests and in this table I have fields for their first and last name and their title (Mr., Mrs., etc.). I created a field that adds all of these fields to create their formal name on the invitation envelope. Right now the formula reads: Title & " " & {First Name} & " " & {Last Name} & " " & "&" & " " & {Guest Name (from Relationship)}  Here's where the problem comes in, for my single guests it puts the "&" after their name, for example, "Mr. John Smith

Is there a way to disable download button that appears below images in gallery view? I have attached screenshot.

Hi there, I'm looking to bulk create a handful of training sessions based off an initial kickoff date. I have a table of training sessions and a template table with an offset from the first session. Most trainings run on a regular basis, but sometimes we need to reschedule. For this reason, I need the result to be a normal, editable field (not a formula I can't touch). I am using automations to create the number of sessions I need. I also have an automation to populate the first training session based on a value on another table that will be entered manually. I can't figure out how to populate the subsequent dates for sessions based off an offset. I tried a DATEADD() formula to sum my duration field (the offset) with the original date, but that didn't work. In plain English, if session 1 is today, session 2 will be next week in the same time and place, session 3 will be 2 weeks from today, etc. Any ideas? I a

Hi all,Is there a way to view a breakdown of automation runs by time period (e.g. billing period) and more importantly by base > automation?I want to bring my run numbers down (so I don' have to upgrade) but it's not easy to see which automations are eating into my quota. I know I can see number of automation runs in total per workspace, for the current cycle, but need more detail than this.Thanks! 

Hi all!I'm using an interface to create and update records and allowed to create a new record. My team has been using it for a while and love it, but suddenly the "submit" button disappeared and they can no longer create a record through this interface. It's showing as "deleted field" but it was never a field (it was the setting to allow for creation of the record) in the table and i didn't delete anything... I'm going crazy- how do i fix this? (see attached picture)

I want to create a cash flow table for a month, where the beginning of the month balance automatically or with the help of a formula gets data from the end-of-month balance of the previous month.Manually entered at the beginning of January "beginning of the month", all the rest is automatic.And so on for all months.I have tried to do this with a formula, but unfortunately with no success.I need your help 🙂

ContextI'm putting together a volunteer sign up sheet (an Interface). The sheet goes live at a specific time, and people will be waiting by their computers so they can get the more desirable shifts. Once a shift is assigned, it no longer appears on the sheet (it is removed from the View underlying the Interface). However, it's not immediate. This means multiple people can click a shift's "Pick Shift" button before the record is removed from the view and button inaccessible.I need the first person to click the button — or at least the first click we hear about because of latency — to be the one who gets the shift. (This would be trivial in SQL, including in Supabase on which Airtable is built, but, alas…).Believe-it-or-not, I figured out how to do this (or at least get extremely close) with a Script in an automation. It's low-key bonkers, but it works! The problem I'm hitting now is how to notify the correct winner.The setup: My schema (simplified)

I have a database with two tables “gifts” and “status”. I'd like to use a button to update the status automatically via a script. I searched the documentation and the forum, but I couldn't find any solution to adapt the script to my problem. Here's the code I've already added, and the options I've explored.This is my code :// Récupère la table Cadeaux let tableCadeaux = base.getTable("🎁 Cadeaux"); console.log(tableCadeaux); //Récupère le champo statuts de la table Cadeaux let statut = tableCadeaux.getField("✅ Statuts"); console.log(statut); // Récupère le record.id de la table Cadeaux let queryResult = await tableCadeaux.selectRecordsAsync({fields: []}); let record = queryResult.records[0]; console.log(record.id); // Récupère la table Statuts let tableStatuts = base.getTable("✅ Statuts"); console.log(tableStatuts); let newRecordIdToLink = '🎁 Réservé'; tableCadeaux.updateRecordAsync(record, { "✅ Statuts"

I have 3 tables - Gift Hamper, Products, BOM Gift hamper - has list of gift hamper ids/namesProducts - have list of productsIn BOM we assign products & quantity to Gift Hamper (one gift hamper can have multiple products)While linking a product in BOM, I would like to see some values from Product columns (eg stock available). I would like to do this in grid format & not add each row individually using form.How do I do so? 

Hi there,I am new to using automations and hopeful this is something I'm just overlooking. I'm having trouble with an automation for a "Shift Reminder" SMS.Goal is:1. At a Trigger time find records with a Start Date of "day after" trigger2. Send SMS to associated cell numbers with each trigger to remind of shiftI have no issues if there is only one record returned. The SMS goes through without issue. If there is a second record returned the first record SMS goes through but the second record SMS is ignored.Would be so appreciative of any help! Thanks!  

Hey Hey, Would anyone happen to know if it's possible to embed a MathJax rendering into an airtable interface? The idea is that the rendered displays the text of math expressions or equations when that text is wrapped in $$ $$. 

Hello,I would like to know if there is a way to automatically use the same colors for single select and multi select options for cohesion and ease of viewing.For example:1. If I have a survey, all Yes/No questions will automatically make 'Yes' chips green and 'No' chips red.2. If I have several multi-select questions with answer options 'Strongly agree, Agree, Disagree, Strongly disagree' I can Strongly agree - color green, Agree - pale green,  Disagree - orange,  Strongly disagree - Red Thanks!