AnsweredAssumed Answered

Simulating Radio Button Control with 2 boolean fields

Question asked by ericjlindholm on Jan 31, 2017
Latest reply on Jan 31, 2017 by JackRodges

I would like to simulate radio button functionality with 2 boolean fields. 

by that I mean, if one is set true, set the other false.

Right now I have a radio button text field with a value list containing 2 values.  and the 2 boolean fields evaluate if one or the other value is set in the text field

 

This is a bit brittle, relying on the text field.  I would prefer an auto enter calc on the fields isCustomer and isVendor but my numbers attempts have failed.  I know I can script something but I prefer to bake it into the data model where I can. 

 

example:

 

Currently -

Company::isCustOrVendorv is text field with radio button control with the value list Customer Vendor.

Company::isCustomer is a number field that auto evaluates  if ( company::isCustomerVendor = "Company" ; 1 ;"")

Company::isVendor is a number field that auto evaluates  if ( company::isCustomerVendor = "Vendor" ; 1 ;"")

 

1 of a few not functioning attempts -

 

Company::isCustomer Auto Enter Calc  if( isVendor; "" ; 1)

Company::isVendor Auto Enter Calc  if( isCustomer; "" ; 1)

 

Thoughts?

Outcomes