Data sources allow you to specify columns as specific data types. Columns are set to text data type by default, but several other options can be selected. Data types can be changed through the web platform from the data source page.
Here is a list of available data types:
- Text: This is the default setting, and an appropriate data setting for all fields that do not need to be generalized.
- Number: This refers to integer or decimal entries.
- Multiline Text:
- Image: This is important for fields that you wish to display or save photos. More detailed information on this is outlined below.
- Geo Coordinates: This is important for any location fields. No other data type will allow this information to be displayed on a map.
- Date/Time: This saves information as a date or time data type.
Image data type
The image data type setting allows you to pull images from the data source and display them on the app. For example, you may want to display thumbnails of inspected signs in a list of choices, or as a larger view when viewing details of a particular asset.
Note: Only PNG and JPG image file types are supported by our platform and apps. We're hoping to add more in the future.
Setting up an image column
To get started, you must have an existing data source. If you don't have one, create one now. You can use this article for help. Once you have your data source, ensure the column you wish to store images in is set to the 'Image' data type.
Adding images into your image column
There are two ways you can add image content into the image column.
- If your data source is editable (e.g. your data source contains less than 100 rows, less than 50 columns, and it's not connected to an external source), simply click on each image cell in the rows page. This will open a dialog window, where you can choose a file to upload into that image cell. The file will be stored on the platform upon successful upload. Be sure to save your changes after adding your images.
- By using web address hyperlinks to the images in question. The only restriction with this option is that the hyperlinks must be publicly accessible from the internet - e.g. must not be hosted on a private network, or require a session/login in order to access the image. An easy way to check if your hyperlink is truly public is to open a web browser window in private browsing mode, and browse to the image hyperlink. When you specify image hyperlinks, the image file is not downloaded to our platform. Instead, the file will be loaded from the given hyperlink on demand. You can specify hyperlinks as your image column values when using any of the following import options:
- Manual Excel file import
- Connector to a spreadsheet or other file
- Via our data source API
Image columns are a great way to add an extra dimension to your app. The ability to specify a web address hyperlink to your chosen image makes for a dynamic and easy way to plug images into data sources.
Note: If you will be using the app to upload photos as forms are completed, it's important to specify the column data type as Image from the data source page in the web platform.