Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Validations from 1 table across several layouts

Featured Replies

Hi All,

I'm creating a questionnaire for subjects in a psychology experiment. I have one table containing all of the questions, and have created a separate layout for each question (so one question appears per layout along with a "next" button advancing you to the next layout with the next question on it). I want to include validations such that people MUST respond to each of the questions before moving forward. When I have tried to do so, it seems that the program wants ALL of the conditions for the entire table met for each layout/question. For example, I complete question 1 (select a radio button number), then click next to move forward, but receive a pop-up informing me I must make a selection before I continue. Any ideas? I'm totally new to Filemaker, so any and all suggestions would be very much appreciated. Thanks.

Cheers-

Johanna

Johanna:

Create a different script for each "next" button, and do the validations there. Each script would look something like this (with the correct layouts/fields for that step of the process):

If ["IsEmpty(Field_In_Question)"]

Show Message["You must answer the question first!"]

Go To Field ["Field_In_Question"]

Exit Script

Else

Go To Layout["Your_Next_Layout"]

Go To Field["Answer_Field_In_Next_Layou"]

End If

Note that the "Show Message" step allows for up to three buttons. In your case, leave the first two buttons blank, and make the third one just say "OK" so as to prevent the user from getting confused ("Continue? Cancel? Cancel what?")...

-Stanley

You can also validate your fields by Status(CurrentLayoutName), e.g. not IsEmpty(field1) or not PatternCount(Status(CurrentLayoutName), "question1"), if your layout for field1 contains 'question1' in its name and no other layout does.

  • Author

Thanks SOOOOOOO much! Worked like a charm!

Best,

Johanna

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.