Skip to main content
Question

Exact Forms - Conditional Code (Including Checkboxes)

  • February 1, 2021
  • 0 replies
  • 124 views

Forum|alt.badge.img+7

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
------------------------------
This topic has been closed for replies.

Are you using these with the in-product Exact Forms or with Juiced's Add-on, Exact Forms+ ?

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------