Field Type Conversion

Overview

When modifying the field type of a data table field (e.g., changing an integer field to a single text field), some conversions may cause source data loss, while others will automatically convert the source data to the target data. Below, we will introduce scenarios when converting from other types of fields to each field type individually. (Source field types not mentioned indicate that the system cannot automatically convert the source data, so the source data will be cleared)

Single Text

• Multi-line Text: Multi-line text data will be truncated, with the maximum string length being the maximum value configured in the single text settings (default is 200)

"Multi-line text" -> "Multi-line text"

• Checkbox or Switch: If checked, it converts to Yes; if unchecked, it converts to No

true -> "Yes"

• Integer: Integer converts to string

233 -> "233"

• Decimal: Decimal converts to string

233.2 -> "233.2"

• Date: Date is converted to string according to the display format. For example, if the display format is 2023-01-13 21:55:07, the date data will be converted to a string in the yyyy-MM-dd HH:mm:ss format

// Without time selection
1684252800000 -> "2023-05-17"
// With time selection
1684171200000 -> "2023-05-16 01:20"

• Others: Source data will be cleared

Multi-line Text

• Single Text: Same as source data

"Single text" -> "Single text"

• Checkbox or Switch: If checked, it converts to Yes; if unchecked, it converts to No

true -> "Yes"

• Integer: Integer converts to string

233 -> "233"

• Decimal: Decimal converts to string

233.2 -> "233.2"

• Date: Date is converted to string according to the display format. For example, if the display format is 2023-01-13 21:55:07, the date data will be converted to a string in the yyyy-MM-dd HH:mm:ss format

// Without time selection
1684252800000 -> "2023-05-17"
// With time selection
1684171200000 -> "2023-05-16 01:20"

Rich Text

Converting from other types will clear the source data.

Checkbox/Switch

Converting from other types will clear the source data.

Integer

• Single Text: Converts to integer; if conversion fails, it is set to null

"233" -> 233
"13a" -> null

• Checkbox or Switch: If checked, it converts to 1; if unchecked, it converts to 0

true -> 1
false -> 0

• Decimal: Takes the integer part of the decimal. For example, if the source data is 1.234, it converts to 1; if the source data is 1.567, it also converts to 1

1.10 -> 1
1.00 -> 1

• Related List Rollup: Same as source data

100 -> 100

• Lookup Rollup: Same as source data

100 -> 100

Decimal

• Single Text: Converts to decimal; if conversion fails, it is set to null

"233.2" -> 233.20
"13a" -> null

• Checkbox or Switch: If checked, it converts to 1.00; if unchecked, it converts to 0.00

true -> 1.00
false -> 0.00

• Integer: Same as source data

1 -> 1.00

• Related List Rollup: Same as source data

100 -> 100.00

• Lookup Rollup: Same as source data

100 -> 100.00

Rating

Converting from other types will clear the source data.

Date

• Creation Time: Same as source data
• Last Modification Time: Same as source data

2023-01-01 00:01:01 -> 2023-01-01 00:01:01

Time

Converting from other types will clear the source data.

Attachment (Single)

• Attachment (Multiple): Takes the first element

[
  {
    "id": "f9fc698fb0124ab8b729e0fc8be7ef71.xlsx",
    "md5": "4bead1d6d6498b365ed8657e20252b7b",
    "name": "Workbook1 (1).xlsx",
    "path": "wzz90dxt5lool/dxkfqhavp0820/f9fc698fb0124ab8b729e0fc8be7ef71.xlsx",
    "size": 8593
  },
  {
    "id": "cc4a6a19be6d4b5db29e9ffbe18f3c36.xlsx",
    "md5": "4bead1d6d6498b365ed8657e20252b7b",
    "name": "Workbook1 (2).xlsx",
    "path": "wzz90dxt5lool/dxkfqhavp0820/cc4a6a19be6d4b5db29e9ffbe18f3c36.xlsx",
    "size": 8593
  }
]

{
  "id": "f9fc698fb0124ab8b729e0fc8be7ef71.xlsx",
  "md5": "4bead1d6d6498b365ed8657e20252b7b",
  "name": "Workbook1 (1).xlsx",
  "path": "wzz90dxt5lool/dxkfqhavp0820/f9fc698fb0124ab8b729e0fc8be7ef71.xlsx",
  "size": 8593
}

Attachment (Multiple)

• Attachment (Single): Converts to array, with source data as the first element

{
  "id": "f9fc698fb0124ab8b729e0fc8be7ef71.xlsx",
  "md5": "4bead1d6d6498b365ed8657e20252b7b",
  "name": "Workbook1 (1).xlsx",
  "path": "wzz90dxt5lool/dxkfqhavp0820/f9fc698fb0124ab8b729e0fc8be7ef71.xlsx",
  "size": 8593
}

[
  {
    "id": "f9fc698fb0124ab8b729e0fc8be7ef71.xlsx",
    "md5": "4bead1d6d6498b365ed8657e20252b7b",
    "name": "Workbook1 (1).xlsx",
    "path": "wzz90dxt5lool/dxkfqhavp0820/f9fc698fb0124ab8b729e0fc8be7ef71.xlsx",
    "size": 8593
  }
]

