Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,656 Topics
  • 11,709 Replies
3656 Topics
P
Philip_LangdaleNew Participant
posted in Development & APIs
New Scripting API calls: Selecting records by recordId

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:

14713
Karlstens
R
Rory_KinganNew Participant
posted in Development & APIs
How to query a table ... or do I always have to process all records?

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’?

19228
Karlstens
J
Jorge1New Participant
posted in Development & APIs
Mail followup

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.

10
J
A
Alyssa_BuchthalInspiring
asked in Development & APIs
How to update a multiple select field without overwriting?

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!

884
A
B
Bokning_SoundLeNew Participant
posted in Development & APIs
input to more fields in todo-app

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

30
B
V
Valentin_GUENICInspiring
posted in Development & APIs
Wondering if this is possible

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.

1310
V
Rupert_Hoffsch1
Rupert_Hoffsch1Brainy
posted in Development & APIs
Chromium issue: Can't connect to your local extension

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

296
Rupert_Hoffsch1
F
Fernando_TorreNew Participant
posted in Development & APIs
Cannot init Hello World example extension

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?

11
N
A
Airtablenewbie1New Participant
posted in Development & APIs
PLEASE I NEED HELP

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

11
WilliamPorter
R
Russell_BornNew Participant
posted in Development & APIs
Colums out of order

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

329
A
R
Rob_DixonNew Participant
posted in Development & APIs
Airtable Script to update a linked field with a string

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 🙂

163
Matthew_Carrano
S
seidumohammed64New Participant
posted in Development & APIs
Basic authentication for vidaxl api

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)

42
S
O
olivedrabNew Participant
posted in Development & APIs
[Make/Integromat] Search Records module returns multiple bundles, but I can only link to one?

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!

435
O
J
Joachim_BrindeaInspiring
posted in Development & APIs
Removing double line breaks in rich text

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

121
J
C
coltsh3lbyNew Participant
posted in Development & APIs
Automation Scripting – TypeError when executing code from a string.

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);// Call the function with the desired argument valuesfunc(50000);console.log(amount);I've tried using `eval()` to run this (I know it is not best practice) but similarly received the error ReferenceError: eval is not defined. There has to be some way to get this code

285
C
O
OvertypedNew Participant
asked in Development & APIs
How to stop TONOW() from updating

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!

110
kuovonne
B
BionicAlmogNew Participant
asked in Development & APIs
Error when trying to create new select option in SingleSelect field via API

Hi,I'm working with the API, and when trying to create or update a SingleSelect field with a new select option, which was not exist, I get the following error:{"error":{"type":"INVALID_MULTIPLE_CHOICE_OPTIONS","message":"Insufficient permissions to create new select option \\"\\"v0.65.1\\"\\""}}%I set my personal API key with all of the available permission, i tried editing the field's permissions and set it with:* Allow this field to be set in records created through forms* Allow this field to be modified by automationsbut it didn't work.I didn't find anything useful in the API docs. Can anyone help? 

6823
Andrey_Kovalev
H
hcobasNew Participant
posted in Development & APIs
Problem with POST to create a new record in airtable

Hello, I´m new using airtable.I´m developing a Labview-based software for reading information from airtable and writing information to airtable. I have no problem with reading from airtable. I´m using the functions in labview for inserting the headers with Authorization, then I encode the URL for retrieving the information I want, and use the Get function. This point has no problem.The problem is that I´m not being able to create a new record in the table. Basically, I´m following the same flow as before. I´m inserting the header with the Authorization, then I´m generating the URL with the Base ID  and the Table name, then I´m using the function POST which has as inputs the URL and the data to send to the airtable.The data I´m sending is this one:{"fields":{"Test Number":67,"CH - Pass / Fail":"Pass"}} As answer I receive the following header:HTTP/1.1 422 Unprocessable EntityDate: Sat, 24 Dec 2022 10:32:17 GMTContent-Type: application/json; charset=utf-8Content-Length: 12

