Another newbie question
Trying to work out a way of not ending up with too many fields.
I have a number field that uses the following calculation to compare a value, dependant on a gas appliance type, with one measured onsite, if the measured value matches or is below the value returned by the calculation formula, the conditional formatting stays green and states "OK" else it goes red and states "NO" (as in safe or unsafe)
It all works fine but I have five appliance readings to report in each record, seems wasteful to have to have five Case formula in the same number of fields especially if I need to edit values etc. If I used a global field is there a way to refer to Ap1typ or Ap2typ... etc using wildcards i.e. Ap*typ?
Well a little more info .. but is there always the five readings at each time? If there is always the five then a field per type might be appropriate. If the site of the reading and date is common, then the actual readings could be in a portal of a child-file.