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.

Survey with several question types

Featured Replies

  • Newbies

Hello all,

I am a beginner to Filemaker Pro and hoping for some advice. Also, apologies if this has been addressed already.

I'm creating a survey database for school based health centers; this survey is meant to either be filled out by students on a computer, OR enable a research analyst to quickly enter the data from paper based forms.

After reading several threads on this forum about survey design, I think I have a decent model (please see attached).

As depicted in the diagram below, I have split the relationship graph into two components. The top half in yellow represents survey responses with unique combinations of questions and responses. The bottom blue-green half contains the model for the survey---it's conceivable that the stakeholders will want different surveys in this database.

The main difficulty I run into is the variety of response types. For this survey there are three types of responses: most are multiple choice; some are free text entry (e.g. how old are you?), and one is a checkbox response (e.g. check all the issues that apply). As it stands I have a layout based on the table "Filled out Surveys", with a portal that points to Questions 2. This allows me to display all the questions in order. However, it doesn't permit me to change the field according to the question type. Am I missing something or do I need to change my approach? Any help is greatly appreciated!

Best,

Chow

DataModel.png

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.