Solved

Hello, I created a few simple databases in Airtable and wanted to test the access to them with Power BI. I tried this simple query with Postman: https://api.airtable.com/v0/<BASE-ID>/<TABLE-id>?api_key=XXXX and it works great and instantaneously. But the same URL in PowerQuery like this: Json.Document(Web.Contents("https://api.airtable.com/v0/<BASE-ID>/<TABLE-id>?api_key=XXXX")) is not doing anything. Just trying to establish a connection or I don’t know. It doesn’t give any error message. I also have tried this guide: support.airtable.com Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support This article outlines a solution to efficiently and automatically bring information from your Airtable base into Microsoft Power BI and... and it is also not working and not giving any error message.

I’m trying to find a way to send a copy of a form submitted by our Account Executives by using something else besides automations. I have only 2 slots left of the 25 limit and would rather not use them for something as simple as this.

Hi there - I need help building a formula that tracks if tasks have been completed early, on time, or late. I have a column where I mark a task complete, so it will have to start with If status = complete, etc. I then have a column each for “Start Date” and “End Date” (projected end date). Then a separate column for “Completion Date” (actual end date). I cannot for the life of me get all the parentheses right, this is what I have, but it’s not functioning correctly: IF( {Status}=“Complete” IF( IS_BEFORE({completion date}, {end date}), “Done Early”, IF( IS_SAME({completion date}, {end date}), “Done On Time”, IF( IS_AFTER({COMPLETION DATE}, {END DATE}), “Done Late” ) ) ) ) Any help would be appreciated! (Simplified example attached)

Hi there! I’m looking to replace text a field with a figure from another field. I can get this to work if I reference the code via another field but I can’t figure out how to insert it via a formula (so that I don’t have to fill a field with this dummy data every time). Not too familiar with markdown/the symbology etc sorry!

I’m trying to create a script in Airtable linked to a button. The process is as follows: Button within Airtable pressed If the checkbox field ‘switch’ is false, then turn it to true Wait for 2 seconds, reset the field to false This is the script I’ve written using the setTimeout() function: let table = base.getTable("EXM"); //The name of the table you're in here let record = await input.recordAsync('Pick a record', table); if (record) { if (record.getCellValue("switch")===false) { table.updateRecordAsync(record, {'switch': true}); output.text('checkbox ticked'); } const myTimeout = setTimeout(timeDelay, 2000); function timeDelay() table.updateRecordAsync(record, {'switch': false}); output.text('2 second interval'); } When I write the code I get an error that says “cannot find name setTimeout”. As a solution, it suggests “add missing function declaration ‘setTimeout’” How do I declare this function so it can function with my code?

I’m having trouble with something that seems very simple. I’d like where it says “0.9 available” for it to show that time formatted as “h:mm”, as it does in the “Time Available” field next to it. Here the formula for the Name field: Essentially I think I need to convert seconds to hours, minutes and seconds within a formula, but I can’t find a way to do it and feel I’m probably just missing something simple. Thanks so much.

Hey all, I’m attempting to create a formula that will automatically create SKUs from several different columns, but I’m running into a few issues. Below is the formula I have so far: SWITCH( {Brand Code}, "Kala","KA", "UBASS","UB", "Makala","MK", "Ukadelic","UK", "Kala Percussion","KP", "Kala Elite USA","ELT" )&"-"& SWITCH( {Product Type}, "Acoustic-Electric","AE-", "Guitar","GTR-" ) &SWITCH( {Type Code}, "Solid Top (2)","2", "All Solid (3)","3", "Solid Body (6)","6" ) &SWITCH( {Top Wood Code}, "Cedar","C", "Spruce","S", "Striped Ebony","SE", "Koa","K", "Acacia","A", "Mahogany","M" ) &SWITCH( {Back & Sides}, "Mahogany","M", "Rosewood","R" ) &SWITCH( {Size Code}, "Tenor","-T" )Preformatted text I want the {Back & Sides} portion of the formula to only show up if it doesn’t match with the {Top Wood Code}. For example in row 3 I have a ukulele that has its top, back, and side wood listed as Mahogany, but my current formu

