Ask the Community

Does anyone know the formula to subtract 3 hours from date and time field but... show just the time please? This formula provides the correct answer showing date and time but... DATEADD({Departure Date & Time},-3,'hours') ...when I add this to the formula to they and show just time -- the time is completely wrong. DATETIME_FORMAT(DATEADD({Departure Date & Time},-3,'hours'),'h:mmA') My attempts have resulted in a series of #Errors. Any ide

Hello everyone, I have two tables: Pre-production and Production. I was able to make an automation so if I "approve" a project submitted through form to Pre-production table, a new record is created in Production with the same name and info. Now I want to make an automation so if the info in Pre-production table is updated, it will also update the same info in the Production table. But I keep getting an error. What am I doing wrong? 

Hi. I'm creating a base that would be populated by the form. There'll be some fields that will be handled inside the base by paid users. I've created an automation that would send an email to a departement once the status changes. People would get a link to that record so they can change the status but when I tested it, an airtable account that isn't in our workspace doesn't have the ability to access that record. Is there a workaround that would allow people who are not in workspace to interact with  the base through the link generated in the automated email? All we want them to do is to change the status.I'm attaching a few screenshots. What we want is to have the user see the record as in the screenshot named airtable4. Thank you! 

Hey guys,I'm having trouble using a valuta like € 1.333,61 in a formula. It's being recalled from another table using a Lookup field. I've tried adding a new formula column/field and reformatting it first, before using it in a formula, but without any success so far. I keep getting the NaN error when using the value in a formula. All other fields/data in the calculation are valuta's like € 1.333,61 as well. Can you guys give me a hint? Thanks! 

Fingers crossed that there's a solution to this! I have data coming in from interface forms that is structured with headers like this:Name 1 / Email 1 / Address 1  / Name 2 / Email 2 / Address 2.... and so on, all the way up to 100! Yes, 100!We use this data to fill in PDF forms so it must come in as 1 row (at least with the app that I am using, I am using PDF Maker by Bustbrain labs).My question is, is there a way to split this data into multiple records like this:Name / Email / Address (header)Name 1 / Email 1 / Address 1Name 2 / Email 2 / Address 2Also, I need the data to sync, so that if there's an update on the 1st table where the data is in a single row, it will also update the data in the split records.I am open to a script, automation, syncing and duplicating tables, whatever I need to do to accomplish this. All the data I need is there, I just need it in a usable format!

I have an issue to retieve only specific fields from a aitable record const fieldsToRetrieve = ["BlogSL1", "BlogSL2", "BlogSL3", "BlogSL4", "BlogSL5", "BlogSL6", "BlogSL7", "BlogSL8", "BlogSL9", "BlogSL10"]; const response = await axios.get(`${BASE_URL}/appDP6faKvOeSxUKs/${queryKey}/${id}`, config);

HiI am a curriculum coordinator in higher education and have multiple bases/tables/forms that contain/gather information about course units in the curriculum. All information always relates to a course unit, e.g. Business Economics. All the information needs to be linked so I can always look up information in other bases/tables, but I'm not sure when to create a new base, create a new table in a base or create a new view. These are some of the data I have:Curriculum 'technical information': per course unit how many credits, elective or not, prerequisites, timing (SEM1 or SEM2) etc.Curriculum task allocation: information that comes from an export from our CRM which shows which lecturer will be teaching a particular course unit in which semester(s) to which class group. The unique key here is a formula field concatenating course unit - class group - semester - lecturer, e.g. Bachelor Thesis - Class Group 2 - SEM2 - John Doe. There should be a one-to-many re

I’m trying to make shortenings of company names using a regular expression, by taking taking the first letter every part of the name. Fx ‘Great Garden Centre’ → GGC I’m not sure if this is possible without a loop, but I’m also no buff at using regex. I’ve sofar I can only extract the first letter using this: REGEX_EXTRACT(Company, "\\b[a-zA-Z]") Is this possible without looping through every word?

Hello! I'm trying to set up automations so that each time a new form is submitted, an email notification is sent to 4 different email addresses. However, I get this error message: "Cannot email non-collaborators on the current billing plan."The problem is that the email addresses are from my bosses, who are the ones actually paying for the Airtable plan, so I don't understand why they are considered non-collaborators? I appreciate the help on this issue, I'm new to Airtable. Thanks! 

Hi all,I have a problem that feels like it should be simple but is giving me a huge headache, lol. Here are some past questions I found that seem to intersect, but I couldn't seem to find my answer in the replies: 1, 2 I replicated my problem in a sandbox base to try to narrow it down, but I'm still confused. Okay, two tables:1. Classes2. Staff. This is synced from the Data Library, and has the same sharing permissions on as all my other sync-able tables. I have creator permissions in both bases, and I'm the owner of the data set in the library. (I've also tried syncing directly from the base because the library is new to me, bu

Hello, im trying to improve my developer experience with automations in Airtable, have some questions:1. What type of linter is used? I tried eslint and prettier comments to disable linter, but it doesnt work2. What kind of formatter used? I want to change tab to 2 space instead of 4, but it always format with 4.3. What is the best way to have shared code between different Scripts?

Hey,I'm looking for an option in the Map - Geocode addresses or coordinates on a map extension to search for addresses.Currently we don't know the US map from top of our head and we want to search for an address to see which of our pins are close by

Hello! I have created a student database and while the linking between tables worked as recently as last week, the copy/paste function appears not to work anymore. Specifically, on the ‘Contacts’ table (see screenshot), any time a new record (student) is added, I would like to copy and paste that name into other columns which link to other tables such that the names show up in those other tables. For example, as seen in the screenshot, I would like to copy and paste the name ‘Kamala Harris’ to ‘Snapshot_link’ such that it shows up on the Snapshot table. However, I’m unable to do so-- I get a ‘Pasting…’ message and nothing happens. Currently the Name field is a formula, but it won’t work even if I make it a single line text.

Hi Community!I would like generate with a formula a random hex color code for each new record in a database. How can I do that?Thank you for your help!Stefan

Hey,Something super basic to do in any excel, python script etc. but how to get in in Airtable?I want to create some kind of ID for each customer. First customer has number 900100, and each new one (this is a child table) should get the number +100, so 900100, 900200 etc.Is there any way to do so? (ps autonumber is not an option as you can edit it, if something goes wrong and you add a row by accident it ruins the sequence)

How do I concatenate these two fields so they show values with not so many digits. I would like to show 2 decimal digits. 

Hi there, Can you help me, please? I am trying to run a script and it results that the record is not found, but it is there. I checked everything - the correct name of a table and view but it keeps giving this warning. Any tips?Thank you

We have an automation through Make.com which uses an API call to import data into Airtable. This has run for 18 months without issue. We are recently getting an error 'Field cannot accept the provided value' The data is a text string which begins with a hash e.g. '# 100'. The field is not a computed or linked field, it is a single line text field. I cannot see what has changed that this data cannot be accepted now. Any help?

Hi Everyone! I'm trying to design a judging system for a science fair styled event but I'm wondering if there's an easy way to do the judging assignment through airtable or if I can do it through Excel then transfer to airtable. Right now I have three tables: 1. Judges (All the judges are named and given a unique number) 2. Projects (Each team & their assigned table) 3. Scoring (A grid + form view where each judge can select their name + the team they're assessing through the form - I use linked records to group the teams and get final score). Is there a way you would recommend assigning each team 3 judges with team receiving any one judge more than once. Maybe there's some trick by using a number to represent each judge and the random formula... Would love any ideas. 

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.