Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,660 Topics
  • 11,732 Replies
3660 Topics
F
fieldNew Participant
posted in Development & APIs
Change table field order

Using the Airtable API, how do I change the order the fields of a table are displayed in?

41
TheTimeSavingCo
K
k6noNew Participant
posted in Development & APIs
Linked records in API call

Hello,I'm trying to run a script from BaseA to create a new record in BaseB. The new record in BaseB has a linked field, I followed this convention to reference it: Field_Name: [{id: record_id}]. I get INVALID_RECORD_ID error, though I've double-checked it and the record id is correct. What am I doing wrong? let createRecordInBaseB = await fetch( `https://api.airtable.com/v0/${targetBaseId}/${targetTableId}`, { method: "POST", headers: { Authorization: `Bearer ${baseARecord.pat}`, "Content-Type": "application/json", }, body: JSON.stringify({ fields: { "👀 Projects": [{id: projectRecordId}], }, }), } );   

1352
K
G
George_NelsonNew Participant
posted in Development & APIs
Left Join / Lookup

Hello, I’m trying to understand the AT API when it comes to getting the values of a linked table. For example, in Table one I have the following fields: ID Entity Name List of Part IDs In Table 2 I have the following fields: ID Part Number Part Name So when I create the URL to pull the values in Table 1, how do I “lookup” and show the Part Number and Part Name from Table 2 for each Part ID in Table 1? I’m new to Airtable, and have spent hours and hours trying to figure this out, but so far have been unsuccessful. All help will be greatly appreciated. Thanks, George

653
djseeds
Y
Yerko_BegicInspiring
posted in Development & APIs
Power BI Integration errors

I am struggling to connect Airtable to PowerBI and was wondering if anyone was able to accomplish this?Here are my steps following the write-up from here: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable SupportOpen Blank Report in PowerBISelect Get Data > Blank queryFrom Home Tab click on Manage Parameters > New Parameter.Add the NameType > Select TextSuggested Value > Any ValueCurrent Value > Enter Token ID      This is done for PERSONAL_ACCESS_TOKEN, BASE_ID and TABLE_IDPlease note, TABLE_ID was taken from the URL as marked in red belowClick On Query1 as shown above, click on Advanced Editor and delete a few default lines.From the Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support, copy M Query, paste it into Query1, and select Done. At this point, I am prompted to Authenticate:On Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support page, it is suggested to use A

282
djseeds
T
Tim_ArnoldNew Participant
posted in Development & APIs
Create multiple select option if doesn't exist

Is there a way to create a multiple select options via scripting blocks? I would have though if you set a field to a new option that doesn’t exist it would create it but doesn’t seem to be the case

6610
M
N
Ni0323New Participant
posted in Development & APIs
URL fields returned "INVALID_VALUE_FOR_COLUMN” error

Hi there.Can you help us solve this issue?After generating the GoogleDrive URL in GAS, we update certain fields in airtable API.The field type is “URL”.The code is below. I have already confirmed that the API URL, PAT, GoogleDrive URL and field name I am calling are correct. const drive_url = "https://drive.google.com/drive/folders/" + folder.getId(); const url = "https://api.airtable.com/v0/XXX(appID)/XXX(TableName)/XXX(recordId)" const options = { 'method': 'PATCH', 'headers': { 'Authorization': 'Bearer ' + "XXX", 'Content-Type': 'application/json', }, 'payload': JSON.stringify({ 'fields': { 'Field1': drive_url, } }) }; const response = UrlFetchApp.fetch(url, options);Then the following error is returned. {“type”: “INVALID_VALUE_FOR_COLUMN”, “message”: “Field \”Field1\“ cannot accept a value because the field is computed”}}However, the field type of Field1 is "URL", as mentioned above. It is not a calculated field.Why doe

115
TheTimeSavingCo
E
Eliran_AlfasiNew Participant
posted in Development & APIs
Upload multiple files to the same field with Integromat

Hi Airtable team, I am trying to upload more than 1 file with Integromat iterator and the logic works but Airtable “kiils” the last action and uploading only 1 file. How can i use Integromat and arrays to upload multiple files to the same field without deleting the previous ones? Thanks!

283
I
N
Nirbhay29New Participant
posted in Development & APIs
Search for the record with the given unique

i have this piece of codetry: # Step 1: Search for the record with the given unique ID print("stage 1") search_url = f'{url}?filterByFormula={{Part unique No 1}}="unique_id"' print("stage 2") search_response = requests.get(search_url, headers=headers) print(search_response) if search_response.status_code == 200: search_result = search_response.json() if search_result['records']: # Step 2: If record is found, extract the record ID and existing quantity record_id = search_result['records'][0]['id'] existing_fields = search_result['records'][0]['fields'] existing_quantity = existing_fields.get('Quantity', 0) # Step 3: Add the new quantity to the existing quantity updated_quantity = existing_quantity + int(new_quantity) # Step 4: Prepare the data for the update update_data = { "fields": { "Quantity": updated_quantity,

