Links

Select

Overview

With this widget, you can manage controlled vocabulary items using dropdown menus.

Select

Use this widget to choose a value from the dropdown list. The items of the dropdown list are defined in the default value field of column settings. The widget can be used for controlled vocabulary.
Readonly view:
Edit view:
Form view:
Same as the edit view.
Configuration
[
{
"color": "#9c27b0",
"option": "Option 1"
},
{
"color": "#01579b",
"option": "Option 2"
},
...
]
Default value
Option 1 # the value of a option
Import value:
One of the provided option. For example: Option 1

MultiSelect

Use this widget to choose multiple values from the dropdown list. It is identical to the Select widget except that more than one value can be selected.
Readonly view:
Edit view:
Form view:
Same as the edit view.
Configuration:
The configuration is identical to the Select widget.
Default value:
Option 1, Option 2 # multiple values
Import value:
List of options separated by "comma(,)". For example: Option 1, Option 2

ForeignKey

Use this widget to link to one other record. The linked record is clickable.
Readonly view:
Edit view:
Form view:
Same as the edit view.
Configuration
EP,SP # List of Unique Code separated by ','.
# Leave it empty to include all tables
Default value
{"sid": "xxx", "name": "xxx"} # Python json
Import value:
The UID of the record. For example: EP1
The name of the record. For example: My experiment 1

ForeignKeys

Use this widget to link to many other records. The usage is the same as ForeignKey.
Readonly view:
Edit view:
Form view:
Same as the edit view.
Configuration:
The configuration of ForeignKeys is identical to ForeignKey
Default value
[
{"sid": "xxx", "name": "xxx"},
{"sid": "xxx", "name": "xxx"},
] # Python json
Import value:
List of UIDs separated by "comma(,)'. For example: EP1,EP2
List of names separated by "comma(,)'. For example: Experiment 1, Experiment 2

Member

Use this widget to choose a member. Use this widget to assign a task to a member.
Readonly view:
Edit view:
Form view:
Same as the edit view.
  • Only the active member is choosable.
  • The widget is searchable. If you did not find the member you want, type in a name at the top of the dropdown.
Configuration:
{
"name_display": "full_name",# or initials
"team": {"sid": "xxx", "name": "xxx"}, # (optional) - team sid to limit team member to be selected
"should_notify_member": true,
# (optional) - should create an notification, default to false, optional
"subject": "xxx", # (optional) - email subject
# subject variables
# {{UID}} - the UID of the current record
# {{NAME}} - the Name of the current record
"body": "xxx", # (optional) - email body
# both subject and body support the following variables
# {{UID}}
# {{NAME}}
# {{ROW}} - the current row with link
"should_email": false, # (optional)
# should sent an email anyway, default to false
}
Default value:
{
"name": "", # name of the member
"sid": "" # sid of the personnel
}
Import value:
User name in the format of "[First name] [Last name]". For example: John Goodway

Members

Use this widget to choose multiple members. The usage is saved to the Member widget.
Readonly view:
Edit view:
Form view:
Same as the edit view.
Configuration:
The configuration is identical to Member
Default value:
[
{
"name": "", # name of the member
"sid": "" # sid of the personnel
}
]
Import value:
List of names separated by "comma(,)" in the format of "[First name] [Last name]". For example: John Goodway, Jim Sam
Last modified 10mo ago