Development & APIs

Hi all!Is it possible to scale with airtable? I'm looking for recommendations on how to get around airtable's 5x / second limit API call limit.  Looking for a tool that can queue up the requests for me and send them through under the threshhold. I am using Zapier with airtable for a lot of automations.  I'm worried as I start adding my new clients then it will break.I've found two tools that an do this. Anyone have experience?https://nocodeapi.com/ - looks promising but customer support is atrocious.  How do I know i can trust them? Anyway their product signup doesn't even work.  Website has many problems.  Not trusting them with this important info.https://rapidapi.com/aircache/api/aircache - no experience with them. Again could work.Others?

I've run across a script in our base that uses this code:let view = await input.viewAsync("Pick a view", "Projects");Our "Project" Table has 100+ views organized by sections, is there any way to modify the code to limit the input choices to a specific view section? (screenshot: Section=Templates) if not, are there other ways to limit the input options using a view naming convention or similar? Thanks for any input, I've reviewed this documentation, but didn't find any guideance.https://airtable.com/developers/scripting/api/input  

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 !  

Hello All, I’m looking to see what my options are to create and download a csv file generated from a base, but with a very specific format. Right now I have a script that loads records from the base, creates a stringified csv document, and then saves that string into a multiline text cell in a different table. The issue is that in order to use that text, I have to copy and paste the contents of the cell into a text document, save as a csv, then open in Excel. Does anyone know of a way I could directly trigger a download of the csv, or even save it as a downloadable attachment in cell instead? Thanks!

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'; // YouTube Data API keyconst baseId = 'Airtable Base ID'; // Airtable base IDconst tableName = 'Airtable Table name'; // Airtable table nameconst recordId = 'Airtable record ID'; // Airtable record ID // Get the value of the "Video" field from the Airtable recordconst url =&nbs

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, okay maybe someone accidentally changed a field name. Double chec

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.config().recordId; const table = base.getTable('Team'); const record = await table.selectRecordAsync(recordId); if (record) { console.log(`Record name:

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 },);setTaskName('');}// check whether or not the user is allowed to create records with values in the primary field.// if not, disable the form.const isFormEna

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 created column that I moved last. Can’t say I can

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 If I try the format as suggested by @Karlstens "Updating record Linked Field with a string array" I still get the error.23    await mainTable.updateRecordAsync(record, {"Contact Name": [{id:'${returnvalue}'}]  Can anyone help. I can't work out what I'm doing wrong. Much appreciated 🙂

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": {"Content-Type" : "application/json","Authorization" : "Basic " + authKey}}let items = await remoteFetchAsync(base_url, options)// let { data } = await items.json()console.log(items)

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!