Data Sources allow you to specify columns as a specific data types. By default columns are set to Text data type, but several options can be selected. This is changed in the web platform within the actual data source page.
- Text: default setting, and an appropriate data setting for all fields that do not need to be generalized
- Number: refers to integer or decimal entries
- Multiline Text:
- Image: important for fields that you wish to display or save photos (more detailed information on this is outlined below)
- Geo Coordinates: important for any location fields - no other data type will allow this information to be displayed on a map
- Date/Time: specifically 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.
PLEASE NOTE: Currently only PNG and JPG image file types are supported by our platform and apps.
Setting Up An Image Column:
To get started, you need to have an existing Data Source - if you don't have one, then create one now (see our associated guides for this process).
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 (i.e. your Data Source contains less than 100 rows, less than 50 columns, and it's not connected to an external source), then 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, but 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 - i.e. 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, then 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, and the ability to simply specify a web address hyperlink to your chosen image makes for a dynamic and easy way to plug images straight into Data Sources.
The above two points are important if you will be uploading photos directly into the data source.
If however, you will be using the app (for example, an asset inspection form) to be uploading photos as forms are completed, it is still important to specify the column data type as Image from the data source page in the web platform.