List Selection (Single)

• List Selection (Multiple): Takes the first element

["a", "b"] -> "a"

List Selection (Multiple)

• List Selection (Single): Converts to array, with source data as the first element

"a" -> ["a"]

Cascading Selection (Single)

• Cascading Selection (Multiple): Takes the first element

[["a", "a.1"], ["b", "b.1"]] -> ["a", "a.1"]

Cascading Selection (Multiple)

• Cascading Selection (Single): Converts to array, with source data as the first element

["a", "a.1"] -> [["a", "a.1"]]

Tree Selection (Single)

• Tree Selection (Multiple): Takes the first element

["a", "a.1", "b", "b.1"] -> "a"

Tree Selection (Multiple)

• Tree Selection (Single): Converts to array, with source data as the first element

"a" -> ["a"]

User Selection (Single)

• User Selection (Multiple): Takes the first element

[
  {
    "avatar": "pic1.png",
    "id": "lisiming",
    "name": "Li Siming"
  },
  {
    "avatar": "12c735d303cc49f289fe885392d19b57.jpg",
    "id": "skydu",
    "name": "skydu"
  }
]

{
  "avatar": "pic1.png",
  "id": "lisiming",
  "name": "Li Siming"
}

User Selection (Multiple)

• User Selection (Single): Converts to array, with source data as the first element

{
  "avatar": "pic1.png",
  "id": "lisiming",
  "name": "Li Siming"
}

[
  {
    "avatar": "pic1.png",
    "id": "lisiming",
    "name": "Li Siming"
  }
]

Department Selection (Single)

• Department Selection (Multiple): Takes the first element

[
  {
    "id": "yanfabu",
    "name": "R&D Department",
    "path": "INFROMAT/R&D Department",
    "shortName": "R&D Department"
  },
  {
    "id": "fananbu",
    "name": "Solution Department",
    "path": "INFROMAT/Solution Department"
  }
]

{
  "id": "yanfabu",
  "name": "R&D Department",
  "path": "INFROMAT/R&D Department",
  "shortName": "R&D Department"
}

Department Selection (Multiple)

• Department Selection (Single): Converts to array, with source data as the first element

{
  "id": "yanfabu",
  "name": "R&D Department",
  "path": "INFROMAT/R&D Department",
  "shortName": "R&D Department"
}

[
  {
    "id": "yanfabu",
    "name": "R&D Department",
    "path": "INFROMAT/R&D Department",
    "shortName": "R&D Department"
  }
]

Handwritten Signature (Single)

• Handwritten Signature (Multiple): Takes the first element

[
  {
    "accountId": "lisiming",
    "accountName": "Li Siming",
    "id": "321ec8bb6b244640a96b302755bac940.jpg",
    "path": "wzz90dxt5lool/kcmcgp521hiay/321ec8bb6b244640a96b302755bac940.jpg",
    "uploadTime": 1684247757271
  },
  {
    "accountId": "lisiming",
    "accountName": "Li Siming",
    "id": "dc76e5b7af814c639a47c480238aa0bb.jpg",
    "path": "wzz90dxt5lool/kcmcgp521hiay/dc76e5b7af814c639a47c480238aa0bb.jpg",
    "uploadTime": 1684247767001
  }
]

{
  "accountId": "lisiming",
  "accountName": "Li Siming",
  "id": "321ec8bb6b244640a96b302755bac940.jpg",
  "path": "wzz90dxt5lool/kcmcgp521hiay/321ec8bb6b244640a96b302755bac940.jpg",
  "uploadTime": 1684247757271
}

Handwritten Signature (Multiple)

• Handwritten Signature (Single): Converts to array, with source data as the first element

{
  "accountId": "lisiming",
  "accountName": "Li Siming",
  "id": "321ec8bb6b244640a96b302755bac940.jpg",
  "path": "wzz90dxt5lool/kcmcgp521hiay/321ec8bb6b244640a96b302755bac940.jpg",
  "uploadTime": 1684247757271
}

[
  {
    "accountId": "lisiming",
    "accountName": "Li Siming",
    "id": "321ec8bb6b244640a96b302755bac940.jpg",
    "path": "wzz90dxt5lool/kcmcgp521hiay/321ec8bb6b244640a96b302755bac940.jpg",
    "uploadTime": 1684247757271
  }
]

Color

Converting from other types will clear the source data.

Geographical Coordinates

Converting from other types will clear the source data.

Related Record

Converting from other types will clear the source data.

Sub-object

Converting from other types will clear the source data.

Related List Rollup

Converting from other types will clear the source data.

Lookup Rollup

Converting from other types will clear the source data.

Serial Number

Converting from other types will clear the source data.

Sub-object Number

Converting from other types will clear the source data.

Creation Time

• Date: Same as source data
• Last Modification Time: Same as source data

2023-01-01 08:00:00 -> 2023-01-01 08:00:00

Last Modification Time

• Date: Same as source data
• Creation Time: Same as source data

2023-01-01 08:00:00 -> 2023-01-01 08:00:00

Creator

Converting from other types will clear the source data.

Last Modifier

Converting from other types will clear the source data.