|
SDI returns sample information for a Sample Definition ID or Name
SYNTAX:
SDI(ID/Name,Field)
ID/Name: The LC_SampleDef.ID or Name to identify the Lab Cal Sample Definition.
Field: The field in the Sample Setup table (LC_SAMPLEDEF). Common fields:
NAME
NEXTDUEDATE
NEXTDUESAMPLENUM
LASTSAMPLEDDATE
ID
DESCRIPTION
SAMPLESIZE
COLLECTIONTIME
LOCATIONID
CUSTOMERID
ASSIGNEDTOID
LABID
PICKUPCOST
SAMPLECOST
PREPCOST
MISCCOST
TASKUD1..9
SCHDSTARTDATE
SCHDENDDATE
ISCOMPLIANCE
LOCATION
EXAMPLE 1: Display the next time the TTHM Sample is due.
=SDI($B4,"NEXTDUEDATE")
Where B4 refers to the LC_SAMPLEDEF.ID of the TTHM sample. Note, could also refer to name in cell C4.
|