1 Reply Latest reply on Sep 5, 2012 4:10 PM by philmodjunk

    Skipping fields



      Skipping fields


      I might need to create a basic survey with FileMaker Pro 11.  The survey will require skip patterns.  For example:

      Question 1:  Is your favorite sport baseball or football?

      Question 2:  What is your favorite baseball team?

      Question 3:  What is your favorite football team?

      Question 4:  What state do you live in?

      If the respondent answers "baseball" to Q1, go to Q2.  Then skip Q3 to go to Q4.  If the answer is "football", skip Q2 and go directly to Q3, then on to Q4.


      How do I tell FileMaker to go to a specific field based on the response in the current field?  FileMaker is being used as a data collection tool only.  The data will be exported into a statistical package for analysis.  At this point, data structure will be a single table with: Field 1 = Respondent ID, Field 2 = Question 1 response, Field 3 = Question 2 response, etc.



        • 1. Re: Skipping fields

          These questions should each be on a different record rather than different fields of the same record. Then the code that kicks in when you submit a response to a question finds the appropriate next record rather than the next field.

          take a look at this link for a description of how you might set up a Survey taking system in FileMaker: Need aid on generating a report from a survey layout.

          Once you have a better structure for your survey taking, you can revisit how to use the QuestionID and the Response value selected to look up the ID of the record of the next question to be asked.