2. PHPRunner General questions
  3. Survey type application question
This topic is locked

Survey type application question

 		11/11/2008 08:54:24
PHPRunner General questions
C
 cafulford author

Hi, I am trying to figure out of phprunner can do a survey type of form with the following requirements:

  • it needs to be set up so customers can log in and only see their data
  • each customer can only enter data for 1 record
  • the 1 record will be very long and broken into sections
  • there needs to be a way to allow them to save the form and return back later to pick up where they left off
    The application is a global questionnaire to suppliers and they have to tell us what chemicals are in the materials they supply us.
    Thanks in advance for advice!
J
 		Jane 11/12/2008

Hi,
please see my answers below:

  1. to restrict user access select User can see and edit their own records only security method on the Advanced security settings dialog on the Security tab.
  2. you can create two or more custom views on the Datasource tables tab, select different fields for this views on the Choose fieldstab and use it as part of main add page.
  3. check number of records in the List page: Before process event on the Events tab and remove add button if needed.
T
 		thesofa 11/12/2008

Hi, sorry to butt in, but this seems to cover quite a few of the questions I asked here and I like the idea.

Just one question, if I split the list of 39 questions into batches of 5 or so using custom views, will the records be saved as a new record each time from the view_add page, or will the first page be saved as a new record and the remainder be saved as an update to the existing record?
G
 		garethpDevClub member 11/12/2008

Sounds to me like your second and future screens should be an edit record page and not add record page.
Only the first should be an add view.
After saving you can redirect to the next edit screen.
Hope this helps - sorry if not.
Gareth
T
 		thesofa 11/12/2008

D'oh, never though of that, nice one Cyril