Previously I’m using multiselect field from the current table. However, I am trying to automate by pulling the multiselect field from the LOOKUP. But when I want to run the script, I am unable to do so. Here is the structure of the base My current script let templateName = r.getCellValue(s.tempField.name); console.log(templateName) let monthName = r.getCellValue(s.monthField.name); templateName.forEach(item => console.log(`${monthName}; ${item.name}`)); let combinedArray = templateName.map(item => `${monthName}; ${item.name}`); console.log(combinedArray); output.table(combinedArray); How to modify this script? Thanks!

I manually entered numbers in a Single Line field, then I changed the field type to Number, and the last two digits of the numbers changed before my eyes for no apparent reason. The change is in the last two digits (14 changed to 20, and 05 changed to 00). Note that I didn’t make a typo - I watched the digits change when I changed the field type to number. I tried making a new number field and copy pasted the values in there, but the same thing happened there. I tried the same with a formula field with the same results. It’s not a rounding error - the number field format is set to integer, and so is the formula field. The screenshot SHOULD show the same number in every field - the “Group ID” field has the correct number. Is there a ghost in the machine?

Hi, I could use some advice on the following use case. One base, four tables: Products Orders Order Line Items Out of Stock Products Orders are linked to its Order Line Items, and each Order Line Item record is linked to 1 Product record from the Products table. Additional lookup data of the Product record is gathered in both the Orders and the Order Line Items table. Now here is the main issue: Product records are automatically (via scripting) moved to the Out of Stock Products table once they hit a quantity of 0 (and let’s assume we manually adjust the quantity of these product records). Once a product record is moved though, the link between the Product record and Order Line Item record is removed, causing all the additional lookup and summed up data of my final Order data to be flawed. Somehow, I need to retain that product data in the order. I’m looking for any type of suggestion to deal with this use case to retain the product data in the orders. Could be going anywhere – from

Hi, I would to retrieve an array of all single select options from the api. but i dont know if its stored anywhere… Is it possible?

I was wondering if there’s any script that allow me to check/ uncheck the box? I can only do one but I want to make a toggle checkbox. This is the script for check only let table = base.getTable("Product List"); let record = await input.recordAsync("Interest", table); let recordId = record.id; await table.updateRecordAsync(recordId, { "Interest" : true, })

Hi team, I am using the scripting block to add a new single select option to a bunch of fields at once. Is there any way to specify the color of the item? Currently they all seem to be adding as grey by default. Thanks!

Hello all, How do I add time to a Date field using the scripting block in automations? I know about DATEADD() in formula fields but I’m trying to iterate through a loop. I want to automatically create an indeterminate number of new records where each record’s Date field is the next day (19th, 20th, 21st, etc) in other words, n = n + 1day. Is there some way I can do this in my script’s for loop? Or some clever way to do it with formula fields? Thanks,

Hello, I’m looking for help with a formula/script/automation. I have 5 fields that are checkboxes noting a user’s role. Some users have none checked, some have some, or even all. Also, these fields may be updated at any time by the user, so need something that updates automatically (both adding or removing a role). I need another field that uses the title of the checkbox field (or text I provide), and puts them into one field. I’m struggling with adding commas, because they only need a comma if another role needs to show up behind the prior one.

Hi all! I’m working on an automation script which needs to get the current date so that it can be formatted for a URL. However, calling the .getMonth() function on a date object returns an incorrect month. I can of course correct for this by adding 1 to each month but would prefer not to. I’ve created a new script which creates a date and logs the resulting month to demonstrate my issue: The code: The resulting console logs: Has anyone encountered this issue before? Thanks!

Hello, I have a table with about 1700 records. I’m pulling a couple of records and doing some math on all the rows, then updating the result in a new record. The bulk update code I’m using is waaaay faster than a single row update, but it’s still taking about 45-60 seconds. That’s too slow for me to run an automation, which has a 30s timeout. Is the following code inefficient? while(updatedRecords.length){ await table.updateRecordsAsync(updatedRecords.splice(0,50)); } Regards, Scott

