Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,657 Topics
  • 11,709 Replies
3657 Topics
Michael_Andrew
Michael_AndrewBrainy
posted in Development & APIs
Automation Assistance - Linked Records

Hi I am trying to build an automation. When a record enters a view, I want to update another table for the linked record. For example: In Table A there is linked record to Table B. In Table A there is a field Field A. When a record enters a view in Table A, I would like to update Field B in Table B for the linked record with the data in Field A. I think I need to run a script to get the record id for the linked record because you can’t select a linked record as the Record ID in the Update Record function in an automation. I tried to just ‘Lookup’ the record ID of the linked record, but this does not seek to work either. I could use some help to get the record id of the linked record. Thoughts/assistance?

810
A
K
kxr1mNew Participant
posted in Development & APIs
Automating the QR Code Maker App

Dear airtable community, currently I’m using the “QR Code Maker” app in Airtable, which works great for me at this point. Now I want to take the next step and fully automate my process, by letting the app generate a qr code, without me manually having to confirm that procedure. As soon as a certain field is filled the qr code should be added to the chosen line. Since I couldn’t find this option straight in the app, I had a look into the automation category and noticed the custom script option. As far as I can assess this, I think that this is the best option. If there is another great solution to tackle my automated qr code creation, please be so kind and let me know, any help is highly appreciated Thanks in advance guys, take care and stay safe! Kind regards, Karim :slightly_smiling_face:

60
K
A
Ali_ShannonNew Participant
posted in Development & APIs
Custom Script for Previewing another Airtable record

Hi all! I’m looking to use the URL Preview App to preview another bases’ record. I can successfully open the source record from another base, but I’m looking to preview that view and make edits within that preview window instead of being sent to that original record in a new window. Currently it’s not working when I select the URL field, I’m met with the “No Preview” message. I believe instead of choosing the option to Preview a URL (even though that’s what I want) I would actually need to be selecting the option to Run Script - but not sure what the build is for that custom option. Any help is much appreciated! Screengrabs of what is happening vs what I’d like possible attached.

10
A
G
gtalaricoNew Participant
posted in Development & APIs
pyAirtable: a Python Api Client for the Airtable API

For any Python developers here, I wanted to share the latest release of pyAirtable, a Python Client for the Airtable API. The library was previously called airtable-python-wrapper. This new release includes many new features, including a cool orm-style class, as well as new utilities like date conversions and a few formula helpers. Feel free to message me here or open a github issue if you have any suggestions or feedback. Contributions are welcome. Repo: GitHub GitHub - gtalarico/pyairtable: Python Api Client for Airtable Python Api Client for Airtable. Contribute to gtalarico/pyairtable development by creating an account on GitHub.

1170
G
111257
111257Participating Frequently
asked in Development & APIs
Input.fileAsync force change ID to Date

Input.fileAsync force change ID to Date. //read csv let latestStock = await input.fileAsync('Please CSV', { allowedFileTypes: ['.csv'], } ); console.log(latestStock); ↑It’s true ID"0002-3". But Date format. If Do you know resolve. Please teach me.

1011
kuovonne
Kamille_Parks11
Kamille_Parks11Brainy
posted in Development & APIs
Blocks CLI beta: custom bundler & Webpack?

npm @airtable/blocks-cli Official command line tool for Airtable blocks development Does the public beta for the blocks cli allow the use of Webpack, Rollup, or another package to handle bundled CSS/JS? If so are there any examples? I have two Marketplace apps that use a package with a newer version requiring Webpack but am unsure how I could properly fold in a custom bundler, or if this is even possible yet.

103
E
P
Pulpo_LudoNew Participant
posted in Development & APIs
Integromat - search records - Arrays with multi records

I am trying to retrieve several records for which I know the ID but not the number of records: I tried to use Airtable’s search records but I don’t know how to fill in the Formula part : Can you help me ?

91
Justin_Barrett
A
Alicia_ArendsNew Participant
posted in Development & APIs
Script to log active automations?

I need to monitor the use of the “Send email” automation action for many bases and over 100 users. Is it possible to use a script to create some kind of log of active automations? Or notify when an automation sending information outside of airtable is created or used?

157
A
M
Megan_Ecclesto1Inspiring
posted in Development & APIs
Automation Scripting Error - Field cannot accept provided value

Not sure why I keep getting an error message when I try to automate this script: I just need the first 5 digits of the Project code pasted into the 5 digit (linked) column. If it doesn’t already exist, it needs to create a new record. Help?

12722
D
O
Oscar_ParsleyNew Participant
posted in Development & APIs
Setting timeout while awaiting for user input

Hello, I am wondering if there is a way to set a timeout on an await call ? Essentially I have a script where the user is asked a yes / no question, if the user says yes the script continues, if they say no the script aborts gracefully. Upon aborting two functions are run to update statuses in my tables. However if the user does nothing, the script eventually timesout and aborts, and no “shutdown” functions are run. My question is the following: can I limit the await user input call to x number of seconds, so that upon timeout I can run my functions before ending the script ? Thanks in advance ! Best, Oscar

