Development & APIs

I have a script that is creating (by sourcing data from airtable tabs) a large text result that I would like to store as a file attachment column in airtable. I cannot see how to take a text variable (e.g. 1000 lines of text) and turn it into an attachment in an airtable attachment column, all within a script. I would much prefer to be able to do this all from within the script, rather than POSTing the content to some file store site on the internet and then adding that URL to the attachment. thanks David

Sorry if this is a stupid question. I am trying to develop an extension and going through the getting started guide but I got stuck in the first page. The guide talks about Airtable's terminal as something obvious that everyone knows where to find it, but I can't find it anywhere! Itried to search for it, even typing it on google or searching here, but no luck. Can someone please help?

Hello, I want to access the access point https://api.airtable.com/v0/meta/whoami with my auth token as decribed in the doc but I always receive an error...This is the response received :    {"error":{"type":"NOT_FOUND"}} Someone had the same problem ?Thank you for your answer !  

I would like to create a script that creates a number of records based on a quantity field. Essentially, if there is a record that has a quantity (x) of more than 1, I want to copy and create that record x amount of times within the table, then lower the quantity for the record and each subsequent record to 1. I have some of the script set up. Are there any ideas on how I could specify the # of records to create, based on the quantity field, using createRecordsAsync in the Scripting Block? As usual, thanks for the help!

Hi, I'm trying to write a script that will extract a video link from a field, extract video details from that link, and then automatically input those details into specific fields in a table. However, the script is not functioning as intended. I would greatly appreciate it if someone could provide me with some guidance on how to fix this issue. Script:const AIRTABLE_API_KEY = 'Airtable API'; // Airtable API keyconst YOUTUBE_API_KEY = 'YouTube Data API Key

How can I change the Created by field code to tag the user when I have applied it to an Automation? Without the Automation the Created by field correctly shows the user's name, although when I apply an automation it says Created by Automation. Is there any alternative to this feature or is this inherent to the current application of the Created by field in Airtable? 

