Solved

HelloI've been working on a script all day in the Script Extension thing, and it's been working fine until just now when I went through to comment out my console logs I was debugging with to tidy up the code. I went to run the script one last time and now all I get is the "An error has occurred" popup telling me to refresh the page (which doesn't help).Any ideas what causes this or how to fix it? Really need to have this working! 

Hello there,I have a base where we are taking job hours and rolling up all the hours into monthly payroll. I attached screenshots of the sample base.Basically, I am trying to create an animation where if {Payroll Link} is empty, then copy and paste  {Payroll Link Calculation} into the linked field. If that record doesn't already exist in the Payroll table already, then create a new record, and just like before, update the {Payroll Link} link with {Payroll Link Calculation}.I've tried multiple versions of this automation and keep getting stuck. Please let me know if I need to provide more information on the base's structure. Thank you in advance for any help!

Hello,We are trying to create a base that allows us to track our workers' capacities (we called them Dimensions: skills, tools, languages, seniority level...), manage project requests and show matching workers for each request. For that, we have created a table for each dimension we want to track in workers (one table for skills, another for tools, another for languages, another for seniority level, etc.).Then, we have a table for workers, where we add every worker and select their dimensions in fields linked to the previous tables. Some dimensions have a 1-to-many relation with workers (for instance, a worker can only have one seniority level, but several workers can have the same seniority level). Other dimensions have a many-to-many relation with workers (for instance, a worker can be proficient with more than one tool, and several workers can be proficient with the same tool). And then, we have another table for requests. In this table, we have several fields linked with

I have granted external 3rd party apps access to a base for testing purposes. How can I remove this access again?

I am really struggling to do something as simple as "clear" a records linked field value.I have tried... table.updateRecordAsync(r, { "Linked Field": [{id :''}]}); table.updateRecordAsync(r, { "Linked Field": [{id :null}]}); table.updateRecordAsync(r, { "Linked Field": []});If anyone can let me know how to clear a records linked field that would be amazing.Thanks

I have an automation that handles bulk uploaded PDF-files, with logic that extracts an ID-number and date from the filename. It then copies the attachment to a record with matching ID in another table. It also checks a checkbox on the original record of the uploaded PDF to mark it as complete and avoid multiple runs.The automation runs fine, with just one weird "bug": The filename of the copied attachment changes to a random string "XxxxXxxxXXXx". However, if I now delete the copied attachment and go back to the uploaded file record and uncheck the "completed" checkbox to trigger the automation again, the file is copied with its original filename kept!I suspect the reason is related to the automation starting to work before the file has been fully processed by Airtable, and some kind of temporary name is used. But this is also contradicted by the fact that the automation relies on data from the filename to be extracted before it can run...My first idea was to add a delay to the automat

Good day team,  I would like to ask let's say for example I have these email addresses and I want to use a formula to get "ABC" to "ABC Company Philippines." What would be the correct formula?For your reference, this is the formula that I am using right now. IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="abc", "abc company Philippines",IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="bcd","bcd",IF(RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email})))="cde","cde", RIGHT({Email},LEN({Email})-FIND(".",{Email},FIND("@",{Email}))))))

Seems like an easy automation - would love some help! I would like to send a notification when a status field changes - whenever it changes regardless of the status.  There is no option for "when" a status changes. I am sure someone out here in this amazing community has done this. Would love some direction, thanks!

Hi everyone,I am trying to insert in a single select field which has options "true" and "false" (without quotes) a data coming from an application through a webhook which is either "true" or "false" (also without quotes).Unfortunately, when trying to do so, I get an error 422 "Cannot parse value for field blabla".Is there an incompatibility between the values true and false and a single select field ?Shall I add quotes in the original data so it can be inserted into a single select field ?Thanks in advance for your help,Gilles

I recently built new features into my project tracking base using Timeline view and WORKDAY calculation. In both cases the ability to include holiday dates is very useful. However I quickly found two cumbersome things about using this:I need to configure the list of dates separately in each place I use them, and since this quickly got employed in a few timeline views and a couple workday calculations there are now over a half dozen places where I need to make a change when adding a new holiday date.I am using two separate lists of holiday dates - sometimes I only put in standard US holidays for client facing views, whereas in other places I also include my own planned days off for internal capacity planning.What would really help would be a feature where I could define lists of dates, then use the list references in my timeline views and workday calcs.Thanks for considering it.

Hello Everyone,Is there a formula for multiple values I set to equal "Success"? ( put several values like "1234" which would be equal to "Success") please thank you in advance,Best regards,

Hi, I am trying to patch multiple records to airtable using Nest.js. I've checked:- url should be correct: https://api.airtable.com/v0/${baseId}/${tableId}- headers with authorized token:    const headers = {      Authorization: `Bearer ${token}`,      'Content-Type': 'application/json',      accept: 'application/json',    };- body is stringified with records array limited to 10:    const body = JSON.stringify({      records: records,      typecast: true,    });my records look like:records:[{ id: 'recyhk6cWWQcVrG9s', createdTime: '2023-01-09T07:07:16.000Z', fields: { 'Code Specs': 'window.datalayer.push({\n' + ' "event": "select_content",\n' + ' "shipping_method": "${shipping_method}",\n' + ' "payment_method": "${payment_method}"\n' + '})', 'Code Spec Match': 'false', Platform: [Array], 'GTM trigger method': 'Datalayer', 'Event Name': [Ar

Hello!I'm using a daily "find records" automation to send out digest emails to my team. I display the records in a list or grid in the email, including their Start and End fields (the records are tasks).In my base, I've formatted both the Start and End fields to display in the same timezone (EST) for all collaborators. However, in my automation, the timezone is displayed in UTC, and I don't see a way to edit it. Is there a way to ensure that the date/time in the "find records" automation matches what is in my base? Thank you in advance!

I have an automation that moves information from one table to another when a date field is entered. The problem is that the date field also has a time associated to it which is an important part of the dataset. The automation fires right as you click a day without allowing time to be entered accurately. Is there a way to only have the automation fire when a time is inputed as well?

Hello, I am relatively new to Airtable and I am having difficulty creating a simple clustered bar chart in the chart block. In excel my table and chart looks like this… Any suggestions?

I'm setting up a project management system. Many, not all, of the tasks will have an assignee who completes the task and an approver who checks and approves the work. Is it best to set the task up as 1) one task with one 'assignee' field and one 'approver' field; 2) one task with two assignees in the same field; 3) two tasks...one as for doing the task and one for checking/approving the task. Maybe there are other options I've not considered. Thanks for your advice!

Hi!I'm trying to create an automation where, when a record is created in one table, a record is created in another. I want one field's data to populate from the first table into the primary field in the second. The automation to create the record is working great, but I'm having trouble populating the primary field. I've tried a variety of combinations of actions, and it works in preview, but when activated, does not work.This is the automation in preview. You can see that the "Name" field is populated (primary field).However, in once it's in place, the "Name" field (primary field) does not populate.The current version of my automation has two actions:* create record* update recordThan

I'm pretty sure I'm over thinking this process so I apologize in advance if this is obvious to most.I have a field in Table 1 which when data is entered, I'd like that data to automatically create a new record in the primary column of Table 2.Table 1 is my ideas bank and when I have created a  "Working Title" (field name in Table 1) for that idea, I'd like the title to be automatically added to Primary Column in Table 2, thus creating a new record.Really hope this makes sense.Any help appreciated.

I’m trying to script some record creation right now and it involves populating a multi-select field, but for some reason I’m unable to make this updating work no matter how I try. I know that a multiple select field needs to be updated with array values only, so this is what I’ve attempted: var book_arr = []; book_arr.push(book_num); await new_table.updateRecordAsync(newRecord, {'Book Number':book_arr}); where book_num is a single value that I know is already a valid option for the multi-select. I also tried to pass it directly when creating the record as just 'Book Number':[book_num], but no dice there either. I don’t see anything in the API documentation about updating the value of a multi-select field, only updating the options, so not sure where to turn here.

I have a field that has stuff in it like this" 2023-02-09 Jeff Alexander Website"I'm using a formula to extract the date and the name so then I have fields that look like" 2023-02-09" and "Jeff Alexander Website"I want to make a calendar view of this table. It's asking for a date field. Even though i have a field that isolates the date ( 2023-02-09 ) it isn't a field type of date, so airtable doesn't recognize it. my thinking is that i need a date field and i need to autopopulate it and i don't know how. I'm open to other ideas for how to put " 2023-02-09 Jeff Alexander Website" into a calendar view

Hello, maybe this is not even possible, but if it is, what would be the proper syntax for this ?IF(VALUE({Total Rate 6})) >0, VALUE({Total Rate 6}), Blank() This field is showing the data of another column called "Total Rate 6", but i want it to be blank if the amount is 0(zero)

Context: I have two tables, Shots and Videos (with links between). It's possible one shot may be used in more than one video. I will export shots through a CSV into an InDesign template using data merge (Page Builder won't work for other reasons).Problem: I'm trying to specify a chronological order for the shots to appear.Ideas that won't work/aren't ideal:I could just drag them around into the right order, but since one shot may go into multiple videos, the order may vary by video.I could rearrange order of linked shots from Video table side, but that won't work the the CSV export to InDesign.I could do a single select list of numbers, but that won't work since each shot may have a different number for each video it's in.Any other ideas? 

