A way to make files preview in appSheet somewhat like the images do?

[Gab0c]

I'm trying to make an application that keeps tracks of expenses. Each expense has an image or file attached to it. I would like to have a preview of the image or file inside the details of that entry. Such that the user doesn't have open the file in an external app. Usually the only files used will be PDF and image files. Is there a way to accomplish this with a similar behavior to the already existent image preview that appSheet offers?  

[lynchk21]

I have not tried this, but my first instinct would be to make a virtual column with an image type, and then use an expression to display the file column. You could even set the virtual column to display whichever column (file or image) that is not blank so that you can just use the virtual column in your view. Something like IF(ISBLANK([_thisRow].[File]),[_thisRow].[Image],[_thisRow].[File])

Not sure if this will work, but it might be worth a try. 

[Gab0c]

I just gave it a shot but because the column with the file is a file data type and the one with image and image data type the IF() couldn't work.  

So I changed it to just display the file column to see if it could display it with this trick yet it cant. 

[lynchk21]

That is what I feared. Perhaps there is a more complicated solution, but I can't think of an easy one. 

Hopefully someone else knows!

[Gab0c]

Yes, hopefully. Thank Your for your help!!