Solved

I have written the script below to select records from one table in my base and insert them as new records in a second table.  The script is working, however it times out after running for 30 seconds.  The process is selecting and creating about 200 records.   Is there a more efficient way of writing this script so that it happens faster and doesn't hit the 30 second limit?   I've read that maybe i need to create an array so that multiple records are inserted at once, but I am brand new to scripting and not sure how to achieve this.Any updates / changes / suggestions would be most welcome!Thanks    //Script Purpose: //1. Select fields "Client" and "Client Family" from all records in the table "Client Master" //2. Using these values, create new records in the table "Bank Recs" //Define source table let table = base.getTable("Client Master"); //define fields to retrieve const fldClient = table.getField("Client") const fldClientFami

I tried using interface designer and it is a very cool feature. One thing I would suggest to have is a sharing the interface like a view. For example, I would like to share particular interface in read only mode and do not want the user to be able to go and see all contents of the base. Currently, if I give read-only permissions the user can go and see all tables in the base.

I'm trying to format Canadian postal codes. Often the person enters them as k0e1b0. I need them to look like K0E 1B0. UPPER({PostCode}) will make them upper caseREPLACE({PostCode},4,0," ") will put the space in the middleHow can I do both of these steps in one formula field?

HI, I have the following problem - pls see also the screenshot enclosed for deeper explanation.I set per script a link in a multi-link enabled cell/coloumn. This works fine:await table_tacs.updateRecordAsync(per_positive_tac, {[nameReplacedBy]: [{id: newrecord_miete}]}); I then want to add in the same cell a second link, i.e. attach a second link. I try to do this with this command:await table_tacs.updateRecordAsync(per_positive_tac, {[nameReplacedBy]: [per_positive_tac.getCellValue(nameReplacedBy),{id: newrecord_BK }]});But this throws an error (see screenshot) - I tried various ways, but none works; Any help from the community? If there is a better way to get the topic solved - also fine: the objective is just toset the 2 links to "newrecord_miete" and to "newrecord_BK " in one cell, which is column "nameReplacedBy" of the record "per_positive_tac"Thank you!, Chris  

Hi, I need an attendance tracker for a nonprofit organization that organizes different activities throughout the year. I first tried doing a form that our coordinators of each activity would use to report the activity, time, description/impact, and attendance. The attendance is linked to a table that compiles the beneficiaries of the different activities that are run by the Non-profit. We already have some beneficiaries or previous participants in this table and so some of the attendees are already in our records, but when we have new attendees, I would like to be able to generate a new record from a form. I am able to add a new record in the grid view, but not in the Form. I have already tried doing an interface and it still won't give me the option to add new records in both form or interface. I do have a plus plan (not the free version).Our objective is to be able to have a beneficiary registry or a complete list of beneficiaries to report to our donors every year. We

Hello Airtable Community!I am trying to build something and I am STUMPED. Hoping someone can help! CONTEXT: I run a coaching business that services multiple clients. I am trying to build a tracker that tracks the number of coaching sessions that are booked each month.I would like to track (1) total number of monthly sessions across all clients and (2) the total number monthly sessions for each client. Clients can book up to 3 sessions.Currently, I am only doing (1) total number of monthly sessions across all clients. I have a table that records each booked session and links it to the month that it was booked in. The linked record then uses a count field to sum up the number of Session #1s, Session #2s, and Session #3s. Lastly, I use a formula field to sum up the total number of All Sessions (#1 + #2 + #3) to get a total of sessions booked for each month.THE PROBLEM: Currently, since each record is linked separately by session number, I am not able to easil

HelloI imported a excel doc where I prioritize items based on a 1-4 scale for sorting. I also use "Z" to sort items to the bottom that no longer need a priority. After I imported to airtable, its only letting me sort my priority column "First - Last" or "Last - First" which I am not familiar with. So i changed the "z" items to "999" thinking airtable might only recognize numbers. Didn't help. The "1" priority is still not sorting to the top.In short, I get that airtable wont sort as if it was a spreadsheet but i need to know how to label my prioities so they sort.Right now, I am using 1 - Ultra High2 - High3 - Medium4 - Low999 - Unavailable or ScreenedHelp?

I have a script, creating records from an API. The API data works fine. Instead, I'm having trouble entering a Linked Field value. I understand it needs to an array, but I can't get it to work.I have one table of Schools. The script loops through the schools, does an API call using the school ID, then creates records in the Courses table."school.id" returns the Airtable record ID correctly in the console log. I need that to be entered in the School Link field at the end. Please let me know what I'm missing.  let schoolsTable = base.getTable('Schools'); let schoolsView = schoolsTable.getView("Schools View"); let schoolsList = await schoolsView.selectRecordsAsync({fields: ['Account ID']}) //get school IDs for (let school of schoolsList.records) { console.log(school.id) let currentCourses = await remoteFetchAsync("https://XXXX", requestOptions); const currentCoursesData = await currentCourses.json(); console.log(currentCoursesData); //create records for c

