I’m having trouble getting images to work.
My google sheets has a column “Image”, which has the formula =IMAGE(HYPERLINK(“https://api.scryfall.com/cards/named?exact=” & H5 & “&format=image”)) , with H5 incrementing by 1 for each row. I have a feeling having the variable in the middle is confusing AppSheet, but there’s no way for me to get the correct image without it. Does anyone know of a way to get images to work in this case? In particular, I want the image to display in Table view as the left-most column, but I don’t think it matters.
I think one solution would be to use SUBSTITUTE to replace the [ " & H5 & " ] with something in AppSheet-speak which means “and the contents of the relevant row of the H column”, but I havent the foggiest how I’d do that. That’s just my first thought.