362
D
J
Jessica_ShinParticipating Frequently
posted in Development & APIs
Multiple columns of the table to x-axis of the chart

Hi, I have a table that I put numbers to all the columns daily. And I have a problem making a chart out of this. This table represents the visitor numbers of my website daily and I want to visualize the ratio of the visitor’s age group in total. columns are /Age 13-24 / Age 25-34 / Age 35-44 / Age 45-54 / Age 55-64 … Primary row is the date. I cannot figure out how I can make x-axis in chart same as my columns and show the sum of the everyday counts as y-axis?

331
J
E
Eric_TeriiNew Participant
asked in Development & APIs
Vegalite Chart not sorting Month according to the Date col Table

Hi, any idea why is Vega-lite displaying the last month July 1 2022 of my table as the first month in my Chart, even before June 1 2021 ?!! this happen with whatever Date I start the table on. It looks like a Bug (in Vega or AT) to me, displaying the last month before the first one… Anyone facing the same issue, Thanks ! See code used { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Debug Test Chart ", "width": "container", "height": "container", "mark": "bar", "encoding": { "x": { "timeUnit": "month", "field": "DateTest", "type": "nominal", "sort": "x" }, "y": { "field": "VALUE", "type": "quantitative" }, "color": { "field": "NAME", "type": "nominal" } } }

190
E
E
Evgeny_Kapun1New Participant
posted in Development & APIs
Markdown formatting returned by API can't be reliably decoded

I am trying to read formatted text from a rich text field via API. However, sometimes different text may result in the same Markdown representation. For example, each of the following four text snippets: ~a~ ~a~ ~a~ ~a~ is represented in an API response as ~~~a~~~. Is it possible to get the contents of a rich text field that can be decoded unambiguously?

40
E
J
Justin_YorickParticipating Frequently
asked in Development & APIs
selectRecordAsync only returns record ID and Name

I am attempting to create a simple script which will count the number of entries in a linked lookup field. My plan was to invoke .selectRecordAsync() on the table of interest to pull the records and count the number of entries for a given record in that field. I’ve run into an issue early on with this script: the selectRecordAsync call appears to only be returning the name field and Id for the records, but no other data. My code is below. let vendorTable=base.getTable("Vendors"); let quoteField=base.getTable("Vendors").getField("Quoted Parts") let records= await vendorTable.selectRecordsAsync() console.log(quoteField) console.log(records) let exampleValue=records[0].getCellValue(quoteField) console.log(exampleValue) I’m getting the following responses in the console. My table is structured as follows: The only issue I can think of off hand is that all of the fields (aside from name) are linked or lookup values. What am I missing here?

1312
J
111257
111257Participating Frequently
asked in Development & APIs
How Can I delete cells-value in specific field

I wanna delete cells-value in Amount Field. I am referring to this↓ Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. but I can’t.参考にしています I wanna just all clear Amount field Value… help me. //get table let merchandiseTable = base.getTable("C_商品"); let fieldAmount = merchandiseTable.getField("amount"); let merchandises = await merchandiseTable.selectRecordsAsync(); let merchandise = merchandises.records; //console.log(merchandise); //Amaount-fields value to null while (merchandise.length > 0) { tmp

194
111257
Z
zluriNew Participant
posted in Development & APIs
Unable to get enterprise API

Hey guys. I wanted the Enterprise API and i have registered with a free account for now. But the Page says that the link says “Page not found”. Is there something i can do? or do i need to switch to the paid version to access it? Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free.

22
kuovonne
Z
Zion_BrockKnown Participant
posted in Development & APIs
Automate Population of Junction Table (with delete feature)

I have a simple script I’m trying to write, but since I’m new it’s not simple to me… LOL I have a junction table I’d like to automatically populate. In this example… I want to connect every bug with every home. So anytime a bug is added to the Bug Table, the junction table is updated to connect it with every home. Likewise, whenever a Home is created, the junction table is updated with every bug. Lastly, I want the script to clear any junction records if either a bug or home is deleted. I started with the script from this thread HERE, but just couldn’t figure out how to modify it to make it work. Lollipops for anyone who can help me! Thanks. :slightly_smiling_face:

54
C
J
Justin_YorickParticipating Frequently
posted in Development & APIs
Filter records by values in linked cell fields for Select Component

My application has several Select components which the user can use to enter information. The first two fields have only a small number of options. The third field has over 70 options and can be tedious to use. I want to use the values selected in the first two Select components to filter the available options presented to the user in the third Select. The options in the third select are pulled from records in the base. These records have linked fields. Some of these linked field values are options chosen in the previous Select components. So, lets say I want to filter returned records from a table where values in a linked field (s) match either the record ID of string value in said linked field.

92
J
A
Anbarasan_SwamiNew Participant
posted in Development & APIs
Get changed data when a record is updated using Blocks

I have an app that provides interface to add linked records. I want to prevent the users from doing the linking directly on the field. This is because the app adds the link to a view and creates backlinks in that view. when the user adds the links directly on the field, I lose the backlinks since Airtable does not allow backlinks when using views for linked records. I understand I cannot restrict permissions on that field since that disables permission for the App as well. I was able to get the changes in my app using useLoadable and useWatchable so everytime this field is updated in this particular view, i get the new queryResults. But I want to know what changed if a new link is added / deleted and if so what is the newly added link. How do I do this with blocks? Thanks in advance.

10
A
M
Margro_AdvisorsNew Participant
posted in Development & APIs
How to check if a linked record should be created vs updated?

We have a script to add a record (client login info) to a table (ComputerLogins). The script asks the user to select which client the new record is for, from a clients table, which is linked to the ComputerLogins table. They are then asked what single-select category (“Portal”) the entry should be assigned. It then creates the record. Problem is that if a record already exists with the same category, for the same client, it creates a duplicate. We’d like to check the ComputerLogins table to see if (1) the client already has a record and (2) if they do, does it have the same category that the user wants to add? If it exists, then the record should be updated, if not it should be created. I’m new to this scripting but I can do the first part and the last part, but I’m having trouble with the comparison code. I’ve tried to figure out if it’s a records query with .includes or some && condition statement or some type of getAsString to do an if A===B then update statement. I think th

73
Justin_Barrett
I
Ish_BuckinghamNew Participant
asked in Development & APIs
Scripting Advice needed

I am new to Scripting and need assistance with modifying the following Airtable Script, which is working well with the Base that I am creating. Unfortunately, I do not want the script to request user input for the number records to create; instead, I want it to use the number that is contained with in a field in the GOODS IN table. Can anyone help please? let settings = input.config({ title: 'Create child linked records', description: `For a record in a "parent" table, this script will create some number of “child” records in another table, where each “child” references the “parent” through a Linked Record field.`, items: [ input.config.table('parentTable', { label: 'GOODS IN' }), input.config.table('childTable', { label: 'LOTS IN' }), input.config.field('linkField', { parentTable: 'childTable', label: 'Linked record field', }), ], }); async function createChildrenLinkedRecords() { let { parentTable, childTable, linkField } = settings; if (

94
Alexey_Gusev
B
Brian_McEuenNew Participant
posted in Development & APIs
Appending a new item in a linked field through API

Hi All I’m building an app with Adalo using Airtable as my database. I have, as of now, 1 base with two tables, users and products. A product can have many users and a user can have many products. Obviously there is a linked field connecting Users → Products and it’s a multi-select linked field (a product can have many users). I’m trying to “add” a user or “append” a user to the user array through the airtable API (PATCH) and each time I get something to work, I can only get it to overwrite the current user in that table as opposed to adding a new user. Any thoughts on what I’m missing here? Thanks!

401
JonathanBowen
N
Noah_ColemanInspiring
posted in Development & APIs
Write in new value for single select with createRecordsAsync

Is there a way to make createRecordsAsync create a new value when it is not present in a single select field? await table.createRecordsAsync([ { fields: { 'Print Name': prnt.name, 'Printer': { name: prnt.printer }, }, } In this example, I have two fields: ‘Print Name’ is a text field and ‘Printer’ is a single select. Is there a way to pass a value to Printer that isn’t already in the base? This happens on the GUI side if you’re copying and pasting values. I’m wondering if you can do it inside a script.

535
N
J
J_MaiInspiring
asked in Development & APIs
Airtable's Create Record not working when pushed to server

Hi, my code is working locally just fine but not on the server. The code’s purpose is to create a new record is created in Airtable. When I push this code to IBM Cloud Functions, which is equivalent to AWS Lambda if folks are more familiar with AWS, the code seems to finish before Airtable’s “create record in base” function executes. A little about the code: it’s an analytics function. It will take a search term, like “dog food”, figure out all of the products tied to that search (say there are 64 products) and for each of those 64 return five different scenarios based on whether our main Airtable has that data: relevant result (in this case, 50% or 32 relevant results) not found in database (in this case 28% or 18 not found) found, but missing country (in this case 8% or 5 missing country) found, but missing manufacturer (in this case 14% or 9 missing manufacturer) edge case (in this case 0% or 0 edge cases) All code samples are below. The code is two pieces, one is a “createRecor

71
J
R
Raymond_StamperNew Participant
posted in Development & APIs
Twilio and Airtable: Need help updating a field with Airtbale Node.JS

I am wrote code (below) inside a Twilio function which utilizes the Airtable API which first looks up a record in specific table (“clients”) in an Airtable base. It then pulls field data from that record (using record.get), and then using JSON in the “Callback”, enables me to utilize that field data later on in my Studio flow. It works perfectly. What I’m trying to figure out now is how to reverse that procedure. I’d like, once again, to first find the Airtable record. But then, instead of using “record.get” to pull field data in; I would like to write/update​ fields back into that Airtable record. In other words, after the line that reads: “if (record.get(“Client_ID”) === clientnumber)” instead of the two record.get commands that pull data from the fields, what would the code be to write data (say just a literal string) back to those two fields? Thanks in advance for any help you might provide! My Function Code to Fetch Airtable Data Into My Studio Flow const airtable = require(“airt

71
J

Badge winners

Show all badges
Terms & Conditions