At 11:40 AM 3/27/2012, Gustavo Urquizo wrote:
Is there a way to change the row color on a DB Lookup List View based
on a column result?, i.e. if column='Fail' change the row color to red.
Gustavo,
Yes, you can use the "Color Rows" option of Variable Lookup List View
Lookup Setting properties to achieve your goal.
Here's how:
Form Designer | Variable Lookup List View Properties | Lookup Settings
Based on the condition, you will have to either create a dynamic VIEW
to associate with Variable Lookup List View and assigned columns for
"Row Background Color Field" and "Row Font Color Field", or add two
columns in the table associated with Variable Lookup List View that
can be updated conditionally to assign "Row Background Color" and
"Row Font Color".
So, in your case, for learning sake, add the following two columns in
the table that is associated with Variable Lookup List View:
. RowBackgroundColor TEXT (16)
. RowFontColor TEXT (16)
Then, you can update the values prior to "EDIT USING formname", OR you
can use these two columns as "Computed" columns, as follows:
-- Example 01
RowBackgroundColor = (IFNULL(columnname,'RED',NULL))
RowFontColor = (IFNULL(columnname,'WHITE',NULL))
-- Example 02
RowBackgroundColor = (IFEQ(columnname,'Fail','RED',NULL))
RowFontColor = (IFEQ(columnname,'Fail','WHITE',NULL))
That's all there is to it!
Let me know if you need a sample application to demonstrate the use of
such options in R:BASE eXtreme 9.1 and 9.5.
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