Hi guys,I'm relatively new to scripting, so I've mostly used scripts I find in this amazing community and adapted them to my tables. Once such script I've tweaked to create junction tables. It automatically creates entries in a junction table when a linked record field is updated. It has been working pretty well for a 5-6 months now, then all of a sudden earlier today, it started giving the error:ERRORTypeError: Cannot read properties of null (reading '0')at main on line 38"Usually I can figure out what is going on and fix it, but this really has me stumped. I didn't touch the script today (I'm the only one who manages them). I took a snapshot of the base from this morning and the script works in that, so I tried to copy/paste the code from that to the live version, but it still didn't work. Which lead me to believe that has something to do with a change in the base, like a changed field or table name. So I thought, ok

I want to get the available views/segment from Air table through Apiso please suggest me which plan will have this featureat this point i don't want to choose the enterprise plan

I want to help make my company better with scripts and extensions.  However, I am not fluent with Github or Javascript.I am a quick learner. I think that there are some ideas that I have that could be accomplished through extensions and scripts.   I am just wondering if anyone has some advice on how to get started?  Maybe a beginning script or extensions I can build for AirTable that would be a proper introduction to it.   I would love to create some functional buttons for my interface that link to scripts. Drew

Hi everyone! I’m happy to announce that we’ve released a new scripting API capability today, and this is available in both the Scripting App and the ‘Run a script’ Automation action. You can now select records by recordId, either by setting a new recordIds option when calling selectRecordsAsync or by using the new convenience method selectRecordAsync when you only need one record. This will be especially useful in Automations, where you can now easily select a Record based on a trigger or Find Records output. Examples: const recordIds = input.config().recordIds; const table = base.getTable('Team'); const recordsResult = await table.selectRecordsAsync({fields: table.fields, recordIds}); const records = recordsResult.records; for (const record of records) { console.log(`Record name: ${record.name}`); } and const recordId = input.conf

In the API definition for RecordQueryResult it says A RecordQueryResult represents a set of records. It’s a little bit like a one-off Airtable view: it contains a bunch of records, filtered to a useful subset of the records in the table. but in the API for Table there’s no way I see to filter when calling selectRecordsAsync(). Is there no way to query only a subset of rows in the table, i.e. the equivalent of a SQL WHERE clause? If so, what is the RecordQueryResult documentation referring to regarding ‘filtered to a useful subset’?

When sending an automation mail (using gmail or Airtable mail) how can I know if the mai was opened, resended, date opened etc Like in other email platforms like Mailchimp.

I have a multiple select field I am attempting to update within an automation, but I can’t seem to add an option to it without overwriting. Pared down, this is essentially what my code looks like right now: Val = record.getCellValue("The Cell") if(conditions met) { await table.updateRecordAsync(record.id, {"The Cell": [Val, {name: "NewVal"}]}); } And this isn’t working, as it says it can’t recognize this input type. I’ve also tried using getCellValueAsString and then passing that as another option, but that didn’t work either. Right now the code is working but is overwriting the cell value when it does, so I want to add this functionality where it doesn’t overwrite. Any help appreciated!

Hi!I'm trying to adjust the example todo-app by adding an input field when creating a new task.For example if I want to add a comment to a new task that should be created simultaneously. In my code below I get a form field to add the comment and the new task is added, but it loses the comment part somewhere on the way.Can someone help me and see where I've gone wrong?Thanks!  function AddTaskForm({ table }) {const [taskName, setTaskName] = useState('');const [commentValue, setComment] = useState('');const commentField = table.getFieldByName('Comment');function onInputChange(event) {setTaskName(event.currentTarget.value);}function onCommentChange(event) {setComment(event.currentTarget.commentValue);}function onSubmit(event) {event.preventDefault();table.createRecordAsync({'Task': taskName },{'Comment': commentValue }

Hi everyone, I used a very painfull and well known here workaround until now to update the listing of a (target) linked field depending on the selection of another linked field. But, I have a premium account and access to scripting. I wonder if it’s possible to alter a view of the target linked field with a filter based on a common field value (existing in both tables) (and maybe other things but for instance just this). I was thinking of it because we can restrict a linked field by a view. In summary, it needs: know what is the value in the first linked field get the value of the common field alter the view of the target field by filtering with the previous common field value So, is it doable with scripting ? Thanks a lot for your thoughts.

Anyone knows why this is happening in Chrome and if there is a fix? Currently using Safari for developing.

When I run block init I get the following error: Downloading template... done Extracting template... done Installing dependencies... Error › Warning: ❌ Something failed! Cleaning up... Error: Process exit with error 1 I’m using npm 8.3.1 and node v14.17.6 on Mac OS Monterey (12.5). The error doesn’t really say anything, so I’m unsure about how to continue from here. Has anyone encountered this?

Please is it possible to create a fresh base that will serve as our main client database that can sync with the marketing CRM the marketing team (GHL) uses. A very important component will be creating an internal facing and client facing dashboard for each client. There will be several components to this dashboard but among the most important is a calendar with milestones that when/if moved or changed the contingent dates change as well and the stakeholders are alerted. for example feb 1-4 is in the calendar as time allotted for "design sessions with a client" after those dates automatically there are other important milestones such as "construction document creation" which would be for example feb 6-8 and so on. if the user moves the date(s) then the subsequent dates move as well and the client and any other people (such as the designers) are notified. Please is this possible and who has an idea to go about it

When the data from the table is retrieved through the API, the field order (columns) don’t always come in in the same order that is in the view. For instance, if I have Column1, Column2, Coulmn3 in that order in the Airtable, it might come in with Column3 first, then Column1 second, and Column 2 last. I am using the standard code from the API page and this to display the results: const allRecords = records.map((record) => record.fields); console.log({ allRecords }); It appears that if I make a new table and make the fields it will work. But when the fields (columns) are modified, like change the order or delete columns or add some in, the order gets messed up.Specifying what fields to get doesn’t seem to help. I made a new table with three columns, put data in, it read it correctly. I added a 4th column, then moved it over between the 2nd and 4th columns and it still shows the original order I created the table in with the newly cr

Can you help.I need to replace a linked field with a string - both in the same table. Here's my code: The problem is on line 23. If I run it as the following it works fine. However "YSW CC2" is a text field.23        await mainTable.updateRecordAsync(record, {"YSW CC2": returnValue If I run it as the following it comes up with the error below. "Contact Name " is a linked field.23       await mainTable.updateRecordAsync(record, {"Contact Name": returnValue

Hello, anyone availeble to help with basic authentication for vidaxl api. I am trying to get products data but really struggling with the authentication // define the request urllet base_url = "https://b2b.vidaxl.com/someendpoint";let authUser = "some_email";let authPass = "some_pass";let authKey = authUser + authPasslet options = {"method": "GET","headers": {"Conte

Hi,I have an Integromat scenario in which I am pulling three of the latest airtable records (sorted by created time,  limited to 3), and I get the following output (success):Three bundles as expected, yet when I go to reference the data from these three bundles in a later module, I can only see the first. See here:How can I access the data from Bundles 2 & 3, if only data from Bundle 1 is shown?Thanks!

Hello, I’m looking to remove double line breaks in a rich text field (empty lines in the text). The substitute formula will make me lose the formatting. I tried the find and replace script to no avail. Could someone please help me ? Thanks a lot

Hello everybody,I have a table that's thousands of lines long, with a column called "Formula" which contains small string expressions like:amount = salary * 0.11;What I'm trying to do is run this string in my code, so that it updates the `amount` variable based on which line I select. However, I am running into an error when I try to run the string as code.This is my code, which is able to compile with the correct answer in other online compilers. However, when I run this in my automation script (specifically the line where I call `func()`) I receive TypeError: func is not a function.let code = "amount = salary * 0.11;";// Define the function with the desired argumentslet func = new Function('salary', code

Hello,I have 4 columns setup. Date Opened - is a created time field, logs when an entry is createdTime Opened - is a formula field with the following:  TONOW({Date Opened}) - Simply logs in minutes (will likely change to hours) how long an entry has been opened for.Done - Simple checkmark boxDate Closed - Is a formula Field with the following: IF(Done = 1, LAST_MODIFIED_TIME(Done)) - simply logs the time an entry is marked as Done with a checkmark.My current issue is, I'd like Time Opened to stop counting as soon as Done is checked and I cant quite figure out how to do this. Does anyone have any pointers?Thanks!