Exact Forms - Conditional Code (Including Checkboxes)
Just wanted to share this simple code as I know it has been asked on quite a few threads.
First, YES, you can insert conditional formulas into your Exact Forms. I have been doing it for years. No need to make extra fields.
BOOLEAN CODE: ~=if(f['80'] != true) {'O';}else {'X';}~
TRANSLATION: If field 80 does not equal TRUE than put O, otherwise put X.
TEXT CODE: ~=if(f['80'] != 'English') {'O';}else {'X';}~
TRANSLATION: If field 80 does not equal "English" than put O, otherwise put X.
(To make a "checkbox", in Word insert symbol 25A1 (white square) in place of O and 25A0 (black square) in place of X. You can also put in wording in place of O and X. Size the entire code to how large you want the symbol to be. It Amy look long and funny, but it will only show the condition text / symbol.)
P.S. I prefer to use !=, but feel free to use ==, or anything else you may need to.
------------------------------
QuickBase Girl
------------------------------