I am not even sure if scripts is the right way to go, but here is my question.

 

We have a huge database with questions that were asked.  Each user has, lets a social security number.   We want to put all of their answers together in different columns.   So there are about 20 different questions that need to be pull out of that data per person, and then put into a report, or another table so we can view all of the users, vertical, and all of their answers to the questions, horizontally(the columns names).  How is this possible? 

example:

One table has all of the names in it with their SS#.    Each question has their Name and SS#, so the SS# could be the part that joins the tables together.     I now need to bring the data in to the Question fields that they answered.   

How do I make the question columns pull the data out of the database?  

 

Name       State      Zip     Male/Female           Education         Job Title          Question1           Question2            Question3

 

 

 

This is known as a Pivot table there are several ways to produce this:

Virtual Lists: https://filemakerhacks.com/category/virtual-list/

JavaScript: https://carafe.fm/bundle/pivot-table-widget-studio/