I have no problem taking a photo or uploading to AppSheet using App "A". In the Google Spreadsheet data, i can see the file path stored in the photo column. Eg: "Employee Info_Images/gLuyJ85Lwe.Photo.015258.jpg" where the Table name is called "Employee Info".
A different app (App X) was also using this table. I was able to have the employee photo show up in App X in the past. However the Employee Info table also contains a lot of sensitive info. I do not want to import all the columns of the Employee Info table into App X. Therefore I used a =query(importrange(...)) function on a different table ("Narrow Table") to query only a few select columns of Employee Info table. One of those columns is the photo column.
The problem appears when I replaced Employee Info table with this new Narrow Table. The photos no longer show up.
Where might the problem lie? Is it because I have to use the Employee Info table itself? Could I use the "Image/File folder Path" setting in appsheet to somehow point appsheet to the right "place"? If yes, where is this right place?
LinkedIn
Twitter
