October 26, 200520 yr Hopefully someone can set me straight on this. I've got a checkbox set for a field, using a value list. I want to be able to predefine which items are checked off, based on other info from the record (i.e. Province) In order to do this, do I need to create seperate fields for every check box item rather then using a value list? Example... Poster types. Value List: Poster 1 Poster 2 Poster 3 Poster 4 etc... If the Province is BC... I want Poster 1 and poster 4 to be checked off. Thanks, Scott
October 26, 200520 yr Ssancton, Just set the field if doing it by script. If Province = "BC" Set Field [checkbox; Poster 1 ¶ Poster 4 ] EndIf If you want to do it by a value in field, then in your field that uses value list as checkboxes... Create a calculated value. Case ( Province="BC" ;"Poster 1 ¶ Poster 4";Province="QB" ; "Poster 3"; Poster 4 ) Make sure 'Do not replace value...' is unselected.
October 28, 200520 yr Author Thanks Mr_Vodka, Works great. The only issue I have is when it gets more complex, i.e. having to overwrite a previous Case based on other variables(Using the non-scripted version). I'll play with it as time goes on though, you helped me get much closer. Thanks again.
Create an account or sign in to comment