Hi, I can’t seem to figure out what’s wrong with my formula. I’m trying to convert a UNIX timestamp which is in a Single Line Text field, into a corresponding date field. My UNIX is in a field called _eventTimestamp and value is 1663598125000 stored in a Single Line Text field. My date field has the formula DATEADD('1/1/1970',_eventTimestamp,'seconds') and the formula results to 4/30/54687 2:16am I can’t seem to figure out why that is. I checked the UNIX timestamp online and it shows me the correct converted date It’s probably a blindspot but I can’t seem to figure out why I’m getting a weird value for the date in Airtable. Any help would be much appreciated. Thank you. Update 1: I even tried converting the UNIX timestamp to a numeric value thinking the DATEADD needs to add a number and so I tried the formula DATEADD('1/1/1970',VALUE(_eventTimestamp),'seconds') …but I still get this odd date 4/30/54687 2:16am Update 2: SOLVED For anyone interested in the solution, I finally figured

Hello, the default Delete duplicates extension is awesome to remove with one click all duplicated records at once but have a little problem, its removing new records and keep first one, how i can invert the process and keep the last record instead of forst ? remove then all old records and not new. here is the default code : let settings = input.config({ title: 'Delete duplicates', description: `This script will delete duplicate records in a given table according to the value of two input fields. Duplicate records are detected when they contain the same cell value for each identifying field. For any two records that are considered duplicates, it will use a third comparison field to determine which of the two records should be deleted.`, items: [ input.config.table('table', { label: 'Table' }), input.config.field('firstIdField', { parentTable: 'table', label: 'First identifying field', }), input.config.field('secondIdFi

I’m using airtable as a way to keep a product catalog for my company, both out of stock, and currently available products are listed, as to help customers compare products they like but may be out of stock, against our current inventory. Is there a way to script some code to identify specific markers (Flavors, similar categories, etc.) based on user selection/input, and for airtable to automatically recommend a similar product? I’m not well versed in coding, so any assistance would be appreciated!

Hey all! So I wanted to create an event, and CLEAR or DELETE the Google Calendar even when a checkbox/flag is clicked. This would be used when we cancel or reschedule but don’t want to delete the original entry. Currently I have three automations: These all work beautifully, but I wanted one more automation, unless the #2 could also update, but figured it’d be better to keep it separated as its own unique automation. Any ideas? I don’t see an option “Delete Google Calendar Event”. Thanks. Sean L

Hi I am trying to create an airtable with resources, rate, jobs no. quantity, amount and total. To do this I have created a master of inventory type with rate against each item. Eg: Small Carton $ 5, Large Carton $10 etc. Now I want to use that data for different jobs numbers. In each job i want to track the different types of resources used, quantity used, cost of each resources and total cost of resources used for each job. Eg: Job no. 50 - Small Carton $5 x Quantity 2 = $ 10 Large Carton $10 x Quantity 2 = $ 20 Total Cost = $30 Eg: Job no. 51 - Small Carton $5 x Quantity 1 = $ 5 Large Carton $10 x Quantity 2 = $ 20 Total Cost = $25 Eg: Job no. 52 - Small Carton $5 x Quantity 0 = $ 0 Large Carton $10 x Quantity 2 = $ 20 Total Cost = $20 Could you please help. Thanks Ajit

i’m seeing some very strange behavior in one tab of my base. my colleague duplicated the tab from another tab that was called “9/15 NYS Budget” and then renamed it. in the new tab, whenever you right click, instead of the options saying things like “delete record” or “insert record above,” it says “delete budget” and “insert budget above.” i made a copy of the new table including duplicating records and the behavior goes away. it’s not really impacting our functionality, but it’s very strange and caused some concern for my colleague! any thoughts? anyone seen something like this before?

Hi, im just beggining my learning journey with Airtable and im trying to configure a field wchich should pick a value from a switch and also if it finds an option on a multiple selection field then add a number to the result. This is what i ve been trying so far, but it doesn´t work. SWITCH({Clases a la semana},1,35,2,65,3,90,4,110,5,130,6,150,7,170,8,190,9,205,10,220,11,230,12,240) & IF(FIND(“Tips Club”, Horario), +40,0) Thank you in advance

Hey all, Hoping a relatively simple question! When you add a linked record column, it gives you the option to add multiple lookup columns (associated with that record). Is there anyway you can add multiple lookup columns AFTER you’ve created the linked record?