I have been trying to wrap my brain around this for months now. I just can't figure out how to do it. I want a table with all my team's tasks. Each project has multiple assignments and each assignment has multiple tasks (usually around 10 or so). We usually enter 10 - 150 assignments at a time and they are spread out over multiple start dates. There are a couple of different assignment types and each has a different list of tasks. There's some additional data that we attach to each assignment (requirements) and tasks (expected hours to complete, etc). All of that is in various tables. Our upload spreadsheet has all the requirements, first person assigned (starting the assignment), start date, etc. What I need to do is enter, copy/paste, or upload the list of assignments and have airtable: 1) create the list of tasks for each assignment based on the assignment type1a) each task in sequence using a formula (e.g. start date + 3 work days) to create a due date1b) the ne

Hi all, I have a table with a field that is constantly updated (everytime the user clicks a button, this field stores the user email). The problem is that when a new user clicks this button the email gets replaced by the email from the user who clicked last. I would like to set up an automation so that every time this field gets update for it to copy the email to a different field where all the emails from people who have clicked gets stored.So far I created a text field which receives de email information when the user clicks the button and also created a linked field (linked to the users table) that is where I would like to have everyone who has clicked.Any tips or help will be highly appreciated. Have a great weekend everyone

Hi Everyone,I'm new to Airtable and formulas and have a pretty simple formula that is displaying a hyphen as a result of a calculation of zero, instead of the number 0. I admit I borrowed the formula originally from one I found on here, but not sure why the number I've designated isn't being displayed.It's not a true numeric calculation, but a replacement I'm using to give a numeric value to a field that also has text for ratings, i.e. 3 - Exemplary, etc., so that I can total up all the ratings from different categories and assign a value.Here's the formula:    IF( {Field1} = '0 - Deficient' , 0, IF( {Field2} = '3 - Exemplary', 3, IF( {Field3} = '2 - Accomplished', 2, IF( {Field4} = '1 - Developing', '1', 'Out of range' ) ) ) )    I personally have no idea why the formula shared was nested and if that has something to do with it, but everything else about the formula is working. It's displaying like this in the table and the interface. 

Hello Community, please help to solve in an elegant way!I have record, and in a field called "FOOD" I have text separated by comma, let's say in the text I have"FOOD" = Apple, Carrot, sausageI then have another table caleld "FOOD CATEGORIES" with all the food separated by categories like (Can be a table for each category, same situation):Apple - FRUIT Banana- FRUIT Mango- FRUIT Carrot - VEGETABLEZucchini - VEGETABLEPotato - VEGETABLESausage- MEATBeef- MEATChicken- MEATIceCream - DESSERTCheescake - DESSERTCandy - DESSERTSo now I want that in the field next to the field "FOOD" will be a field called "FOOD CATEGORIES" where it will appear the food categories according to the table classification, the previous example, I want to see CATEGORIES FRUIT, VEGETABLE, MEATAt first I tough I could do with a super concatenation of IF, but seems not very elegant approach.The real challenge is that in the field food, could be a lot of different items, so I want that the match will be d

Quick functionality question. Is there a way to highlight a set of records and make quickly assign them the same value in a given field? I.e. instead of assigning them the same value for X field independently, just highlight the records and do it with a couple of clicks?I know about the fill handle, but that isn't always practical

Hi All, I have a very simple automation to email a group of educational course participants at a scheduled time every week. All of the tests I run are successful, but the automation fails because "Google reported an error while processing this action: too many recipients." Since my automation is set up like this...trigger (at a scheduled time) > action (find records) > action (gmail: send email) ...I am trying to email the max number of records, which is 100. It's usually not a problem to email 100 people through gmail, so I'm not sure why the automation would fail. Does anyone have any advice on this? I have 700 people to email, so if I need to decrease the number of people I'm emailing, that would kind of defeat the purpose of the automation...Thank you!

Hey guys,I'm creating a competency framework.I've these tables :- Jobs (lookup to "Competencies" table)- Competencies (6000 rows) with macro-competencies in column 2 (multiselect)- Macro-Competencies (600 rows) (isolated from but not linked to "Competencies")I'd like to re-create the link/lookup between "Competencies" and "Macro-Competencies" tables. I tried to replace the multiselect field "Macro-Competencies" in "Competencies" table by a LookUp field and the replacement looks good EXCEPT when Macro-Competencies fields contains a COMMA. Then, there is an (unwanted) "auto-split".Is there a way to AVOID this split when there is a comma into the datas ? Thanks in advance !

