Sample Table Form

<< Click to Display Table of Contents >>

EQuIS 7  >>  EDGE > Forms >

Sample Table Form

The Sample Table Form can be used to enter field sample data for multiple locations in a single form. The form can record common field sample measurements (e.g. pH, ORP, Conductivity, etc.) as well as some custom parameters which may be added by the user.

 

This form saves data to the FieldSample_MultiLocation section of the EDGE format.

 

Setup

 

EDGE Field and Unit Remapping

 

In order to use this form, remap records must be created for CAS_RN and unit values. The attached EDD example remap records needed to use this form. Replace the INTERNAL_VALUE column to match existing CAS_RN and unit values used in RT_ANALYTE and RT_UNIT, then upload to EQuIS using the EDGE Configuration format. Some unit values, noted in the table below, must be configured in the EDGE Configuration Plugin in the FieldSample_MultiLocation format section.

 

Custom Parameters

 

To define parameters not found in the FieldSample_MultiLocation section, configure the "cas_otherX" fields in the remapping EDD and "cas_otherX_unit" in the Configuration Plugin.

 

The table below defines the EDGE field parameters for the Sample Table Form and where to configure their remapping and units.

 

Parameter

Configure Remap

Configure Units

field_temp

set in RT_REMAP_DETAIL

set in RT_REMAP_DETAIL

field_do

set in RT_REMAP_DETAIL

field_do_units: set in Configuration Plugin

field_ph

set in RT_REMAP_DETAIL

set in RT_REMAP_DETAIL

field_orp

set in RT_REMAP_DETAIL

set in RT_REMAP_DETAIL

field_cond

set in RT_REMAP_DETAIL

field_cond_units: set in Configuration Plugin

field_color

set in RT_REMAP_DETAIL

set in RT_REMAP_DETAIL

field_odor

set in RT_REMAP_DETAIL

set in RT_REMAP_DETAIL

field_sheen

set in RT_REMAP_DETAIL

set in RT_REMAP_DETAIL

vol_bailed

set in RT_REMAP_DETAIL

set in RT_REMAP_DETAIL

recharge

set in RT_REMAP_DETAIL

set in RT_REMAP_DETAIL

cas_other1

set in RT_REMAP_DETAIL

cas_other1_unit: set in Configuration Plugin

cas_other2

set in RT_REMAP_DETAIL

cas_other2_unit: set in Configuration Plugin

cas_other3

set in RT_REMAP_DETAIL

cas_other3_unit: set in Configuration Plugin

cas_other4

set in RT_REMAP_DETAIL

cas_other4_unit: set in Configuration Plugin

cas_other5

set in RT_REMAP_DETAIL

cas_other5_unit: set in Configuration Plugin

 

Create an EDGE RVF with the updated remapping records.

 

Setup Data Sections in EDGE

 

On the Form ribbon, click Setup, then choose one of the following sections to configure:

 

Facility General: opens Facility_ReadOnly data fields.

Sample General: opens FieldSample_MultiLocation data fields. Data added in this section will apply to all samples collected in the form.

Sample Data: opens FieldSample_MultiLocation data fields, these will appear in the form as a list of columns in a table structure.

 

After choosing a section to configure, a dialog appears with options to show or hide fields, re-caption the section or the field names, and set default values.

 

Note: The EDGE Sample ID Builder may be used to automatically create sys_sample_codes. If done so, make sure to include all data fields on the form which are required to generate the sys_sample_code.

 

Also in Setup, click Task Dependent to filter the rows visible in the table's grid based on the task selected in the Task Chooser. When enabled, only samples belonging to that task (ad-hoc or from SPM information) will display. Header (general) data will also change based on the selected task.

 

The Display menu on the Form ribbon allows users to:

 

Vertical (or Horizontal) Headers - Change the column headers in the form's table to read vertically or horizontally; this setting can help manage the size of the data table

General - Collapse or show the Facility General and Sample General sections

Show Table Only - Hides all data sections, window ribbons and the Task and Location choosers, maximizing the view of the table itself

 

When more rows of data are added than will fit in the screen, a scroll bar will appear. The header row will remain in place at the top of the table when scrolling down through the table records.

 

Note: the Max Sample Table Form Rows feature in EDGE Options can control how many rows of data will display in the table at any given time. The table height will increase until the user has added the number of rows defined.

 

Enter Data

 

1.Select a Task from the Task Chooser

2.If desired, select a location in the Location Chooser

3.In the Record section on Form tab of the Ribbon, click New

4.A prompt will appear with a number of options for creating new sample records based on locations selected in the Location Chooser, which don't have samples assigned yet, for SPM records, etc.

 

25153_new_record_zoom60

 

5.Enter data on the form

 

The image below shows data created using all locations without data.

 

25153-SampleTableForm