Knowledge Base / FAQ - LabCollector

Frequently Asked Questions

Custom fields type
For each type of custom field, you will see in this KB views for the creation step, editing record, and view record modes.  

Take note that creating and modifying custom fields requires an admin or super-admin account.  
Actions for viewing/using/editing each field after they are created can be done with other user account types in the modules.  

  • To create custom fields, go to ADMIN > Data > Custom fields and choose your module on the left. You can also refer to the KB-36 and KB-118 for 5.2 version and more.

image

Selecting Custom fields brings up the following screen: 




For each type of custom fields, you will see in this KB views for: 

  • Creation step:
    To create custom fields, go to ADMIN > Data > Custom fields and chose your module on the left. You can also refer to  KB-36 and KB-118
  • Editing record:
    When you create a record (Add new record button 048-doc_edit.gif on the top right of each module) or, if the record exists, use the icon 
    at the right of the summary line of your record.
  • Record mode:
    The view record mode corresponds in each module to the view when you use the  icon 121-details.gif at the left of the record summary line.


1. Text fields
They can have fixed (50, 100, 250 characters) or unlimited size (text editor).

Creating a Text Field:

image

Editing a Text Field:
Text Fields limited to 50, 100 or 250 characters appears as a single line when making edits.  The text editor tools only appear if Long Text is selected.

image

Record view mode:

image


2. Decimal number NEW
It produces an empty field area on form which can be filled by decimal numbers.

Creation step:
image
Since 5.3, aberration verification can be setup. If you enter at least 5 values in the same range, all values outside the average (+/- standard deviation) will give you an alert message.

Editing:

image

Record view:

image


3. Autocomplete fields
They allow you to complete field with an autocomplete system based on record name from the module you choose.
This function is very useful to quickly create a link to another related record by simply entering 1-2 letters of the linked record name. This field type is necessary to create a search in field. See Search into section in this KB.

Creation step:
image

Editing
:
image


Record view:


The link is active, and when you click on it, the associated record opens in a new tab of your browser.

image

4. NCBI autocomplete fields
They allow you to complete fields with an autocomplete system based on NCBI records from the database you choose.
This function is very useful to quickly create a link to NCBI records by simply entering the number of letters that you choose (edit the field) of the NCBI record name.

Creation step:
image


image

Editing:
Based on Taxonomy NCBI database. First, select the genus then the species in the selection list.
image










Record view:
The field is filled with genus + species and the NCBI link to this genus record.

image


5.
URL link
This type of field allows a link to be saved and displayed as a clickable Internet or server address.


6. GPS coordinates
This type of field allows a link to google maps. Coordinates must be in decimal degrees format.


Editing:

image

Record view:

See just above.

URL link opens directly a new tab with the URL.
GPS coordinates link opens a google map tab.




7. Select lists

These fields have predefined values presented as a list. Only one choice is possible.
You can add as many as values as you want.

You can also use this type of field to organize your record and thus create value dependent fields. See the KB-36 for more details.

Creation step:

image

image
  1. Add a value
  2. Give a name
  3. If you check this box, this value will be the default value.
  4. When it's possible (not used), you can delete this value with this button
  5. Save values
  6. If you have a lot of values to add, you can upload a CSV file with one column.

Editing:
image
All level permission except user can add value during edition by using Add/Edit values link.

Record view:
image


8. Multiple choice select list
These fields have predefined values presented as a list. Multiple choices are possible.

Creation step:

Values can be edited and configured as for select list values.

Editing:

image

Use the CTRL key to select more than one value.

Record view:

See just above.
All level permission except user can add value during edition by using Add/Edit values link.


9. YES/NO select
This field has two predefined values: YES and NO. Only one choice is possible.

You can also use this type of field to organize your record and thus create value dependent fields. See the KB-36 for more details.

Creation step:

image

image

Editing:
Record view:

See just above.


10. Checkbox

These fields can give predefined options to check. Multiple choices can be checked.

Editing:
image

All level permission except user can add value during edition by using Add/Edit values link.


Record view:
image


11. Date

This field is a text box with pre-formatted date. A calendar appears to choose the correct date easily or you can use the button TODAY for the date of the day. The customs field calendar accepts years from 1900.

Editing:

image

Record view:

image

12. Time NEW
This field is a text box with pre-formatted time. A select list from 00:00:00 to 23:30:00 appears to choose the time easily or you can use the button NOW for the current time.  Use with care if you have multiple sites in different time zones.

Editing
:


image


13. Database upload and Disk folder upload

With these fields, users can store document files directly into the database or in a disk folder. Files are then accessible from the record itself.
For image files, this custom field type shows an image preview in the record directly. We suggest if you upload large file, to prefer Disk folder upload to avoid a large database file.

Editing:
image
Just click on Upload button to find your file. All file types are possible.

image
If you want to delete a file just use Delete Current Files link.

Record view:

See above for PDF, for example. Use the link to download the file.

image
Record view if you upload an image


14. Link
This field type allows you to link your new record to another one in any module. Multiple links can be added in the same field.

Creation step:
image

You restrain the search to a unique module.

Editing:
image

Click on Pick button to select other records. You can use the search function and select all the records using the + button.

Record view:

image
Each link is active and opens a new tab.


15. Tracking link
This field type allows you to use a general URL and then to associate a specific ID to each record. It is useful to follow shipments for example.

Creation step:

image

Under the setup tab when you create the field, enter the general URL. Here for example, the URL corresponding to our Knowledge base.


Editing:
image

In the field, only enter the ID/the variable corresponding to the tracked element.  


Record view:

See just above.

The link is active and opens a new tab.

16. User Select List NEW
This field allows to choose a user in the list of LabCollector users.

Editin
g:


image

Record view:


17. Search into

This field allows the link of one master record to several sub-records in another module. If you have created an autocomplete field first (see section 3 of this KB), this field allows you to make a search on autocomplete fields. This function allows you to show a list of record links.

Creation step:

image

Choose the module where you created your autocomplete field, then the autocomplete field.


Editing:
There is no edition mode for a such field, LabCollector does the search automatically.
You just have to fill the autocomplete field. For this example,  you can see the field Autocomplete based on Strains is filled for 3 records in the module Custom fields with the same strain Pl_SPS1_I5.

Record view:

image
In Strains module, for Pl_SPS1_I5 record, there is an automatically active link Search Records, which opens a new tab:


the Custom fields module, where LabCollector searches automatically all the records with the autocomplete field filled with this strain and will find the 3 records.


18. Line separator
This last field type is for design. It allows you to divide your record into sections for easier viewing. Place fields of each section, below this field.
Under the search options, this line separator appears like a folder to organize your search filters by section.
Under Analysis tab, this line separator appears like tabs to organize your fields (see section Analysis tab in KB-36 or in KB-120)

Editing:
image

Record view:

image

Under the search options, the line separator is a folder in which you find the fields with filter option.
image



Have a question about this article?


 Last updated Wed, Mar 30 2016 4:30pm