Template
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.
Loading...
Also see:
tablet mode & fullscreen mode
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.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...