As the subject line stated, would it be possible to hide or show fields conditionally in view and or report, once the record is created and saved?
Here is a sample voucher that I would to create:
Created record after the following data entry
Surname: Mitchel
Age: 22
Gender: (X) Male (this radio button was selected)
(O) Female
Weight in lb.: 170
---------Form the newly added record----------------------------
I would like to view or print the above record after it has been created (conditionally) using the following examples:
If the radio button selected is female, I need the view or print reports that would hide the Age and weight fields, preferable truncating the remaining filled-in fields, else if the radio button selected is male, show all 4 fields.
Example view / report 1:
Surname: Mitchel
Age: 22
Gender: Male
Weight in lb.: 170
Example view / report 2:
Surname: Mitchel
Gender: Female
In addition, is it also possible to hide fields that are left blank, truncating all remaining fields in view and or reports?
Created record after the following data entry
Surname: Mitchel
Age: (was left blank in data entry)
Gender: Male
Weight in lb.: 170
Example view / report 3:
Surname: Mitchel
Gender: Male
Weight in lb.: 170
Please note: the Gender and Weight fields moved up since the Age field was left blank.
***Any insight would be greatly appreciated.
Thanks - Elie