831
H
J
JoJoNew Participant
posted in Development & APIs
Looking for design review of app architecture from a senior engineer at Airtable....

I'm working on an extension that will use iframes to load parts of the app. While iframes aren't forbidden by the extension guidelines, I'd like to get confirmation from a senior Airtable engineer before starting to work on this architecture -- it's going to be a considerable time and effort to build! I have a design doc I can share to give a full sense of how it will work. Does anyone know how I can reach someone at Airtable to review my design? Thanks.

73
kuovonne
K
Karen_ReittingeNew Participant
posted in Development & APIs
Need Assistance Creating a Script for Updating Records from Form

I have no experience creating scripts and am looking for some assistance to create one for my base. I thought that I could just utilize automations to update records but I have had no luck getting those to work properly and after searching through this forum I believe a script is necessary to do what I need. I have a Daily Fieldwork form that our employees fill out each time they go to install, remove, or service some equipment. If they are installing something new they fill out the form for an "install" and it triggers an automation that successfully creates a new record in another table called "Seismographs/Instrumentation".If they fill out the Daily Fieldwork form for anything other than a new install, they select the equipment number or "JID" that is associated with the equipment that has already been entered into the "Seismographs/Instrumentation" table and they update the information associated with that JID. I cannot figure out how to have multiple fields updated from the D

22
K
S
Sal_SuissaInspiring
posted in Development & APIs
Custom Airtable Block: Shippo API To Track UPS,FedEx and USPS Parcels On Airtable

Hello I am looking to create a custom Airtable Block that can track a list of tracking numbers in a column and return all of the shipments status in other mapped columns (Location, Destination, Last event, arrival date etc) I think the best way would be to create a custom block connected to the Shippo API, but I am open to suggestions. I am OK to host if needed. Please let me know how you would do this, your best price, and when can this be completed by. About Me: Hello! I am Sal, a big Airtable x Zoho fan. I am looking to develop a relationship with a developer to help me with automation set up in Airtable and Zoho — I often come up with ideas, and looking for someone to execute.

463
D
Andy_Cloke
Andy_ClokeKnown Participant
posted in Development & APIs
How to store sensitive API keys that the user has entered?

Based on the advise here, I’m going to ask the user to enter an license/API key in order to prove they have subscription. My block might also need to store sensitive keys for other APIs. Where should I store these sensitive keys? This guide says it shouldn’t go in GlobalConfig. This answer says it should be an environment variable, but I want to enable non techincal users to install my block, so that doesnt feel like an option.

223
W
K
kaspar_bossersNew Participant
asked in Development & APIs
Trying to split records with multiple attachments in a field into a new table with records with single attachments

and failing, to be honest. Please take note that I have no idea what I’m doing and this script is pieced together from snippets and posts I found on the forum. This is what i have until now. I’ve tried multiple variations but I haven’t been able to write to a new attachment field correctly. //script settings let settings = input.config({ title: 'Create individual records from multiple attachments in a single attachment field', description: 'Creates 1 individual record in another table for each attachment in a multiple attachment field in the source table, and links the new records back to the source record.', items: [ // Source table select input.config.table('tableSource', { label: 'Table with existing attachments' }), // Source table: Attachment field input.config.field('attachField', { parentTable: 'tableSource', label: 'Attachment field with multiple attachments to split', }), //

374
K
A
Aditya_JawadeNew Participant
posted in Development & APIs
API Enpoint to list all bases for an api key?

Is there an endpoint to list all the bases for an api key, zapier is able to do it in their app, but i couldn’t find anything related to this in the standard api documentation ?

2113
S
N
neno108New Participant
posted in Development & APIs
how to get row by email?

i'm trying with Postman, i don't understand how to find the email in a table of users and get the user data?it can be done?

31
TheTimeSavingCo

Badge winners

Show all badges
Terms & Conditions