1 of 1 people found this helpful
You would need to modify your current calculation to be:
If [IsEmpty ( GetField ( Get ( ActiveFieldTableName ) & "::" & Get ( ActiveFieldName ) ) ) ]
If [ IsEmpty ( Get ( ActiveFieldContents ) ]
would be much simpler.
each portal row may have 3 to 5 time readings for measurements.
suggests that there may be a better way to do this so that you get one time entry per portal row instead of trying to record several on the same row.
thanks so much, this will save me a lot of pain.
I will look into restructuring as you suggest, but right now I'm trying to keep each field visit to the site as one record, because each time is for a different measurement taken during one visit. I am betting once this is done I'll realize the wisdom in your suggestion.
What you can do is have one record for each visit, but with a related table linked to that table of visits for recording the time values. This is more flexible because you can then record any number of time values in a given visit--thus allowing for changes in procedure that might require a different number of values for a single visit without having to redesign your solution to allow for more time values in a given visit.