Solved

The formula is indicated on the screenshot. How to get Duration value, not a NaN?

IF + SWITCH formula can’t have a non-numeric value as True / False argument. If it does, the result of this formula is going to be ALWAYS non-numeric and thus can’t never be used as an input for calculation in subsequent formulas. For instance, if I have IF(Column1=“ABCD”,999999,“nonsense”)… the result of this formula is always non-numeric, no matter what the result. Even if the result is TRUE (that is Column contains ABCD), the result of the formula is non-numeric text 999999. To get numeric result, I have to change the formula to IF(Column1=“ABCD”,999999,“000000000000000”) and then I’ll get 999999 as numeric result. Same goes for SWITCH formula. This is an issue when the result of the IF or SWITCH formula is an input or variable in a subsequent formula because the result of the subsequent formula(s) produces an #ERROR! This is not a show-stopper but reduces the usability if I can’t have text “nonsense” as the result if the result of first formula is FALSE. What we need is the first

Hi, I’m having trouble with the following formula: IF(LEN({Copy})>150,“ :rotating_light: ”,“ :ok_hand: ”). It returns “ :rotating_light: ” if the Copy cell quantity is longer than 150 characters and “ :ok_hand: ” if less than 150. However, I’d like it to return a blank value if the Copy cell is empty. I’ve tried adding “BLANK ()” to the formula a few different ways, but it either returns an error message or doesn’t take. Any help would be appreciated. Thank you!

I have 2 fields that contain email addresses. The first column contains 1 email address and the the 2nd column contains multiple email addresses. I want to create a 3rd column that combines both fields with the appropriate commas separating each email address. What formula can I use?

I have two rollup columns that each contain (potentially a lot) of text values. Rollup column 1 will most likely contain some, but not all, of the same text values of Rollup column 2. I need a way to write a formula for a third column that pulls out any unique text that exists in column 2 that does not exist in column 1 and then shows what those unique text values are in column 3. (Essentially I’m trying to find values that don’t match between the two columns, but I don’t want to calculate just a true or false statement as to whether the two columns match. I want to know what the text values are.) Anyone that can help? -Thanks

I am using grouping in several of my views and I was looking at the “guide to grouped records” page from Airtable and saw that I should be able to hide no grouped records - so records that are empty in the field I’m grouping by. I went to do that, and I do not have that icon on my grouping dropdown. I saw that if I changed the field I’m sorting by to something else, it appears. The fields I’m trying to sort by are “calculated fields” and I only want to see the records in these views if those values have been calculated, otherwise I don’t want to see them. Any clue how to fix this on the grouping level or do I just need to filter them out? https://support.airtable.com/hc/en-us/articles/221747587-Guide-to-grouped-records#:~:text=Once%20you’ve%20grouped%20your,or%20hide%20no%20grouped%20records. This is where I saw that as an option, at the very bottom.

I feel like this is possible, but I’m not 100% sure. I know I can run a formula that says do “X” if the value is “Y” and otherwise do “Z”, but can that be done on whether the number is negative or positive? This is what I’m trying to do - I have a number field that captures the number of days before (negative) or after as listed in a contract. I need to calculate a date based on those numbers, but the date I calculate from depends on whether it is listed as before or after in a contract. So for example, if in the contract it says the survey is due 30 days before the end of feasibility, I need to use the feasibility date field based on that -30. If it says it is due 60 days after the effective date, I need to use the effective date field based on that 60. Hopefully this makes sense. Thank you!

I have an automation in which i get the record from the record update that triggered the automation, i then have an ‘if’ condition in which if the condition i want is true i put an output text that is later sent to the next action which is sending the text output on a slack message. the problem is that if the condition is not true i want to just stop the automation there and then and not send the message on slack, because right now i put the script output as the slack’s message and when the condition is false i get an error saying the automation has failed because of the slack message action (in airtable notification and in email and thats what i want to prevent). so is there a way to stop an automation in the script section or to at least tell it to ignore that failures so i wont get notifications in airtable and email about it? thanks in advance to any helpers.

I currently have a membership database in ACCESS and the membership number is the primary key. I want to get this into Airtable and keep the current membership number as the primary field so that it auto increments when a new record is added. I have read the article " How can I change the primary field in my table?", but it does not work. Or is there some other way of ding this? Thanks for your help. Mark

I’m setting an automation to send a slack message using a lookup field (formatted as string). The automation doesn’t get the value from this lookup field. I get an error message saying “This property cannot be used right now” Has anyone hit the same issue or has something to add to help?

I’m trying to figure out if the “Lightning” symbol synced records will add to the 50k record count.

I’m having a random issue and I’m not sure why. I have some forms in page designer and one of the fields is a formula that calculates today’s date, so when the letter/form is sent it has the right date at the top. For some reason, it is pulling yesterday’s date. I’ve tried refreshing and reloading the page designer forms, the whole website, etc. It still is showing the wrong date, but the formula column on the table is correct. Why is it pulling yesterday’s date? I’ve included some screen shots to show what I mean.

Is there a way to query a range of records provided by the API? I’d love to be able to cache the first 500, then load subsequent records on demand. The current pagination flow makes this difficult since the offset seems to be unique to the time it’s called. I’m looking for something similar to this SELECT * FROM table limit 500, 600

Bookseller here trying to survive by listing on Amazon. I have lots of books that are so old ISBNs didn’t exist when they were published. For those books, Amazon offers what they call a “GTIN” exemption. So I have two fields: (1) a single line field called {Product ID}, which contains an ISBN if available, but is, otherwise, left blank; and (2) and a formula field called {Product ID Type}, which needs to contain “ISBN” if {Product ID} is NOT blank or “GTIN” if {Product ID} is blank. I have no idea what might work here. Fingers crossed that one of you do. :slightly_smiling_face:

