How to stop column dereferences from including table name

[Jordan_Davis1]

I have Table A using dereference formulas in five columns. All work as intended, except for one which is adding the table name in front of each cell value.

The only thing unique about this column is that it’s an image column type whereas the others are text column types. For example, the image name in Table B is ‘01003.jpeg’ and when it’s copied to Table A it’s showing up as ‘Table B:: 01003.jpeg’.

Does anyone know why that’s happening and how to have it only copy the filename over? FYI The image is in the same folder as my google sheet so the table name isn’t necessary.

[Steve]

Please share a screenshot of a complete expression that produces the unexpected result.

[Jordan_Davis1]

It’s a spreadsheet column with an IF that chooses the artwork for the specific song at issue from the table Works. If the Works table doesn’t have the specific artwork for this song, it reverts to a logo of the record label from the Directory table.

In either case, the artwork filename ends up copying to the spreadsheet like this:

[Steve]

I’d call this a bug. Please contact support@appsheet.com for help with this.

[GreenFlux]

Jordan_Davis1:

If the Works table doesn’t have the specific artwork for this song, it reverts to a logo of the record label from the Directory table.

As a workaround, why not use a Virtual Column with the same expression?

I’ve used this exact technique for swapping a Contact’s display image between a default one and a custom photo. I’m not sure why it doesn’t work with a sheet column, though. I agree with @Steve, that does seem like a bug.

[Jordan_Davis1]

Thanks for the tip! I try to minimize virtual columns whenever possible, to improve sync time. What’s more, in this case, I have one app that writes all of the data from Table B to Table A and another app that only has Table A (all in the interest of sync time). Accordingly, a virtual column wouldn’t work because the referenced Table B isn’t in the app. I’ll contact support though and see if they can figure it out.