Hi everyone, I'm trying to get this formular to work, and although it parses there's no output.   ARRAYJOIN(ARRAYCOMPACT(Field1,Field2,Field3,Field4), ", ")  The fields are a mix of and link-to-another-record fields lookups (of link-to-another-record fields) where the outputs all are fine. The reason why I'm using an ARRAYCOMPACT as well is because half of the fields are usually empty.Thank you very much ❤️

I know this is super simple, but I am new to formulas. Here's my problem:I have volunteers signing up for a rotation and I'm trying to make a view that will capture their hotel needs, which are generally: Check In one day BEFORE their First Day BOG and Check Out one day AFTER their Last Day BOG (BOG = Boots on the Ground).This is the formula I am using to get their Check In date: DATEADD({First Day BOG},-1,'days')It is not calculating correctly.This is the formula I am using to get their Check Out date: DATEADD({Last Day BOG},1,'days')Also not calculating correctly. Help & TIA

Hello,I'm using this running total script which works great but I want to add another running total column based on another field to this. Any solutions on how to add another running total in the same script?The table and view are the sameThe fields would be different (Field Pillar & Domain is the same but instead of Q2 Demand it would be Q3 Demand)The sort would be the sameRunning total field would be Q3 Running Demand let table = base.getTable('Resource Capacity Planning'); let view = table.getView('Capacity Planning Include Only'); let result = await view.selectRecordsAsync({ fields: ['Pillar & Domain','Q2 Demand'], sorts: [ {field: 'Pillar & Domain'}, {field: "Stack Rank"}]}); let runningTotal = 0; let currentGrouping=''; for (let record of result.records) { if (currentGrouping !=record.getCellValueAsString('Pillar & Domain')) { currentGrouping=record.getCellValueAsString('Pillar & Domain'); runningTotal = 0 } runningTotal += record.getCel