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

go to field based on if statement


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

Recommended Posts

Posted

Hope I'm in the right part of the forum. Here's what I need to do.

You tab to Field 1 and enter the data.

Based on Field 1 (if such and such) you either go to Field 2 for entry or Field 3.

If you go to Field 2, based on the data in Field 1 you may either be sent to Field 3 where the data from Field 2 is copied but you are alklowed to change it, or based on that data in Filed 1 you may skip Field 3 and move on to Field 4.

I hope I made it clear.

Any help on that?

Thanks,

Mike

Posted

I have a database with Field 1 and Field 2. On a report, the body contains information per record including Filed 1 or Field 2. It's based on an IF statement. How do I get the report (if possible) to show either Field 1 or Field 2 based on that condition.

Mike

Posted

Please provide a small file showing an example of the logic and data and these four fields so we can understand the purpose and context of your request. Thank you. :^)

Posted

Field 1 = When a child is going to camp

Field 2 = Childs bunk for July (only if they are coming in July)

Filed 3 = Child bunk in August (only If they are coming in August. Also, if they are coming in August, automatically insert Julys bunk into August bunk with the ability for the user to change the August bunk. That's because most campers coming for July and August stay in same bunk)

Field 4 = next filed - whatever it is

Thanks

Posted

How do I get the report (if possible) to show either Field 1 or Field 2 based on that condition.

Try conditionally formatting both fields, so that one of them is displayed in 500-pt font size (which makes it invisible).

Based on Field 1 (if such and such) you either go to Field 2 for entry or Field 3.

I don't think that's possible in version 9. In later versions, you could use script triggers to override the layout's tab order.

Posted

In conditional formatting can you tell me how to set the size to 500 pt. I know there's a function where you give the field and the size, but in the conditional formatting you're already in that filed.

Mike

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