πCustom fields
Given differences across industries or business logic, data requirements will inevitably vary. Fixed form formats on the market rarely meet all users' needs, so FIRST LINE allows users to create the data they need through custom fields.
Custom type
Custom fields are divided into four uses, applied respectively to "Customer" and "Work Order" data relationships
Code
Name
Description
0
Customer form
Additional fields added to the original form, for example the customer's weight, blood type, etc. This kind of field belongs toform fields.
1
Customer table
Adding a one-to-many relation from the original form, for example multiple purchase records of a customer, belongs torelated tables.
2
Work Order form
Additional fields added to the original form, for example the work order's batch number, processing status, etc. This kind of field belongs toform fields.
3
Work Order table
Adding a one-to-many relation from the original form, for example multiple shipping records of a work order, belongs torelated tables.
Field type
Custom fields currently have the following types; each code represents a different storage type
Code
Field type
0
Number field
1
Text field
2
Boolean
3
Date
4
Time
5
Date and time
6
Single choice
7
Multiple choice
Options parameter is available for 6 (single choice) and 7 (multiple choice). The options for this field are recorded in JSON format. Below is an example using blood types:
An extra field added to the original form, for example Customer of weight, this kind of field belongs to dynamic form fields
Adding a "one-to-many" relation to the original form, for example Customer of purchase records, belongs to dynamic related tables
Query system custom fields
Custom fields currently in the system
Parameters
PARAMETER
REQUIRED
DEFAULT
TYPE
DESCRIPTION
page
false
1
Number
Which page is currently on
per_page
false
15
Number
How many items to display per page
types
false
NULL
Number
0: Customer dynamic form field 1: Customer dynamic related table 2: Work order dynamic form field 3: Work order dynamic related table
Response
Last updated