We use Filemaker for our Market Research database. In the scope of maintaining an accurate record of our market research participants we must have a field in our database that tracks all past studies each participant has ever participated in. However, we have come across an obstacle as we try to share that information with our market research study ‘recruiters’. We have utilized Instant Web Publishing of Filemaker that enables our recruiters to logon and view the participant records.
The “Past Studies” field is filled in with the data contained in four other fields. These fields, as seen below are “kf..”, “studyname”, “Study Date” & “Study Time”. We use the button as seen below “Move Current Study to Past” to move the data in “Past Studies”.
Here’s the problem:
As you can see below, in the field “Past Studies”, I am able to click into the field and view all the past studies of individual participants. This is what we want our recruiters to be able to see when they logon to the database via the Instant Web Publishing link.
But what they see is displayed below. How can we make this field a drop down field using the Instant Web Publishing link without giving the recruiters full access to change the records