BioloMICS menu

Field types

Full movie BioloMICS: Edit data in different field types (see below).

See also movies on how to add specific field types to a table: BioloMICS: Create a new field Advanced

See also movies on how to import data into specific field types: BioloMICS: Import advanced including Fasta

The field type is an important concept that will decide about the type and therefore about the properties of the field.

For the ease, we have groups the types into 3 categories: Administrative, Analysis and Other.

For most of the types, a link version is available too.

Administrative


Numbers	Text	Dates	Dropdown Single select	Files Pictures Documents	Hyperlink
D and I	E	H	T and V	F	U


Multi select	Range	Array	Synonymy	Ontology	Color
C	S	A and M	Syn	O	K

Analysis


Molecular, DNA, RNA, Protein	GIS Locality	Paired values	Gels
N	L	W	G

Other


General link to other table	Calculated field, Summary
R	Y

The following field types can be created by the BioloMICS software:

Field type	Explanation
A	Vector of discrete data (results from [-, +, weak], DNA chips etc.)
ALink	Link to vector of discrete data A
C	Vector of discrete data, 4 possible states each (unknown, variable, absent, present)
CLink	Link to vector of discrete data C
D	Continuous data, single value
DLink	Link to continuous data, single value
E	Text, administrative field
ELink	Link to text, administrative field
F	File content (blob field containing any file type - pictures, trace files, Word doc, Excel doc, etc.)
FLink	Link to a File (- pictures, trace files, Word doc, Excel doc, etc.)
G	Molecular weight from electrophoresis analysis
GLink	Link to Molecular weight series in another table
H	Date and Time
HLink	Link to date and time
I	Integer (up to 64 bit)
ILink	Link to integer
K	Color field
KLink	Link to color
L	GIS location (latitude, longitude, precision)
LLink	Link to a GIS location
M	Array of continuous data (absorbance values from microplates, DNA chips, etc.)
MLink	Link to array of continuous data M
N	DNA or protein sequence
NLink	Link to a sequence in another table
O	Ontology, a structured classification value
OLink	Link to an ontology field located in another table
R	Pointer to multiple records, link between tables using record IDs
S	Continuous data range (min, max)
SLink	Link to continuous data range
Syn	Management of the current name basionym, taxonomic and obligate synonyms
SynLink	Link to Syn field located in another table
T	Single discrete data representing the combinations of 4 basic states (A, B, AB, C, AC, etc.)
TLink	Link to single discrete data T
U	URL, hyperlink to websites
V	Single discrete data representing an unlimited number of states
VLink	Link to single discrete data V
W	List of paired values
WLink	Link to a list of paired values
Y	A summary field displaying data from other fields

https://www.youtube.com/watch?v=bzrDqQqwWyg

Movie can also be found on YouTube, BioloMICS: Edit data in different field types.

This movie shows how to edit data in BioloMICS for all the field types.

• A field (0:14)

• ALink field (0:33)

• C field (0:54)

• Clink field (1:17)

• D field (1:38)

• DLink field (1:44)

• E field (2:07)

• ELink field (2:29)

• F field (2:50)

• FLink field (3:09)

• G field (3:30)

• GLink field (3:50)

• H field (4:11)

• HLink field (4:28)

• I field (4:49)

• ILink field (4:57)

• K field (5:20)

• Klink field (5:32)

• L field (12:20)

• LLink field (6:16)

• M field (6:35)

• MLink field (7:14)

• N field (7:35)

• NLink field (7:49)

• O field (8:08)

• OLink field (8:24)

• R field (8:46)

• S field (9:06)

• Slink field (9:18)

• Syn field (9:37)

• SynLink field (9:58)

• T field (10:20)

• TLink field (10:26)

• U field (10:45)

• V field (11:12)

• VLink field (11:20)

• W field (11:41)

• WLink field (11:56)

The contents of Field types

Header fields

Administrative fields

Analysis fields

Other fields