Sample usage for Conditional Manual Data Entry (CMDE)

The following examples illustrate how CMDE formulas can be used for conditional data entry.

Example

If (IsUnknown(CurrentValue("Tag1")), Skip(), If(CurrentValue("Tag1")>175, ClockSchedule(), Skip()))

If the value of Tag1 is not filled in for the tour yet then skip data collection, otherwise, if the current value is greater than 175, use the Clock Scheduling to determine the tag due status, if the current value is not greater than 175, then skip data collection.

Example

If(CurrentValue("Tag1")+CurrentValue("Tag2")<=100, CollectNow(), Skip())

If the sum of current values for Tag1 and Tag 2 is less than or equal to 100, then collect the data, otherwise, skip data collection.

Example

If(CurrentValue("Tag1")==DigCode("OPEN", "Tag1") || CurrentValue("Tag2") != DigCode("Stopped", "Tag2"), CollectNow(), Skip())

If the current value of Tag1 is OPEN or the current value of Tag2 is not Stopped, then collect the data; otherwise, skip data collection.

Example

If(CurrentValue("Tag1") <=DigCode("State50", "Tag1") && CurrentValue("Tag1") >= DigCode("State10", "Tag1"), ClockSchedule(), Skip())

If the current value of Tag1 is between State10 to State50 inclusive, use the Clock Scheduling to determine the tag due status; otherwise, skip data collection.

Example

If(TourTime() - LastArchivedTime("Tag1") >7, CollectNow(), Skip())

If Tag1 has no archive values in the last 7 days then collect the data; otherwise, skip data collection.

Example

If(TourTime() - PreviousTime("Tag1") >7, CollectNow(), Skip())

If Tag1 has not been collected for a previous tour in the last 7 days then collect the data; otherwise, skip data collection.