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

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

Recommended Posts

Posted (edited)

Pleae Help!!!

I have 4 fields.

The first field is called record status and it is a radio button with 3 values: Entered, Missing, and Not Applicable.

The other 3 fields are called ps1, ps2, and ps3 and they are all radio buttons with the following values: 1, 2, 3, -89, and -99

:P QUESTION: Where do i code and how do code so that if record status is checked Not Applicable then ps1, ps2, and ps3 will have the -99 radio button checked for all 3 fields?

Edited by Guest
Posted

Hi

you may set the AutoEnter/Replace options of those 3 fields with this calc:

Case(

recordStatus = "Not Applicable";-99;

""

)

Posted (edited)

Thank you for your reply.

So in other words, i would set this calc in the ps1, ps2, and ps3 fields as a calculation? It is not working. Please forgive me but i forgot to add to my previous question how to program if the user checks Missing in the recordstatus then ps1, ps2, ps3 fields would have the -89 radio button checked.

Edited by Guest
Posted

So the calc becomes:

Case(

recordStatus = "Not Applicable";-99;

recordStatus = "Missing";-89;

""

)

And it must work...but you have to remember to uncheck the box with "Do not replace existing value" when you have finished to enter this calc into the AutoEnter option of those fields.

Posted (edited)

Hello. Thanks, and you are most certainly correct, it does work!!!!Great, but if the user enters in the recordstatus the value "missing" then ps1, ps2, and ps3 should ONLY have a value of "-89" and not let the user change ps1, ps2,or ps3 to have any other value other than "-89". Currently it is allowing a user to enter into ps1, ps2, ps3 a value of 1, 2, or 3 even if record status is checked as "Missing". How can i stop this?

Edited by Guest
Posted

Oh Thank you so much. I really really appreciate it. I am new to FM and love it but get nervous sometimes because i have deadlines to meet.

Thank you this is perfect and awesome. I was so worried. Thank you a million

This topic is 6867 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.