Solved

Hi there, I am trying to create a script that will create new records in one table based on ‘template’ records from another table, and I’m running into an issue when creating the records with Multiple Select fields. I can successfully use the “creatRecordsAsync” method to create a new record, and can successfully push a string or a boolean to the record. But when I try to create a new record and push a Multiple Select value in, it is erroring out. The string value that I am trying to push in matches the string value of the Multiple Select option in my target table. But I am getting this error when I run the script: Error: Field “fldntpeWlvbdfgN8Z” cannot accept the provided value. Any insight? I’m guessing I need to find out the id of the Multiple Select value I’m trying to push somehow?

I have a script that generates the complete contents of an HTML file. I’d like to output this HTML file as an attachment in a field. Is it necessary to call off to an outside service in order to create an attachment with that HTML content? I don’t need the URL of the attachment to persist very long. The usecase is I need a non-technical person to be able to download the HTML file after it is generated with variables that person has just specified. I have a version of this working using GCP, but I’m wondering… can be done entirely within Airtable?

Hello, I’m trying to extract the final number at the end of a string like this: Josh-B7-3 Ben-B8-28 Chris-BN-294 I want to extract just: 3 28 294 Any ideas? Appreciate your time :slightly_smiling_face:

Hi everyone! Does anyone know how to actually build this out?: Build a No-Code Automated Infrastructure with Airtable - YouTube I want to build Operational Databases for my clients and would love to be able to know how to do so. Thanks in advance,

Hello, I have a problem with the rollup field, it stop working on my base. I can’t have the second element to choose to summarize the data … Has anyone ever experienced this?

I am working with the Airtable API in GoLang and I am using this client. I have 150 records. I am trying to fetch the first 50, then next 50 and so on. I do this by sending the following HTTP request (with the help of the client): /v0/appXXXXXXX/tblXXXXXXXcellFormat=string&offset=50&pageSize=50&sort%5B0%5D%5Bdirection%5D=asc&sort%5B0%5D%5Bfield%5D=Name&timeZone=Europe%2FLondo n&userLocale=en-gb Note the &offset=50. When I send this request I get the following error: “error”:{“type”:“INVALID_OFFSET_VALUE”,“message”:“The value of offset 50 is invalid” I have tried removing the offset parameter and it gets me the first 50, but how am I supposed to get the next 50! Below is my Go code using Mehanizm’s Client:

Hello everybody! I was wondering is there a way to make it so that airtable and chose a record randomly?

I have tried to add 100 options to multiple select questions in Air table Form. Is there any tips in how to do it quickly?

Hello, I am building an automation to create a record when an email is received. Each of these records also need to include an attachment that is received with this email. Is there a way that I can import that attachment into airtable as well.

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?