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

importing CSV from URL

I have a script to import a CSV from a URL. The URL is provided by an API JSON file. let csvFile = await remoteFetchAsync(reportData.attachment.url) At this line, I get the error:j: Error: Response status was 302 'Found' but redirect mode was set to ...

auekk2787 by 6 - Interface Innovator
  • 426 Views
  • 0 replies
  • 0 kudos

Resolved! choosing single select option as variable in script

I'm writing a script to create records from an API call. One of the fields is a single select option. At the start of the script, I want to use the input option for the user to pick an option from the single select, which will be used for all the rec...

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

Resolved! Script - Timing out after 30 seconds. Help to make more efficient

I have written the script below to select records from one table in my base and insert them as new records in a second table.  The script is working, however it times out after running for 30 seconds.  The process is selecting and creating about 200 ...

rmc1977 by 5 - Automation Enthusiast
Solved
  • 1752 Views
  • 6 replies
  • 0 kudos

Need scripting help to extract a text piece

Hi there,I would need some help. I have entries with a field "Description" this field contains a lot of text (coming from calendar entries). Part of the text is the name of a store. it's the words after "Name des Stores: ". I need to extract these wo...

Melagence by 5 - Automation Enthusiast
  • 471 Views
  • 0 replies
  • 0 kudos

Airtable Script: Freeze Time and Delete After Records

Hello Airtable Community!I'm looking to enhance my tables and I believe using scripts could be a helpful solution.Here's the issue: I have a database where company managers provide monthly forecasts for income and costs on their respective projects. ...

giulia_mg by 6 - Interface Innovator
  • 516 Views
  • 0 replies
  • 0 kudos

Change the background color of a cell programatically

Hello, Airtable community!I am writing an extension and I want to change the background color of particular cells if they match condition.For example: There is a Price column and if the price is > 1000 I want this cell to have a red background.  I kn...

MvisiON by 4 - Data Explorer
  • 1140 Views
  • 1 replies
  • 1 kudos

Help creating script to update Memberstack JSON

Hi there, I'm trying to create a script that takes data from Airtable and updates it into Memberstack JSON. I went this scripting route because I couldn't figure out a no-code alternative to this. The problem is I'm not getting any errors messages wi...

Resolved! Get/Extract URL from hyperlink

Hi community, I recently had to solve the situation where I needed to get URLs from hyperlinks stored in rich text formatted long text fields and put them in another long text field. Essentially, just showing the URL, not the hyperlinked text. I ende...

Unable to create table in exisiting base

I am trying to create a table in an existing base using below endpoint but getting a not found error - https://api.airtable.com/v0/meta/bases/{base_id}/tables'type': 'NOT_FOUND'===============================================table_name = "Members"desc...

sharim007 by 4 - Data Explorer
  • 2013 Views
  • 4 replies
  • 0 kudos

Formatting in Outlook emails

I create some summary reports for a client. Data is read from a view I iterate through the records to generate the HTML/Markdown for the email.However, to get the formatting correct, I have to use this odd amalgamation of markdown and HTML. Using one...

Matthew_Moran_0-1690738275413.png

Resolved! Uploading and downloading image files from airtable to S3

I have the following use case: I have images saved as attachments within a table. I need to automatically upload any newly created images via API (not Make or Zapier due to volume) to an 'Input' bucket on S3. From here the images are manipulated by a...

Edward1976 by 6 - Interface Innovator
Solved
  • 4747 Views
  • 13 replies
  • 5 kudos
Labels