(Jun 27th, 2009, 10:52 AM)Ben Wrote: So you have about 200 clients, each of which need to view a specific subset of the form data. Is this subset a particular set of submissions, form fields or both?
In my case, there are about 200 companies that have posted data related to their employees and of course each one should must be able to see and edit only their own data, and not the ones related to other companies. They all use the same subset of submission - each one made by the same number of fields. The general admin can see the full set of fields, because my client need to add a full series of data that are "hidden" by the companies using the same system.
(Jun 27th, 2009, 10:52 AM)Ben Wrote: In terms of the UI, how would you like it to work? So when you create a new client, how would you map that client to your data subset? e.g. would there be a new field in the Add Client page that said "use View X", or would there be something in the View itself (where?) that would dynamically assign itself to the client based on ID, name or something else.
I believe the easiest and most practical way would be adding a column to FT "Database" tab/edit page from where a user can tick each field that need to be viewable/editable by the client related to that form. Alternatively, a single field where the admin can write all the DB column names that should be viewable/editable by the client. And in the FT main client edit page, another tickable field where the admin can choose to activate the "reducted client data set", so that each client may be configured to view only a reduced set of its own data (and nothing else on the same database), maybe checking that this function is activated if client name on the FT interface = client name on one of the fields in the form database.
Hope this helps!