My app has an Order table and a Product table.
Each row in the Product table has a unique Product ID column, several columns with text and numbers and a column with a JPEG image. (The image file is uploaded via the app)
The Order table contains a Product ID and a virtual Image column that I linked to the Product table using the Select function:
SELECT(Product[Image],[Product ID]=[_THISROW].[Product ID],TRUE)
If I try to set the virtual Image column type to "Image" I get an error. AppSheet wants the virtual column to be a List type. However, the virtual column image will not display in any view I create. Also, I want to be able to include the virtual Image column as part of a bot that creates a PDF document with order information. The "create report" bot works fine for all the other Order columns (including several virtual columns that lookup text data from the Product table), however the virtual image column is a problem.
I would appreciate any suggestions, help, etc.
LinkedIn
Twitter
