| | |
save as draft option
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
hii!!
i am making a form in which the user fills in the fields and finally submits the form, which is then saved in the database
i use asp
and javascript for validations.
the user can see, all the enteries as a list in another page.
Now, i have to give the user a "save as draft" option.
in which he can enter some fields and save the form and complete it later...
maybe , i can have a "save as draft" button on the main form, on pressing which, the validations are not carried out, and the form is saved in some another table..
and the list on which the user see's the added forms can have a "view drafts" link which opens up a list of "drafts"
when the user clicks on it, the user can fill in the form , and click on submit it ( now the validations are carried on, and the form is saved in the original table )
and the "draft" is deleted from the list after its "saved"
that is the basic idea i have....
I need help on how to go about it ?
i am making a form in which the user fills in the fields and finally submits the form, which is then saved in the database
i use asp
and javascript for validations.
the user can see, all the enteries as a list in another page.
Now, i have to give the user a "save as draft" option.
in which he can enter some fields and save the form and complete it later...
maybe , i can have a "save as draft" button on the main form, on pressing which, the validations are not carried out, and the form is saved in some another table..
and the list on which the user see's the added forms can have a "view drafts" link which opens up a list of "drafts"
when the user clicks on it, the user can fill in the form , and click on submit it ( now the validations are carried on, and the form is saved in the original table )
and the "draft" is deleted from the list after its "saved"
that is the basic idea i have....
I need help on how to go about it ?
I did something similar recently. Basically a form which requires approval before being saved.
So, I created a copy of the table which normally holds the form data.
On save, the data is saved to the copied table. Once approved, the data gets copied to the original table and the record deleted from the temp table. If course, it usually just as easy to create an extra field on the table called Published or Draft and use it as a flag to determine whether or not the validations should be carried out.
In my case that would work as I was dealing with edits to live data and still needed another place to store the draft edits before being approved and made available to the public.
If your just starting you could probably save some work and just use a flag to determine between "draft" and "saved".
So, I created a copy of the table which normally holds the form data.
On save, the data is saved to the copied table. Once approved, the data gets copied to the original table and the record deleted from the temp table. If course, it usually just as easy to create an extra field on the table called Published or Draft and use it as a flag to determine whether or not the validations should be carried out.
In my case that would work as I was dealing with edits to live data and still needed another place to store the draft edits before being approved and made available to the public.
If your just starting you could probably save some work and just use a flag to determine between "draft" and "saved".
------------------------------------------------------------
If you see no coffee in my immediate vicinity, speak slowly and use small words....
ConnectNL Directory | Blog
If you see no coffee in my immediate vicinity, speak slowly and use small words....
ConnectNL Directory | Blog
![]() |
Similar Threads
- Create TextField and Button dynamically (PHP)
- Outlook 2003 automatic reply to self (Windows NT / 2000 / XP)
Other Threads in the ASP Forum
- Previous Thread: onClick code behind not getting called--Firefox
- Next Thread: COTS application in ASP.Net
| Thread Tools | Search this Thread |
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection connection database databaseconnection dreamweaver excel fso iis msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption single specfic sqlserver sqlserverconnection windows7