I can't seem to get a valid access token in Airtable based on JavaScript code that works in a Google Apps Script. Here is the working code:  var clientId = '...'; var clientSecret = '...'; var url = 'https://accounts.spotify.com/api/token'; var headers = { 'Authorization': 'Basic ' + Utilities.base64Encode(clientId + ':' + clientSecret) }; var payload = { 'grant_type': 'client_credentials' }; var options = { 'method': 'post', 'headers': headers, 'payload': payload }; var response = UrlFetchApp.fetch(url, options); var accessToken = JSON.parse(response.getContentText()).access_token; This code relies on objects and methods that don't exist in Airtable's automation coding environment, namely Utilities.base64encode() and UrlFetchApp.fetch(), so I have tried rewriting the script to work in Airtable. To bypass an encoding method, I simply encoded the clientId and clientSecret manually and substituted the encoded string for Utilities.ba

The top right corner of a record's expanded view doesn't have a toggle to show revision history, as it used to - just a comment option, a link option, and the 3 "more" dots, which don't bring it up - see screenshot attached. The revision history option IS turned on (see screenshot attached of that too). How do I get that toggle switch back to see a record's revision history? Thank you!!

I keep getting to the point where I have no errors, but its still not working, I need help// Personal Access Token const token = 'pathr64Bev1PpaiJH.90e1e914f174f02f52979575ca3b30053bf32953f6727af49891b97a2a0c6f57'; // Base and Table Information const baseId = 'appNQ88GsYacjfeij'; // Your Airtable base ID const sourceTable = 'tblho4tbUAGTxgcB4'; // Replace with the source table name const destinationTable = 'tbl596fVOoOn3g2y2';// Replace with the destination table name // Fetch function for making API requests async function fetchAirtableData(url) { try { const response = await fetch(url, { headers: { Authorization: `Bearer ${token}` } }); if (!response.ok) { throw new Error(`Failed to fetch data from Airtable. Status: ${response.status} ${response.statusText}`); } return response.json(); } catch (error) { throw new Error(`Failed to fetch data from Airtable: ${error.messag

Is there an easy way (like a shortcut) to navigate to the first column of the current row in a grid view?

Hello Airtable Team.I am trying to run the following script, but it show me this error:ERRORTypeError: trackerSsot.watch is not a function at main on line 7Script:// Define the table and field namesconst tagsPods = base.getTable('TAGS TSM PODS');const trackerSsot = base.getTable('Team Tracker SSOT');const fieldToFill = tagsPods.getField('FULL NAME')// Listen for new records created in the trackerSsottrackerSsot.watch('recordCreated', async (event) => {    const newRecord = event.record;// Get the value from the new record in the trackerSsot const valueToFill = newRecord.getCellValue('FULL NAME')  // Create a new record in tagsPods and fill in the desi

I run a table that keeps track of content my team creates for a digital billboard. When we hear about new content, our project manager builds out a production schedule based on the date the content is supposed to go live on screen.To help my PM with scheduling, I used formulas to populate some milestone columns (initial concepts due, kickoff to production, multiple creative reviews, etc...) with some estimated days for each step in the process. For example: Project Kickoff should occur about a month from the start date and uses "WORKDAY({Start Date}, -33)" while the File Handoff date is only a week before launch and uses "WORKDAY({Start Date}, -5)" So far, this has worked great for providing some rough dates during the initial project planning stages, but we run into problems with our calendar when real world events force dates to change. For example: If the PM knows that a certain executive will be out of office on the formula-generated milestone date for a creative review,

I’m loving the idea of the SendGrid block, but from my experimentation, it appears emails can be sent only as plain text, which is virtually useless. SendGrid’s API makes it very easy to specify emails as HTML. Am I missing an option to send as HTML? This is the difference between a wildly useful tool and one that offers minimal utility.

Hello everyone - and Merry Christmas! So I am playing around with a table that contains several Records with dates in the future (new Records are being added from time to time). The Records will be made by colleagues in one department and then taken care of in another department. Right now I've made an Automation that sends an email to people from the other department with all the info they need from the specific Record so that they can complete the task straight from their inbox. However: I want to be sure that they actually do it; or in other words: I want to be sure that Records aren't forgotten. Is there a nice way to accomplish this? I thought of adding a Button to the email so that when my colleague in the other department finished the task, they could click on that Button and it will be registred in Airtable on the specific Record; however I don't see that's an option. I hope to find a solution in here! 

Hi all,The links to shared views (password protected) are not working as they used to; it seems users need to previously sign in or sign up for free if they want to open the URL.  Is anyone experiencing the same issue? Thanks.

I'm using the WORKDAY function and it's skipping the weekend as it should, but it always returns the previous Friday. Is there a way to have it return Friday if the date falls on a Saturday, and return Monday if it falls on Sunday?