Development & APIs | Airtable Community

Resolved! Multiple fields in script config

I am new to scripting & know that I dont know exactly what I am doing however I like to learn & am kind of learning on the job taking it 1 step at a time.When creating a script the following code will allow the user to choose which table & field they...

43 Views
4 replies
0 kudos

How do I create a new field under the view and patch data to it

Hi,I am building an application to get data from a view and attempting to patch it back to the view. However, I haven't found any endpoints to do it. First, I want to check whether the view has a field. If it doesn't, I shall create a new field and p...

5 Views
0 replies
0 kudos

Integration of Zoho Form with Airtable and Softr

Good day Airtable Community,I would need your assistance on this matter.I have clients who would accomplish a certain form done via Zoho, and I wonder if I can show if client has completed the online form via Airtable and Softr?Thanks

20 Views
1 replies
0 kudos

Airtable to Bubble

Hi everyone,I currently use Airtable as my backend and bubble as my web application interface.There is a plugin on Bubble to synchronize data from Bubble to Airtable quite easily through the API.But I saw that API keys will be replaced by tokens star...

36 Views
0 replies
0 kudos

AirTable Webhook Payload Retrieval

I am currently working with the Webhooks notifications (https://airtable.com/developers/web/api/webhooks-overview) to process record updates when a set of files/fields have changed. While I love the power and flexibility of the notification, especial...

35 Views
0 replies
0 kudos

Filter RecordQueryResult by field

Is there a way to filter RecordQueryResult by a checkbox field; let's say I want all records where the value is False? let query = await table.selectRecordsAsync({ fields: [uniqueIdField, dateDueField, projectField, waiveRushField, comparisonFie...

25 Views
1 replies
0 kudos

typecast parameter

Hi,I am working on a project requiring syncing complex data to Airtable. After having errors due to some columns containing json data (working on a Python script), I switched my API queries to typecast=true which solved my issue (json data is convert...

59 Views
0 replies
0 kudos

Resolved! How do I get the workspace id via Web api

56 Views
1 replies
0 kudos

Resolved! Is it possible to use Ajax in an Airtable script?

I want to make an automation that runs a script, and in that script I'd like to call an ajax function (either with jQuery somehow or with XMLHttpRequest() etc.) to grab some external data from a Google calendar. Is this possible? I've searched around...

93 Views
6 replies
0 kudos

Download attachments and keeping the original file name

Good day,I would like to download attachments via a link keeping the original file name. I managed so far to upload a document with the correct file name but the issue is that when downloading in another page it becomes a new generic names for all fi...

66 Views
1 replies
0 kudos

Duplicate Base via new API

Admittedly, I'm super new APIs in general, and I'm using ChatGPT to generate the code. So, if you're looking at it and you're like 'you and chatbot are wrong about everything and this can't be done', please let me know.Here is my use case:Imagine I a...

62 Views
2 replies
0 kudos

Resolved! Where are the authorize url, access token and refresh token urls?

61 Views
1 replies
0 kudos

Button that runs a script to generate a random string

I'm not familiar with Javascript.Looking to make a button that will start a script to generate an alphanumeric string that's 8 characters long. The code I found on Google to generate a string is:function makeid(length) { var result = '...

23 Views
1 replies
0 kudos

API: Get workspace collaborators

Hi there, is there a way to get the list of workspace collaborators without having an Enterprise subscription? Just getting their name, photo and id

123 Views
2 replies
0 kudos

Anyone using the Cdata Excel Add-in?

Hello, I represent a manufacturer who makes custom objects. We use Airtable to manage our sales leads. We've developed a macro spreadsheet in excel to provide pricing in the way we need to. I'm considering a new workflow which allows customer to uplo...

39 Views
0 replies
0 kudos

TypeError: Cannot read properties of undefined (reading 'getCellValue')

Hi all!I'm very new to scripting and I have this code that was working before until recently. When I run the code I see TypeError: Cannot read properties of undefined (reading 'getCellValue') at main on line 271Line 271 is let client_apps = glo...

84 Views
1 replies
0 kudos

How to use await fetch to populate a field for API requests with bearer token?

Hi guys and gals I am a newbie to Airtable, can someone help me out with the script and automation?I want to populate two fields in the column Notes and Points with the data returning from a web API call using bearer token authorization, but I also n...

103 Views
2 replies
0 kudos

OAuth2 : Problem with /token request

Hello,I created Oauth2 integrations on your website, and now I do the authentication request and then the token creation request, like described on your doc.The problem is that I can get the access token, but it doesn't work every time, it seems tha...

183 Views
3 replies
0 kudos

Resolved! Using javascript to insert multiple select values into a new record

Hello,I am setting up a record to duplicate a record (but only certain fields) in a base by taking input variables and then creating a new record and inputting these into the new record as suchlet recordIdNew = await table.createRecordAsync({ "Dat...

244 Views
11 replies
0 kudos

client web page search

Hi,Looking to have a simple web page with one search field and a button. This web page for the clients, so they can enter their Customer ID, click the button, then a connected epson printer will print the order info based on sortable data. The amoun...

53 Views
0 replies
0 kudos