Skip to main content

Encoding Issue...How To Fix?

  • July 28, 2020
  • 1 reply
  • 18 views

Forum|alt.badge.img+20
  • Inspiring
  • 614 replies

Hi Airtable!

I have some TV show names that have encoding issues that are causing errors in my Integromat scenario.

I tried all different variations, but it’s not working.

It is these names:
9-1-1: Lone Star

I tried removing the hyphens, colon and spaces between the numbers, but it did not work.

S.W.A.T.
I removed the periods, with spaces and without spaces, but that did not work either.

Law & Order: Organized Crime
I tried taking out the &, colon and extra space between the colon and the word Organized, but that did not work.

Any suggestions?

Google sheets is not playing nice with these titles.

Is there a website that I could use to change or find the cause of the error, so that I can use the title, without errors in my scenario?

Here’s the error:

1 reply

Forum|alt.badge.img+19
  • Inspiring
  • 3263 replies
  • July 28, 2020

I don’t think it’s the titles.

You are giving Integromat a range that is 26 by 1 million cells - ergo, a matrix with 26 million cells in a sheet that supports a max of 5 million cells.