Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Connectors can be created by using the CSV and Json JSON files in order to access the data of these files.
In the following, we will give an example to create a connector from the CSV file “Suppliers” which contains supplier information such as name, ID, and industry.

...

In order to create a connector, please open the page Connector under the Design. Connector The connector will be available to use in the Smartform after necessary configuration.

...

Custom connectors can be used in the smartform. In our example, we have created a connector for supplier information. In order to show the supplier list in the “Select” element of the smartform, “Connections” section should be opened on the left-hand side. The label and the value will be selected from the headers of the CSV file, which contain different information of suppliers.

...

Parameter

Description

Example

Connection 1

Custom connectors can be reached via this drop-down list.

Suppliers

JSON Path: label

This area determines the parameter which should be shown in the smartform drop-down list.

$[*].Name

JSON Path: value

This area determines the parameter which will be stored in the database.

Info

The names of the suppliers will be shown in the dropdown list of the smartform, but the ID of the supplier will be stored in the database when the user selects the supplier name.

$[*].Customer_Code

Info

Syntax for JSON path starts with a $ sign. [*]

...

means all columns should be included. The last part after . specifies the column name which the data will be derived.
Blank space should be avoided from the column names to reach the information via JSON.
Customer Code → Customer_Code