Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Conditional Value List / Date Calc


This topic is 6349 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

(I searched a number of different threads but couldn't find the answer to my question.) This ought to be relatively simple...I hope!

I have a radio-buttoned text field and a date field. When asked if a user had filed a report, he or she would choose either Yes - No - N/A from the value list; if Yes is chosen, I'd like the computer to beep with a message to appear that says, "Enter Date" and the user would enter the date.

However, if he or she changes is or her mind later and selects the No or N/A radio button, the contents of the date field would be deleted; I'd like a validation-type calculation where FM won't allow a date entered with either the No or N/A button pressed.

I tried writing a script and a calculation, but just couldn't "get it." As always your help is GREATLY appreciated! TIA for your replies.

Posted

WF7A:

One way to do this is to overlay invisible buttons onto the radio buttons. Each of these buttons would have a script attached. For your 'Yes' button, it would be something like:

Set Field [Your_Button_Field; "Yes"]

Beep

Show Custom Dialog [...set a custom dialog to allow them to enter the date field...]

For the other two, you would do something like this:

Set Field [Your_Button_Field; "N/A"]

Set Field [Your_Date_Field; ""]

To the user, it looks like they are just clicking on the radio buttons, and the rest is magic.

-Stanley

Posted

D'oh! Invisible buttons. I never would've thought of that.

MANY thanks, Stanley--I appreciate your help very much!

This topic is 6349 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.