Jump to content

Multiple layout required fields


dmaxj

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

Recommended Posts

I have defined required fields for a table in my FM database. I will have the required fields spread over 4 layouts.

The trouble comes in when I click a button to proceed to the next layout. I get a message that says ' is required to proceed.'

But, the field names are on the other layouts that I am trying to proceed to by clicking a button.

Thanks

Link to comment
Share on other sites

No, there are no script steps involved.

I defined each field under Define Database to be required. I only use 5 fields on one layout and 5 field on another layout.

The user goes to Layout 1 and fills in the first five required fields. They click a button that that says go to Layout 2. This is when I get the message that says 'Fields 6-10' are required.

How can i handle this problem, because I cannot proceed to Layout 2 due to the other required fields not existing on Layout 1.

Link to comment
Share on other sites

have defined required fields for a table in my FM database. I will have the required fields spread over 4 layouts.

The trouble comes in when I click a button to proceed to the next layout. I get a message that says ' is required to proceed.'

This is the problem with field validations.

You might remove the field validations, and instead use navigation scripts to proceed from layout to layout. The navigation scripts can do the validations:

If [ isempty( field1 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field1 ]

Else

If [ isempty( field2 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field2 ]

Else

If [ isempty( field3 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field3 ]

Else

If [ isempty( field4 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field4 ]

Else

If [ isempty( field5 ) ]

Show message [ "Field missing data"; Ok ]

Go to Field [ field5 ]

Else

Go to Layout [ Layout2 ]

End If

End If

End If

End If

End If

Link to comment
Share on other sites

Yes, that was the problem !

Because those fields are all from the same record and the validation comes when you ask to FM to change layout.

A stripped version of Ender suggestion can be:

If [isEmpty(field1) or IsEmpty(field2) or IsEmpty(field3)or IsEmpty(field4) or IsEmpty(field5)]

Show message [ "you must complete the form !";Ok ]

Else

Go to Layout [ Layout2 ]

End if

Link to comment
Share on other sites

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