81
dilipborad
T
Tom_BeckenhamNew Participant
posted in Development & APIs
Email automation - threading

I'm working with a client who has a seemingly simple requirement:"Send an email using Airtable data, then later reply to that email to chase the recipient - ensuring that the reply is in the same thread as the original"This is deceptively difficult to achieve from Airtable, and I wanted to ask the community if they've found a great solution.Here's a breakdown of the the problem:Replying - Email clients require the in-reply-to and references headers to contain the Message-Id of the email being replied to in addition to the subject being prefixed with "Re: "Nothing returns the Message-Id - The built in Airtable and Gmail automation actions do not return the message id of the email just sent - nor do they allow you to set the in-reply-to or references headers when sending an email. I looked at Zapier, Make.com, Gumloop. I couldn't find an off the shelf solution that did both thingsGmail API requires Oauth - I looked at connecting directly to the Gmail API in an airtable automati

1601
Sachin_191
E
Edgar_CalderonNew Participant
posted in Development & APIs
API Get only the options of field(column) type multiple select (array of string)

Hello everybody!!! I’m new in the comunity of Airtable, since last Monday, Im working with the API, now I need some help, this is the think: I have a table with a field of type multiple select(array of string) and need to get only all the options (values) configured of this field, not the values select by the user. please help, some real values are: [ “Planning”, “Work-in-progress”, “Approved”, “Completed”, “1. Fields Status Value Text”, “Otro”, “Testing1” ] and are all this values that I need get to my code. See you…

195
W
H
Hannah_BeekmanNew Participant
asked in Development & APIs
Script - multiple select update error

Could someone share the correct way to update a multiple select field using a script?I have one table where I receive data from form submissions. When a submission is received, I use data from the submission to update a multiple select field in a record in another table. When I manually type my field update, as below, the script accepts the value: await table.updateRecordAsync(id,{ 'Multiple Select Field': [{ name:example1 }, { name: example2 }] })However, when I use JSON.parse() to create an array of objects with name keys and values using my submission data I receive a 'cannot accept provided value' error://My raw data is brought into an automation script as an input. Here is an example of the format: let rawData = ["example1", "example2"] //Here, I convert my rawData into objects with keys and values let data = rawData.map(datum => JSON.parse(JSON.parse('{ "name":"'+datum+'" }')); //Here, I attempt to update my table using the parsed data await table.updateRe

200
H
D
Doug_GrauelParticipating Frequently
posted in Development & APIs
Modify AT "find & replace" script to "find & extract & paste"?

There's an AT script called "find & replace."  That's great - but how about if instead I find a string of text in a field, copy what follows up until a find another string of text (/BeginAddress Name, Street, City, Zip /EndAddress), then paste that stuff into a different field?  The point is to take an email before forwarding it into AT, place /BeginWhatever at the front of what you want to copy, place /EndWhatever at the end of it, then when the new record is created in AT, have an automation run that script to grab what's between the "markers," and paste it into another field in that or a different table - like "Address" for example.  So, for example, I can mark an address anywhere in an email chain, forward it into AT, and have the script extract what I really want from it and put it where I want it to go.  And then maybe delete that forwarded email.I want to think that the "find & replace" script could easily be modified to "find, copy, and pas

32
kuovonne
S
Shmuel_PreiszleNew Participant
asked in Development & APIs
Validating end-user input values

I’m new to Airtable, and have been browsing the help center and playing around with the features. One thing I didn’t see mentioned anywhere was input validation. For instance, for a numeric field requiring the value to be less than, greater than, or between values-- as an age field which must be 21 or greater. Or a date field which must not be a future date. Or a currency field limited to 10000. An so on. How would these be done in Airtable ?

1000
Q
T
tasty213Participating Frequently
asked in Development & APIs
Loading bar for scripts

Hi, I have some scripts that do data-validation over all the records in a view before moving them into a new view. Would it be possible to display a progress bar in the scripting app to indicate how long a process should take. Thanks in advance :slightly_smiling_face:

182
Q
N
newbie1New Participant
posted in Development & APIs
Looking for a UK based Airtable developer for creating integrations and setting the whole thing up

Want to:- Store a database of suppliers and their training records- Log their training and assessments- Create certificates- Create external views for assessors to update training records

92
Sachin_191
Ben_Crouch
Ben_CrouchKnown Participant
posted in Development & APIs
Populate page title of a url

I’m not sure if this would be a script, but I have a table full of URLs and I want to query the ‘page title’ for that URL and return it to populate in another field ‘Page title’. Does anyone know if this is possible and if so what script I should run? Thanks

