Hi everyone, I’ve been trying for couple of days now to create a radio button that will be dependent on other field. I’ve read a lot of discussions here, but still didn’t get how to properly create it. So I have two date fiels - Date opened and date closed, as well as I have two radio buttons - opened and closed. I want radio button to be selected automaticly, based on the filled field. So when date opened is filled, opened radio button is selected automatically, but if date closed is filled as well - closed radio button selected.
Thank you for your help!
So you have two Date Fields, respectively named Date_Opened and Date_Closed.
You create then a Opened_Closed Calculation with Result as Text and calculation =
Case (
IsEmpty ( Date_Opened) and IsEmpty ( Date_Closed); "";
not IsEmpty ( Date_Opened) and IsEmpty ( Date_Closed); "Opened";
not IsEmpty ( Date_Closed); "Closed";
)
Now on your layout:
The third field Calculation is duplicated and formatted with Radio Button. The left one with Value List = Opened and the right one with Value List = Closed. Then hide left calculation as follows: test::Open_Closed_Calc = "Closed" and hide right calculation as follows: test::Open_Closed_Calc = "Opened" or IsEmpty ( test::Date_Opened ). Also make sure that for both calculation fields Browse Field Entry is disabled (fourth tab of Inspector), in doing so, if user try to click in calculation field, there will be no warning message stating "this field is not modifiable".
Now slide right calculation on top of left (or vice-versa).
And then in Browse mode the Result is: