Data Connections

Re: Refresh for second submission

Clay Fox — Wed, 11 Jun 2008 16:29:04 GMT

Yes, exactly.
Your submit should be via rules
first action submit main
2nd set query field
3rd query main

This would be how to submit and reset automatically in one click by the user.
All they will see is the form reset and a confirmation of the submit.

Re: Refresh for second submission

oldradio99 — Wed, 11 Jun 2008 12:42:36 GMT

I do not understand

Do you have a query that is not seen by the end user running on submit?

Re: Refresh for second submission

Clay Fox — Wed, 11 Jun 2008 02:20:42 GMT

Typically to reset a database type form I would put in an invalid query value. Such as an id value of 99999 or something and then query the main data connection.

This resets so you can submit again.

This also allows all of the data fields to be reset in one action instead of the fields individually.

Refresh for second submission

oldradio99 — Tue, 10 Jun 2008 20:47:52 GMT

I am using IP 2003 tied to a database

I have a new form that collects 2 data elements and upon submit, the 2 
fields go to the database.  That works well.

Because the form will get used throughout the day, rather than close the 
from, I just set the 2 values to blank after the database submission and 
leave the form open.

However, when the user submits a new request, the data is not going to the 
database table.  No error message - just the data never gets submitted.

Am I missing something simple as a way to keep the form open but clear the 
fields and accept a second submission?

Thanks

Art