KrewData Features > Commands > Set Field Type |
Set Field Type command changes the field type of selected field.
|
Setting | Description | |
---|---|---|
1. Select a field to set its data type | Select the field whose field type is to be changed. | |
2. Enter the name of the new field | Enter a new field name to change the field name after changing the field type. | |
3. Select the new data type for the field | Select the new field type. New field types that can be selected depends on the original field type. | |
Separator: When checkbox or multi-choice field is selected in the new field type, you need to use a separator character to split the string before change into items of checkbox or multi-choice field.
|
This example demonstrates how to change a calculated field that subtotals Unit price and Quantity fields into a number field and to change the record creation date to a date field named Registration date.
1. Select a field to set its data type | 2. Enter the name of the new field | 3. Select the new data type for the field |
---|---|---|
Subtotal | Subtotal | Number |
Created datetime | Registration date | Date |
While changing the Created datetime field to a Date field, value of the time portion is truncated. |
This example demonstrates how to convert a text field into a radio button or a checkbox.
When a text field is changed to a radio button field, the changed radio button selects the item that matches the value of the original text. When a text field is changed to a checkbox field, the changed checkbox splits the original text using a separator and selects multiple items that match the value of the separated text.
1. Select a field to set its data type | 2. Enter the name of the new field | 3. Select the new data type for the field |
---|---|---|
Text1 | Radio button | Radio button |
Text2 | Checkbox | Checkbox Separator: Comma |
Below table indicates the field types that can be changed using Set Field Type command.
Field type before change | Field type after change | Remarks | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Text | Rich text | Text area | Number | Radio button | Checkbox | Multi-choice | Drop-down | Date | Time | Date and time | Link | User selection | Department selection | Group selection | ||
Text | 〇 | 〇 | 〇 | 〇 (*1) |
〇 (*2) |
〇 (*3) |
〇 (*3) |
〇 (*3) |
〇 (*1) |
〇 (*1) |
〇 (*1) |
〇 (*1) |
〇 (*7) (*8) |
〇 (*7) (*8) |
〇 (*7) |
|
Rich Text | 〇 | 〇 | 〇 | |||||||||||||
Text area | 〇 | 〇 | 〇 | |||||||||||||
Number | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Calculated | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Radio button | 〇 | 〇 | 〇 | 〇 | 〇 | |||||||||||
Check box | 〇 | 〇 | 〇 | 〇 | 〇 | |||||||||||
Multi-choice | 〇 | 〇 | 〇 | 〇 | 〇 | |||||||||||
Drop-down | 〇 | 〇 | 〇 | 〇 | 〇 | |||||||||||
Date | 〇 | 〇 | 〇 | 〇 | 〇 (*4) |
|||||||||||
Time | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Date and time | 〇 | 〇 | 〇 | 〇 (*5) |
〇 (*6) |
〇 | ||||||||||
Attachment | 〇 | 〇 | 〇 | Only file name of attachment is saved in the changed field and the file itself is discarded. | ||||||||||||
Link | 〇 | 〇 | 〇 | 〇 | ||||||||||||
User selection | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Department selection | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Group selection | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Lookup | 〇 | 〇 | 〇 | 〇 (*1) |
〇 (*1) |
〇 (*1) |
〇 (*1) |
〇 (*1) |
||||||||
Record number | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Created by | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Created datetime | 〇 | 〇 | 〇 | 〇 (*5) |
〇 (*6) |
〇 | ||||||||||
Updated by | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Updated datetime | 〇 | 〇 | 〇 | 〇 (*5) |
〇 (*6) |
〇 |
(*1) When changing to the Number, Date, Time, Date and time, and Link fields, if a value that cannot be saved in the changed field type is detected, the original data is discarded and blank is set.
(*2) When changing to a radio button field, if output app field does not have the same selection as value before the change, the original data is discarded and the first selection item is selected.
(*3) When changing to either of checkbox, multi-choice, or drop-down fields, if field of the output application does not have the same selection item as value before change, the original data is discarded and the item is output without any item in selected state.
(*4) When changing to the Date and time field, "00:00" is set for the time part.
(*5) When changing to a Date field, value of the time part is truncated.
(*6) When changing to a Time field, value of the date part is truncated.
(*7) When changing the User selection, Department selection, and Group selection fields, if a user, department, or group that does not exist in the domain is detected, the original data is discarded and blank is set. The existence of the value before it is converted within the domain can be verified using the Data Check command's existence user check.
(*8) When changing the User selection and Department selection, if multiple user names or department names existing in the domain are detected, the original data is discarded and blank is set.
Field type before change | Field type after change | Remarks | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Text | Rich text | Text area | Number | Radio button | Checkbox | Multi-choice | Drop-down | Date | Time | Date and time | Link | User selection | Department selection | Group selection | ||
Status | 〇 | 〇 | 〇 | 〇 (*9) |
〇 (*10) |
|||||||||||
Worker | 〇 | 〇 | 〇 | 〇 | ||||||||||||
Category | 〇 | 〇 | 〇 |
(*9) When changing to a radio button field, if output app field does not have the corresponding selection item, the original data is discarded and the first selection item is selected.
(*10) When changing to a drop-down button field, if output app field does not have the corresponding selection item, the original data is discarded and blank is set.