Solved

For the following simple database example: Table called EMPLOYER with the following fields: EmployerName, Employees, Country. Table called EMPLOYEES with the following fields: EmployeeName, Employer, Country. Required AirTable automation: When EMPLOYEE/Country is Empty, copy the EMPLOYER/Country value to the Employees of each EMPLOYER. How would you setup the automation?

Hi, Airtable community! I’m writing a script in the Automations tab. My first trigger creates a new record called newEntityId. I want to link that newEntityId record to another record I’ve created in the script. My problem is that you can only get the record ID from the newly created record and the field type I want to link to is “Link to another record” which requires the object/record type. I’ve made a solution that works but throws an error. If the error could be solved, that would be appreciated! new record: error message: Code: let inputConfig = input.config(); let tasksTable = base.getTable("Tasks"); let taskQuery = await tasksTable.selectRecordsAsync(); let tasksrecords = taskQuery.records let tasksTemplate = base.getTable("Tasks Template"); let templateQuery = await tasksTemplate.selectRecordsAsync(); let tasksTemplateRecords = templateQuery.records; let taskTemplateLength = templateQuery.records.length; //Create taskTemplate.length records in Tasks field AND add all ta

Hey all, Within forms in the interface designer, is there anyway to display any additional data on a Linked Field? share.cleanshot.com CleanShot 2022-09-27 at 08.37.11 GIF uploaded to CleanShot Cloud For example, here I’d like to show the customers name (which is a field in the linked field table), not just customer code. Thanks!

Our employees are paid in multiple ways. First, the amount of Revenue they generate dictates Hourly Pay Rate for the week. We are able to import all revenue transactions from our CRM via .csv Revenue Report files. We have a chart that displays Hourly Pay Rate by Weekly Revenue level in the base as well. An Airtable form is used to capture timesheet entries from the field on a daily basis. The number of hours entered is applied to the Hourly Pay Rate to generate Straight Time and Overtime pay. Additionally, we pay bonuses for certain high value items that are sold (commissions are on another rate sheet in the base). Again, we use an Airtable form for field reps to submit bonus items that have been sold. Finally, in all situations, we are using DateTime functions to identify the Week of the Year for pay periods (Sunday through Saturday). So, all transactions include a Pay Period (Week of the year) in the records. All of this data is in the base in the following tables: Revenue Timesheet

Hi everyone, first off, my skills are a bit basic, so I hope you have patience with me… I have a text field in which multiple numbers are being output by an automation and separated with a comma (it displays the file size of attachments.) My goal is now to get the sum of all of these numbers in a formula field (I want to display the total filesize of all numbers combined). I have tried using VALUE(Internal Notes) but in that case the numbers are just mashed together and not being calculated at all. So instead of “100200” I want this to display “300”. Can anyone help me out on what to do? Or should this be resolved using scripts or something else? Any help would be much appreciated.

So I have 2 bases, let’s say A and B. Table 1 in Base A is synced to Base B. When 2 records with the same name lets say X are created in base A table 1, they enter a view on the synced table on B. When they enter this view an automation runs to create two new records in base B table 2 with the same name (dynamic field value). However when X and X are created in base A, I only want one new record to be created in base B’s table (when the name is exactly the same). What would be the easiest way to have the automation only create 1 new record named X? And it would be a bonus if I could have the new record in base b’s version field number to fill out as 2 when there are 2, 3 when there are 3 records with same name in base A and so on. Thanks!

Is there any option to directly fetch the collaborator name whoever is entering the record? I am using a shared base. If the above thing is possible, is it also possible using forms? Thank you in advance.

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