Does the conditional formatting look at all of the records in the database? Can it be set to format the record that you are browsing?
conditional formatting is layout-based, so it looks at the record you're displaying, not at all the records.
In other words, to answer your question, you don't need to do anything extraordinary because the mechanics of conditional formatting are already aligned with your desire.
OP might be referring to list view?
Thanks for the reply. I have attached a couple of screen shots, maybe you can help me.
Is the image you provided showing one record in form view or five records in list view?
only the record being browsed does not hint me towards list view, but everything is possible.
It is showing one record. The accuracy high limit and accuracy low limit values are calculations. Do you think that could be causing the issue?
what you're you looking at ? (one record, found records, all records)
what view mode ? (form, list, table)
what are you trying to do ?
I am looking at one record.
View mode is Form.
I would like the as found value to change to red if it falls outside of the Accuracy low limit and Accuracy hi limit values.
If this is list view you can use an OnRecordLoad script trigger for RefreshWindow script that defines Let($$ActiveRecordID = Get(RecordID); "") as the script parameter just to set the global variable before refresh.
You conditional formula would need to change to something like:
Self < LOW OR Self > HIGH AND $$ActiveRecordID = Get(RecordID)
I see depends on how the data is setup. It is not a portal right?
Do all of the Standard Values on the left have different field names?
I think we are getting closer with the formula. No it is not a portal and the field names are WHOLE NUMBER LOW LIMIT 20% AND WHOLE NUMBER HI LIMIT 20%
Thanks for all of the help. I am going to try a couple of variations of your formula and get back with you.
self < low OR self > high
Looks like you want to format a field value if it is not within two other values ... the high and the low limits. Use Formula instead of Value in the Conditional Formatting options so you get the use of the calculation engine ...
It seems near impossible for all the respective values for 200,490,600,800, and 950 to be in one table and have the same field name.
You are leaving out some table and relationship info here.
It may be repeated field.
I wonder the limit values have ±2, not 20%.
You might some parenthesis in that formula
( Self < LOW OR Self > HIGH )
AND $$ActiveRecordID = Get(RecordID)
Retrieving data ...