Question

A Forms field filled by a stored procedure displays correctly but doesn't save to the variable unless form submitted by named user.

Forms

Updated April 29, 2014

asked on April 26, 2014

I have used the Forms help file to build a stored procedure that creates a permit number that fills in a read-only field.

When I create new forms it auto-populates the field perfectly from the database. However, when the form is submitted by an anonymous user (portal) the variable for that field is blank UNLESS I log in as a forms user and submit the form as a valid forms user then the variable is populated.

How do I make the form save the auto-populated field to the variable for anonymous users?

0 0

Answer

SELECTED ANSWER

replied on April 26, 2014

More testing... it seems to work if I don't set the field to read-only. What I had to do is create a Field rule to hide the field at all times.

Now, to figure out how to include the permit number in the Thank You form submission screen. Currently it just displays the name of the variable but the variable works in an email. Odd.

0 0

replied on April 28, 2014

Hi Jeremy,

Forms Thank You page doesn't support variable in 9.1.

This will be enhanced in the next Forms release.

Thanks for your feedback.

Best wishes,

Abby

0 0

replied on April 28, 2014

Any time frame on when that next release might be available?

0 0

replied on April 29, 2014

Next release is planned to be available in 2014.

1 0

Replies

replied on April 26, 2014

After further testing it doesn't seem to even be completely tied to whether it's a user or not. The odd time even when it's a logged in user submitting the form the permit number (auto-populated) still won't save into my variables.

If I go into the process and view the variables that field is blank even though it displays correctly in the read-only field on the form itself when submitting the form.

0 0

You are not allowed to follow up in this post.

Question

Question

A Forms field filled by a stored procedure displays correctly but doesn't save to the variable unless form submitted by named user.

Answer

Replies

Sign in to reply to this post.