181
M
M
Marcel_TanbicNew Participant
posted in Development & APIs
Is Web Scraping in Airtable possible?

Hey guys, is there any way to Web Scrape Data from Websites into Airtable? It’s actually just a single row I need. Best regards

39813
GavinA
auekk2787
auekk2787Inspiring
asked in Development & APIs
trigger Power Automate with Airtable

I have an automation that runs a script to trigger a webhook in Power Automate.  This correctly pushes the Expiring URL to Flow.My next step however doesn't work. PA seems to want a filename in the path URL. Airtable doesn't generate the URL like that.Is there a way to reformat the expiring URL to have a ".jpg" at the end? 

1662
auekk2787
S
SQLify_FloNew Participant
posted in Development & APIs
Query your airtable base thanks to SQL

Do you ever wanted to query your airtable in SQL with no sync ? Now it is possible thanks to SQLify. Connect your airtable account, use SQL to query and create a PostgreSQL compatible DB. Would be happy to have your feedback, we are still in beta 🙂 

70
S
ss22
ss22New Participant
asked in Development & APIs
Custom Script within Automation

I'm trying to build an automation that uses a custom script to determine whether all necessary leads have been assigned to a record within the base. The teamsNeeded field (multiple select field type) determines the teams that need leads on the record. Each team then has a lead field (single select field type) where the lead is selected. If "Comms" and "KM" are selected in the teamsNeeded field then the "Comms Lead" and "KM Lead" field need to have a selection/not be empty.I have limited scripting experience but have been able to build the one below. The issue is that it is outputting 'All Leads Assigned' even when leads are missing. The console log for teamsNeeded shows that all teams are being captured - the log for the example with "Comms" and "KM" in the teamsNeeded field reads "teamsNeeded (2) ["Comms", "KM"].Is there something I am missing that is causing the output to always be 'All Leads Assigned' instead of 'Leads Missing' when leads are missing?  // Get values from t

144
ss22
K
Karan_SetiaNew Participant
asked in Development & APIs
Search Whole Workspace using API

Hello there, I was wondering if it is possible to search a whole workspace using the Airtable API. The reason I need this is below: I have 5 x bases full of LinkedIn profile IDs all with the identical base structure and column headers Using the API I want to search across all the 5 x bases to check if there are any matches I need the results returned in the output from the API request Many thanks, Karan

310
Lucas_Ravassall
S
scoti2002New Participant
posted in Development & APIs
Hire a professional developer

Hi, we are an entertainment agency that needs to create a back end system which includesData base contacts that can be tagedTasks and task trackercreate template contracts that we can edit and send for signatureCalendersIf you can assist please let me know

23
Pello
K
KevinScottGoffNew Participant
posted in Development & APIs
Problems using ?filterByFormula with a special character ('#')

I'm using the AirTable API with Powershell, to lookup records in AirTable where a column value contains a special character ('#')For example, I'm trying to filter on AirTable rows for a Color column that contains a '#'.Let's say the Color value is 'ABC#1'.      I have tried different combinations of double quotes and back-slashes, but nothing seems to work:Using the original color definition doesn't work....it generates an invalid formula error. But no matter what I do in the 2nd variable, I continue to get an invalid formula error.$OriginalColor =  'ABC#1'      $LookupColor = $Color.Replace('#',  '\#')$filter = "?filterByFormula=And({Division}='$Division',{Style}='$Style',{Color}='$LookupColor')"The error I get is: iwr : {"error":{"type":"INVALID_FILTER_BY_FORMULA","message":"The formula for filtering records is invalid: Invalid formula. Please check your formula text."Maybe it's something more specific I need to do with

153
dilipborad
R
Rich_StrachanNew Participant
posted in Development & APIs
Updating Interface using scripting

I need to create a simple function that checks a value, compares with it with another value in a record.I have the interface setup and have created a record in the table that the user can update. I have a button that runs an automation to run a script and completes the check. What I cannot seem to do is update the user to say wether or not the check has passed or failed.I cannot use output.text as this isn't available in automations, only the scripting extensions. AFAIK you can't open a dialog box from the automation script either. The only way I can think to achieve it is to add a field to the table called "Dialog" in the table and then update that display that in the interface? But that seems _really_ clumsy.My question isA: Can I run a script extension from a button on an interface? B: Does anyone have a better idea of how to achieve this?

141
TheTimeSavingCo
ng010105
ng010105Participating Frequently
posted in Development & APIs
Mass download attachments/Bulk Download Attachments using python script API

Jumping in for anyone who finds this thread in the future -I have created a (Free) python script that allows you to download your attachments,you can read the code I wrote on github https://github.com/garygng/Airtable_python. Wish you guys like it  and give me a  Kudo👍 

1455
H

Badge winners

Show all badges
Terms & Conditions