Hi AirTable Geniuses! I’m fairly new at this, but I’m hoping I could create a formula field that auto-generates an Amazon-friendly cell for each book record my old Homebase book inventory. Homebase allows for an infinite number of book binding descriptors, but the only ones on Amazon that work for my books are Hardcover, Paperback, and Miscellaneous. So my AirTable has two binding fields: HOMEBASE BINDING and AMAZON BINDING. The first will just be copied from my old database. I think the second, though, needs a formula that starts like this: IF({HOMEBASE BINDING}=“Hardcover”,“Hardcover”,IF({HOMEBASE BINDING}=“Paperback”,“Paperback”,IF({HB BINDING}!= This is where I get stuck. How can I tell my AirTable table that if HOMEBASE BINDING does not equal either “Hardcover” or “Paperback”, my AMAZON BINDING field should say “Miscellaneous”? I’d be mighty grateful for some assistance with this one! It would mean not having to comb through 25,000 records. :slightly_smiling_face:

Hello team, airtable api are failing & throwing random errors, works on local but fails on production… API Code - const Airtable = require('airtable'); const base = new Airtable({ apiKey: 'API_KEY', requestTimeout: 1000 }).base('BASE_ID'); function updateAirtableSheetValues(data){ base('Table 1').create([ { "fields": { "Name": data } } ], function(err, records) { if (err) { console.error(err); return; } records.forEach(function (record) { console.log(record.getId()); }); }); } export default async (req, res) => { if (req.method === "POST") { const { body } = req; updateAirtableSheetValues(body.data); res.statusCode = 200; } res.json({ msg: "Thank you" }); }; Error -

IF(FIND(“EN 60065: 2014”,LVD),“YES”,"") This can work in Excel, but does not wo rk in Airtable, why?

Is it possible to use rollup to pull the sum of values from two different fields (both in the same view) into a single field in a second view? I’m designing a teambuilding exercise app. It tracks exercise efforts from various teams, based on A) non-walking activities and B) Walking. In the main view, one field uses various formulae to convert different types of exercise into their “step count” equivalent. For example, 30 minutes of playing basketball is worth 5000 steps (not really). The second field only requires a number input by the participant, based on a pedometer reading. In the end, both fields need to be summed together to show total steps taken by each participant. The expectation is that participants will record steps (from walking) and step equivalents (from non-walking activities). Thanks in advance.

Here is the use-case/workflow: Assume we have multiple workspaces and bases. In the desktop application, when user A wants to share the link to a base with user B, already a collaborator on the base, how can this be accomplished. On this browser it is simple. Copy the link from the address bar and share it. How can something similar be accomplished in the desktop application? The Share button has options that are not required for existing collaborators. Of course, the base name can be shared and that can be searched. But this involves multiple steps. Thanks!

Hi, Any idea how to get rid of the Automations pop-up? Automations - great! - but how of this annoying pop up???

I don’t see the sync related options in my (pro) account yet

Hi all! I know that I cannot currently link two bases, and I also cannot currently limit permissions within a base to show users specific data, so I’m trying to find a workaround to my problem and am stuck. I have a CRM built for our sales associates with various tables including Client Database, Interactions Log, Tasks, Transactions, etc. There is data I’d like my executive team to see that I don’t want visible in the sales CRM such as summaries of sales by individual person, # of new customers brought in by sales associates, $ amount in sales by person, etc. I want them to view their individual stats, but not have access to view everyone’s sales stats. But, I want to summarize that data to make it visible to the executive team. My thought was to keep my CRM base as-is, and create a second base titled “Executive Base” that would show/summarize the higher-level data. I attempted to make a zap that would create a new record in the Executive Base when a new record is added to the CRM bas

Hi there, excuse my ignorance! I am very new to Airtable and I am trying to set up a simple inventory system of moving hundreds of items (Props for a film) from one location to another. I have fields set up for the various locations as a checkbox. ie. “PROPS STORE 1”, “PROPS STORE 2” etc… If I move a prop from “PROPS STORE 1” to “PROPS STORE 2” - is it possible for the “PROPS STORE 1” box to automatically UN-check? Basically, I am trying to make it so that only ONE of the check boxes can be checked at any one time. So it is not possible to have an item in two places if a crew member forgets to uncheck a location box. By default the system will only allow you to choose one check box. Many thanks for any advice!

I am very new to Airtable, and am after help with the script block. What I would like to achieve is exactly what has been given as an example here. This is what I have written: let lineItemsTable = base.getTable(‘Order Line Items’); let siteOrdersTable = base.getTable(‘Label Orders’); let productsTable = base.getTable(‘Product Inventory’); let siteRecord = await input.recordAsync(‘Select a Site’, siteOrdersTable); if (siteRecord) { let labelRecord = await input.recordAsync(‘Select a Label’, productsTable); if (labelRecord) { let quantity = parseInt(await input.textAsync(‘Quantity’), 10); let recordId = await lineItemsTable.createRecordAsync({ ‘Job’: [{ id: siteRecord.id }], ‘Item’: [{ id: labelRecord.id }], ‘Qty’: quantity }); let allRecords = await lineItemsTable.selectRecordsAsync(); let record = allRecords.records.find(record => record.id === recordId); output.markdown(Added new Label Item: **${record.getCellValueAsString('Description')}**); let addAnother = await input.buttonsAs

I have a base with columns (fields) in a given order horizontally across the page. I want to move some of these columns so that the are in a different order across the page. How do I do that?