📄Data field types

Overview

In the system, whether it's customer data, work orders, or other related information, you will find many different types of fields available. These field types include text, numbers, dates, etc.; each corresponds to specific data processing requirements and directly affects functionality implementation and interface display.

For example, when creating an import template, the system provides these different field types for you to choose from so you can configure them according to your needs.

Import and export data types

Import field types	Format description	Example Value	Usage scenarios
Text	Text: single-line text	Hello World	Used for any scenario that requires single-line text, such as names, titles, labels, etc.
Multi-line text	Text: can contain multiple lines of text	Apple Banana Coconut	Used in scenarios that require multi-line input, such as addresses, descriptions, notes, etc.
Yes/No	Boolean value: (0 or 1) - 0 means No, 1 means Yes	1	Used for settings that require a yes/no judgment, such as toggle states, whether terms are accepted, etc.
Date	Text: YYYY-MM-DD, 24-hour format	2022-03-07	Used to record specific dates, such as birthdays, event dates, contract start or end dates
Time	Text: HH:MM, 24-hour format	22:05	Used to record specific times, such as meeting times, event start or end times
Date and time	Text: YYYY-MM-DD HH:MM:SS, 24-hour format	2022-03-07 22:05:34	Used when date and time need to be precise to the second, such as transaction times or log timestamps
single choice	Text: option value	value	Used to select one from fixed options, such as blood type, country, status, etc.
Multiple choice	Text: multiple option values separated by delimiters; ",", ":", or ";" can be used	value1; value2; value3	Used to select multiple options, such as interests, product types, etc.
Employee	Number: a single number representing the system ID number	5	Used to identify a unique number for employees or participants, for internal management or system relations
Customer relation table	Number: a single number representing the system ID number	45	Used to identify the unique number of a customer or other entity, for business or customer relationship management