Wondering if any of you wizards have any ideas for simple ways to do Base64 encoding of uploaded images (needed for Cloudinary image layering). Currently, I have a script writing in an encoding formula. It’s really long and calculation heavy. It’s already showing signs that it’s going to start acting weird as more rows pile up. Lately the last row of that particular column is going blank randomly (causing Glide to not see it and breaking my Cloudinary link), and then when a new row of data is added, the formula magically appears in that cell again. Some strange sheets bug I guess… likely caused by slow calculation or something.
I’ve been considering switching the encoding to happen exclusively in the script using Utilities.base64encode(), but the problem with that is if someone edits and replaces the image… I’ll need to create some kind of ‘for’ loop to check that entire column of data every time there’s a change just to make sure I don’t need to swap out the old encode with an encoded version of the new image.
And I’m wracking my brain trying to think whether there’s an easier way. Has anyone come up with a simpler solution for encoding and storing base64 info in a corresponding column and then changing it if the image changes in the other column?