Formulas (expressions)

In this section, we introduce some tips and tricks that will help solve common issues that the majority of app creators run into at an early stage when starting to develop an app with AppSheet. Let’s dive in.

Creating a URL to access images and other files

The name of the sample app to refer to on the portfolio site is Chapter 12_01:

https://www.appsheet.com/templates/sample?appGuidString=a7950813-c128-4ad2-8bba-9f766034977f

Any image files or other files, such as PDF or MS Word files, you save in AppSheet apps will be saved in cloud services such as Google Drive automatically. Typically, there is an image, thumbnail, or file column type and it is easy to access and retrieve the files to show inside the app, as AppSheet automatically creates an action to open the files.

However, app creators quite often need to get the URLs to open the files for various reasons. We need to share those files with someone who does not have access to the app...