Popular Content

Answered via our support ticket, but for anybody else running into the same issue, the problem is probably that you're using JDBC (the default) instead of XML. JDBC is faster and generally more efficient, but to filter records with JDBC, you do it with a custom SQL qualifier in the same screen as the primary key pulldown menus. The MirrorSync customization script is totally ignored on the server when using JDBC (because JDBC cannot call scripts).

Hi Lewis,
Glad you got figured out and thanks for updating the thread with how you fixed it!
Of note, the title at the top of the window having the "null" value is expected behavior for a new configuration. That null value will change to the name of the configuration once you complete it and go back and edit it.

Obviously, you have a sub-optimal structure. You should have a separate record for each response (I am assuming that your records are actually the responses to the 12 questions, not the questions themselves - as could be understood from your description). So instead of having 24 fields x 1,200 records, you will have 2 fields x 14,400 records* - and producing the required report will become trivial.
---
(*) More precisely, it will be 3 fields - because you have to add a QuestionID field.

Hi There
The new FileMaker Licensing for Teams model is not really suitable for 'anonymous' logins via WebDirect since you have a fixed number of licenses. That licensing model is designed for teams who have a known number of members. The 'legacy' licensing model (previously known as AVLA or VLA) is not much better for your use-case, since you still have to stipulate a number of users.
I would suggest that if you want to use FileMaker (and who wouldn't!) you could use custom web publishing & PHP to access and manipulate your data. It can be tricky to debug when you first start using it, but it is very straightforward so long as you have someone who can design the HTML for you. It does not rely on the number of licenses you have, and so long as your server is fast enough there is no practical limit on the number of simultaneous users.
FileMaker 16 will bring new API access to your server data according to their roadmap, and I'm sure CWP using PHP will be deprecated at some point in the future, so you may want to wait for that version and see if it suits you better.
You could call your local FileMaker sales team and run your scenario past them, as they sometimes have ideas on how to fit their license model to suit your needs.
Hope that helps.

You can use portal filter to do "finds" on data once you have defined a basic relationship.
You can also use the FIleMaker web viewer plus "collector scripts" to gather information and display it in tabular format in a web viewer.
Look at some of the reports in the example file available here:
http://www.filemaker.com/products/filemaker-pro/web_viewer.html