AnsweredAssumed Answered

Toggle script for individual field

Question asked by jrimback on Oct 20, 2013
Latest reply on Oct 21, 2013 by philmodjunk

Title

Toggle script for individual field

Post

     The objective is to create a field that toggles (with a mouse click) between a character (preferably always X) and null (or blank).  [The representation of checkboxes in SQL Server is cumbersome to work with in SQL.]

     The reference (included below) seems close to this spec, but I am unable to get it to work.  A solution for the error in the attached .jpg or some alternate script would be appreciated.

http://filemakermisc.wordpress.com/2012/09/17/toggling-boolean-or-onoff-indicators/

     [FM Pro 12 Acvanced]

     [S Chamblee - thanks for the solution (border) last night.]

ToggleScript.jpg

Outcomes