Conditionally Show Fields on Results Page

[LimBL]

Hi. I like to conditionally show a field on results page. can that be done?

eg if field1 is "Apple" then field2 show "Red" else field2 will be hidden

thanks

 

[Mathilda]

Hi, you may try using case statement, however you will not be able to hide the calculated field. 

[ChrisCarlson]

yes you can, on the details page add a section and under it a virtual field set as display only, label it FIELD1, then set onload parameters as datasource FIELD1. Then add the actual FIELD1 database field as a text field and hide it using HTML block before with <table style="display:none;"> and HTML block after with </table>. Then under rules setup rule for FIELD1 if not equal to red, hide the section (which will hide the Virtual field that displays actual FIELD1 if not red, otherwise it will display the Virtual FIELD1 field if result is red.) You need the virtual field in order to set the actual field as text so that you can setup the rule. If actual field is display only then you wont be able to setup a rule on it.

[LimBL]

Thanks Guys!! You have been a fantastic help!!