Using Google Sheets I'm trying to populate a list of countries with (among others) names, ISO-alfa2 code, and flags. I use this
ArrayFormula() to get the flags from URL in my private server:
Where URL is the link hosting the flags, RANGE
P7:P222 contains ISO 3166-1 alpha-2 codes (all in upper case). The flags in the URL labeled with the same ISO codes except with lower case.
Things I tried:
LOWER(P7:P222), some flags don't show up.
UPPER(P7:P222) some different flags don't show up.
I used both Chrome and Firefox to view and edit the sheet.
Is there a way to fix this without changing the range to lower case or the images name to upper case? Is it something wrong with my formula or is it just the browser, HTTP/GET or Google app is misbehaving? Any input is greatly appreciated!
UPDATE: Looks like this has nothing to do with case-sensitivity as I changed range
P7:P221 to LOWER case, however, the problem persists and some images randomly don't show up.. Does this mean the
IMPORTANT UPDATE: Further tested the following:
image()to get images from Google Driver: no luck.
- Inserted images manually: they disappear after a while.
- Used ImageKit addon to insert images from URL (Google Driver and other servers): and via upload from my PC: Yield same results as using
I also changed the title of the question accordingly.