Help
Development & APIs
Share, ask questions, and learn more about the backend of your Airtable applications.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

How to extract actual file from attachment field

HelloI am developing a Airtable Script and I am looking for extracting actual file object which is part of the attachment field in a table. I got the object using record.getCellValue("Attachment field"). This object has information like URL, Filename...

Sri1 by 6 - Interface Innovator
  • 874 Views
  • 1 replies
  • 1 kudos

Formula search from a script?

I have an automation script that searches a table for a matching record. Based on the examples I could find, I wrote it to retrieve that column from all the rows using selectRecordsAsync(), and then loop through all the rows looking for a match. But ...

DanaBergen by 4 - Data Explorer
  • 258 Views
  • 2 replies
  • 3 kudos

Modify a Link to Records field, from a script in a button

I have a database with two tables “gifts” and “status”. I'd like to use a button to update the status automatically via a script. I searched the documentation and the forum, but I couldn't find any solution to adapt the script to my problem. Here's t...

Adrienocode by 5 - Automation Enthusiast
  • 679 Views
  • 5 replies
  • 0 kudos

Interfaces API call return 404

Is it just me or is anyone else having trouble with api calls on interfaces?Get / Delete / Add workspace or base collaborators work perfectly fine. But seems like anything to do with interfaces in not found. The below specifically.Even putting the UR...

Katieglamer by 5 - Automation Enthusiast
  • 233 Views
  • 0 replies
  • 0 kudos

Resolved! Scripting help

Probably a simple solution, but I can not figure it out. I am using the following script to try to get a list of all of the records in a specific table.let table = base.getTable("Codes");let query = await table.selectRecordsAsync();console.log (query...

Jeff_Hladek by 5 - Automation Enthusiast
Solved
  • 329 Views
  • 1 replies
  • 1 kudos

Resolved! use single select field values in input select

I'm trying to use the options from a single select field as an 'input' selection in my script. I'm not sure if Airtable allows this. So far I have: let selectTable = base.getTable("Courses"); let selectField = selectTable.getField('School Year'); let...

auekk2787_0-1720904542160.png auekk2787_1-1720904583710.png
auekk2787 by 6 - Interface Innovator
Solved
  • 532 Views
  • 2 replies
  • 1 kudos

script to copy array of found records to linked field

I'm creating a script between 2 tables: 'Engagements' and 'People'.Engagements is a list of event attendancePeople is a master list of peopleI have a script that, using the attendance sign up info (name, email), tries to find a matching person from t...

auekk2787 by 6 - Interface Innovator
  • 425 Views
  • 1 replies
  • 0 kudos

Resolved! Workaround for filtering on selectRecordsAsync

Hi Folks,I have come up with a workaround for not being able to filter on query within scripting automations. Since you can query on a view but views can't be adjusted via the API either we use a view that has a checkbox and then check the box throug...

Howard_Shaw by 6 - Interface Innovator
Solved
  • 1379 Views
  • 3 replies
  • 1 kudos
Labels