One form multiple users

Posted on 2011-10-04
Medium Priority
Last Modified: 2012-05-12
I have a form that must pass through multiple stations to be filled out completely each section must be filled out in succession example section 1 will answer 6 questions, then it needs to move onto section 2 who will answer 2 questions then section 3 then 4 and 5.

Ideally each section would be filled and locked so no other sections can change the data and at the end of the processing of each section it should save the data to a database the final submit should send an email to relevant people.

I would like to understand options to achieve requriements above and terminologies etc.

Question by:IT SSM
  • 3
  • 2
  • 2
LVL 39

Expert Comment

ID: 36916639
To do this you want to use a column in the database table for "status"... each step will save to the database, and the status flag will be updated as you go along.   So status = "station1" will be the initial setting and only station 1 will be abe to query up those records.  Once successfully saved (all questions answered) then you update the status column to "station2" and so forth.

At the end (the last station) update the status flag to something like "Complete" at that point the record joins all the other records in the database as Completed, available records.   If you prefer you can use a seperate table for this, or better yet, a VIEW that will prefilter the records.
LVL 16

Expert Comment

by:Gurpreet Singh Randhawa
ID: 36917128
hmm, i think i misunderstood the question

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.


Author Comment

ID: 36921369
myselfrandhawa, I think my post title is misleading. I have a single form that is divided into multiple sections, each section represents a stage in a process. Each time the form is filled in section 1 will fill in section 1 of the form the section two will fill in section 2 of the form. At the end it will pass through all 5 "process" sections and the form should be complete, I would then submit to the database to capture the data.

Author Comment

ID: 36921376
Can you please add a little more detail ie what is this process called? Do you know or have any examples I might look at of a working system or any tutorial sites I can visit. I am a newb to this and what seemed like a simple request is proving quite difficult.

BTW I am in Australia thus the delayed response/

LVL 39

Accepted Solution

gdemaria earned 2000 total points
ID: 36922164
OST-IS, it may be easier if we started working with your actual code/table/forms...   I could use tables that I make up, I hope you can translate them to your design...

Let's say the table is WORKFLOW, you would add a column, let's say STAGE, type Integer...
On the first stage, your page shows a list of the WORKFLOW records where STAGE = 1... the user selects a record, enters all the data and saves it.... as part of the save action, you update the column to STAGE = 2.

Now that record will no longer appear on that form, because that list only shows records where stage = 1.  But it will appear on the next section's screen... the one where stage is always two.   On that page you make sure you filter records show show WHERE STAGE = 2.

When you save that, be sure to SET STAGE = 3.

At the end of all the stages.   Set the STAGE = NULL which means it has passed all stages.

If feel like I pretty much repeated myself, so sorry if that didn't help.  Please ask me more specific questions or let's just start working on the code.... show what you have and when you get stuck.


Author Closing Comment

ID: 36922333
Thanks mate that was what I was looking for this is a good place form me to start which is exactely what I was after


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses
Course of the Month15 days, 9 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question