Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Conditional Format

Conditional Format

Thread began 2/11/2012 8:48 am by john411474 | Last modified 2/11/2012 2:15 pm by Miguel | 1000 views | 1 replies |

2/11/2012 8:48 am | #1 john411474

Conditional Format

Conditional Format record set field

Displaying a set of records showing items on sale
Have a linked table showing item average and min price

tables
on_sale s,
price_history h

record set
s.Item, s.desc, s.size, s.price, h.avg_price, h.lowest_price

I would like d.price field to be red if lower than the p.lowest_price or blue if lower than the p.avg_price

Can you show me how to do this

thanks

2/11/2012 2:15 pm | #2 Miguel

Change it to your record settings or you can use the webassist utility this over here is manually depends on which extensions you have for that utility.

php:

<?php if ("".$recordset('price')  ."" < "".$recordset('lowest_price')  ."") {  ?><span style="color:#C00;"><?php } else{ ?>

<?php if ("".$recordset('price')  ."" < "".$recordset('avg_price')  ."") {  ?><span style="color:#003399;"><?php  } else{ ?>

<span><?php } } ?><?php echo $recordset('price'); ?></span>

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.