Adding Data Sources

Adding Data Sources

Data Sources let you create and maintain data sets for use on Screens, saving you time by centralizing your data sets in one place.

Add a Data Source

When logged into the web portal:

  • Navigate the left-side menu to Data Hub > Data Sources.
  • Once on the Data Sources page, click the “Add New” button in the top right corner.

The page will reload on the Create Data Source page, where Basic Settings and Advanced Options can be configured.

  1. Enter a Name for your data source (required)
    i.e., Field Sales – Clients referencing the solution and containing data for easy identification when designing solutions and binding to fields.
  2. Click the “Create” button in the top-right corner.

Default Sort Order and Advanced Settings are optional and can be configured once the data source is populated if needed

Finally, you’ll need to populate your data source for use in screens. This can be achieved in one of three ways:

  1. Manual cell data entry by adding rows/columns.
  2. Import an Excel/CSV file to create and populate row/column data.
  3. Pull data into the platform from an external system using a Data Source Connector (configurable on the data source’s Settings page).

Importing requires an Excel (.XLSX) or Comma Separated Values (.CSV) file, which MUST be in the required format.

  • The first row of your file is assumed to be the data source headers, and the rest are just rows.
  • The file must contain at least one row (excluding the header row) and two columns.
  • The first column in all rows must be populated with unique values.

When importing, a cloned copy of the overwritten data source is moved to Trash that can be used to restore the data source, in case of any import mishaps.

A template of the required format can be obtained by clicking the “Import” button and the download link provided before importing a file.

Further Information

    • Related Articles

    • Editing Data Sources

      User-defined and Connected Data Sources can be edited in a variety of ways. You can edit directly in the web portal for small Data Sources or those that rarely need to be manually changed or edited. Click in a cell to edit/overwrite the data already ...

    • Data Sources and your Data

      What is a Data Source in Appenate? Data Sources in Appenate allow you to create and manage data sets that can be reused across multiple Forms and Screens. Examples of these are a list of choices, a product catalog, or a list of contacts. Where Can a ...

    • Adding Folders

      Folders help organize your apps and resources and control who can access the content, both in the app and web portal. When viewing the Screens, Data Sources, Files & Docs, or Task Templates areas of the platform, Folders are visible on the top right ...

    • Adding Items to Folders

      Folders are available on the web portal’s Screens, Docs, Data Sources, and Task Template listing pages. Adding these items to a Folder is the same for all, so we’ll use Screens as our example. Adding a Screen to a Folder On the Screens page of the ...

    • Adding Users

      To add a new user, log in to the web portal and go to Organization & Users > Users & Groups from the side menu. On the Users & Groups page, you’ll be presented with a list of Active and Invited users. You can also toggle to view Inactive users; these ...