If you are storing the data for your app in Google sheets, you are probably aware that you can, if you choose to do so, share that sheet which someone else and thereby share any text or numerical data in that sheet. Are you aware, though, that you can also share images in this way? It’s actually quite easy to do.
The following image displays data that my students have shared with me, along with my comments and evaluation:
Each student in the class is using a copy of an app that I have made public as a sample. We are all using separate free accounts. They have shared their sheets with me but they have not shared their Google Drive folders or individual photos with me. So, how is this possible?
I asked them to open their Google sheets and then, in the File menu, open their Document Details to find the location in which their sheets are stored. They typed this information into a record in their apps into which I asked them to type a special tag to allow me to identify that record as an assignment that is being submitted. As a result, when the students did the task correctly I had the address of their image (recorded as text when the student uploaded his or her screenshot), the location (the data they found in the Google spreadsheet), and the name of the name of the table (I know the name of the table because I made the app). With this data, I was able to automatically generate a link to each image, even though all of the accounts are different. The method for generating links to display images is explained here:
[Insert google sheets formula to display image when saving changes to appsheet](https://community.appsheet.com/t/insert-google-sheets-formula-to-display-image-when-saving-changes-to-appsheet/20797/2) Questions
This post from a while back has some relevant links: It links to a sample app and to a page documenting how to do this Scroll down to “Showing Images in Google Sheets”. Now, as to your problem, I’m not completely sure that I understand your problem but let me suggest that you try the following. Copy the sample I introduced above. After copying the sample, use it to add a new image. You’ll find that the new image doesn’t display in your sheet. The problem is that the correct nam…
In the past, I though that displaying images inside of sheets was merely a convenience for people viewing the sheets in which data is stored. Now, however, I’ve found that it’s a way for people using different accounts and different apps to share their images, if they choose to do so.