We're setting up your new app...

Sample app

Images in sheets

How to have images show up in your Google Sheet

Industry: n/a
Often, you want images uploaded through your app to show up in your Google Sheet. However, the value that AppSheet puts in an image cell is a relative path to an image, not an actual image URL. You can use spreadsheet formulas to compute a URL and have your image show up in your sheet.
Also see: tablet mode & fullscreen mode
Embed sample:

How we built this app

The app has a single table with a Name and Image column. Then, we added two more columns: Image Url and Displayed Image. The Image Url column uses a sheet formula: SUBSTITUTE(CONCATENATE("https://www.appsheet.com/template/gettablefileurl?appName=","Imagesinsheets-71626","&tableName=", "Data","&fileName=",RC[-1]), " ", "%20") In that formula, we've put in the name of this app (Imagesinsheets-71626), the name of the table (Data), and then put in a reference to the filename. For the Displayed Image column, we used the formula: IMAGE(RC[-1]) The Displayed Image column is used to display the image in the sheet. In order for the images to display correctly outside of AppSheet, we also had to disable the "Require Image and File URL Signing" setting in Security -> Options.
This is a preview of the data sets used in the app.


This is a high-level model of both the data entities and the UI elements in the app.
Start for free