Development & APIs

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…

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

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

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 ?

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:

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

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

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

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? 

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 🙂 

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

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

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

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

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?

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👍 

I have an API script like the below. This works fine as a scripting Extension (right panel) but when I place the script into an Automation Script step, Airtable gives the error "ReferenceError: FormData is not defined".Any ideas why it would work in one place but not the other? const myHeaders = new Headers(); myHeaders.append("Authorization", apiKey); const formdata = new FormData(); formdata.append("file", fileBlob); const requestOptions = { method: "POST", headers: myHeaders, body: formdata }; let postResponse = await fetch(apiUrl, requestOptions); 

I'm trying to script a POST request to the Covve API to parse business cards. Their technical support says "the API does not support passing the file via URL. It only accepts uploading the file itself directly."Is there a way to do this through Airtable, using the expiring URL? This is the relevant part:const myHeaders = new Headers(); myHeaders.append("Authorization", apiKey); myHeaders.append("Content-Type", "multipart/form-data"); const formdata = new FormData(); formdata.append("file", photoURL); const requestOptions = { method: "POST", headers: myHeaders, body: formdata, redirect: "follow" }; let postResponse = await remoteFetchAsync(apiUrl, requestOptions); 

I'm trying to use ChatGPT to analyze written data from airtable surveys, but ChatGPT is unable to access the information from a csv file. Is it possible to connect ChatGPT to Airtable in order to give it access to specific tables? The idea would be to be able to ask ChatGPT questions such as "What are the top 3 things guests enjoy about this trip?" based on the survey responses.

Hi, Did anybody already figured out how you make inquiry of your Airtable base with chatgpt. Very basic example: you have database tracking projects. And you ask Chat GPT (or any other ai model for that matter) - what is the status of project A, or who is responsible for project B, etc. 

When a form is submitted it shows the GMT date & time however when an automation email is sent it sent as UTC. Can someone please help me fix this.Thank you.

Hello,While testing my script to parse some pdf/excel documents - all under 500MB (considering the limit is 5GB) - any solution? Or is the 5GB limit not per document but for the whole account?Thank you in advanced.

Hello, I am trying to automate Airtable with JIRA using microsoft Flow. At my company we have restrictions that imposes that I use the Microsoft Solution. I would like to create a JIRA ticket every time I created a record in my Airtable Table. In microsoft flow I need a trigger to start the flow. Can someone know how to get the airtable trigger for when a new record is created? Thank you

Which API can I use to delete a field/column of a table?

I'm using the Airtable Node SDK and the type for `offset` is `number` but it throws an error of "INVALID_OFFSET_VALUE". Passing a `string` also throws an error "Error: Airtable: invalid parameters for `select`".Also, I don't get the `offset` string from the response when using the SDK.Is it possible to do pagination with the SDK? I see there's a function for `.select().eachPage()` but I'm not sure how to use it to implement pagination.If requesting via Fetch, I get the `offset` string from the response and I'm able to send it to the next request and get the next page, but how do I navigate backwards? I would need to store in a hash map ( { 0: null, 1: 'first_page/offset_string', ... } ) ?Another question is: Is it possible to implement a "normal" pagination? Like, navigate to an specific page, navigate backwards, etc.?