Question

Form view for download/print/email submission cutting off after database lookup

Forms Forms Layout Designer Version 11

Updated August 14, 2023

asked on July 31, 2023

We have the Forms option enabled to allow the submitter the option to download/print/email a copy of their submission. On a new process that we created, the submission copy is cutting off after the database lookup, they see none of their submission (the form) beyond that point.

We had a similar issue with downloads to the repository, but that was resolved by removing the field rules and lookup rules for the form copy that is stored to the repository. In this case, there is not an alternate form - just a copy of the original that uses the rules. Due to the fact that there were some funky things going on with hidden fields, and we are using hidden fields on this form, we installed the latest patch for V11 of Forms (#4) and this has not resolved the issue.

Has anyone else experienced this and been able to resolve it?

0 0

Answer

SELECTED ANSWER

replied on August 3, 2023

Do you hide HiddenTradeName with fields rule and set it with "Ignore the data when the field/section/page is hidden"?

If this is the case, after submission, the value of HiddenTradeName is not kept and revert to be an empty value. So that is why after submission the forms is different because HiddenTradeName is empty. You can check variables in your former submitted form in monitor page. HiddenTradeName should be empty.

To remedy this, use "Save the data when the field/section/page is hidden" instead.

0 0

Replies

replied on August 1, 2023

I tried to reproduce the issue, but everything looked fine. Could you explain how the lookup is setup and upload a screenshot if you can.

0 0

replied on August 1, 2023 • Show version history

I have attached a copy of the lookup rules (1) and field rules (2) as well as an image of what the submitter sees vs what the submitter should see after submission.

OC Contractors Lookup Rules.png (145.13 KB)

| Download

OC Contractors Field Rules #1.png (62.43 KB)

| Download

OC Contractors Field Rules #2.png (45.09 KB)

| Download

0 0

replied on August 1, 2023

What submitter should see vs what they do see...

What submitter should see.png (84.29 KB)

| Download

What submitter sees.png (82.66 KB)

| Download

0 0

replied on August 1, 2023 • Show version history

Look like HiddenTradeName decides what part of forms is showing. If City-Issued Account and Last 4 Digits of EIN/SSN is correct, it's supposed to show a list of input fields. But instead, it shows 'The combination you have entered does not match out records, please try again.' Am I understanding this correctly?

Just to make sure, have you checked that HiddenTradeName is populated correctly? Maybe City-Issued Account and Last 4 Digits of EIN/SSN is wrong? What if you enter the same City-Issued Account and Last 4 Digits and temporarily shows the HiddenTradeName, is it populated or is it blank?

If it's blank, then the behavior is expected. if it's not, then something is wrong with fields rule that it doesn't show correct content.

Btw, you said you installed the latest patch for V11 of Forms (#4). Is it Forms Update 4(11.0.2307.40547).

0 0

replied on August 2, 2023

Yes, you are correct, that is how we are using the HiddenTradeName. It populates that field correctly. No matter what combination of correct entries for City-Issued Account # and Last 4 Digits of EIN/SSN we enter, we successfully get the results back from the table and the form looks great until which time it is submitted.

If we enter the wrong combination, the "combination you have entered..." message displays, if we enter the correct combination, the messages displays after moving from City-Issued Account # field to Last 4 Digits of EIN/SSN and typing any key, then it goes away as soon as we click or tab out and if the entry is correct, everything then populates. If this is the issue, Is there a creative way to design the field rules so that it does not look for the entry in the Last 4 digits of EIN/SSN field until you've left that field? We are using this same concept on other forms and are not having this issue. BTW, I did remove the "combination you have entered..." message entirely from this form yesterday, and experienced the same problem.

0 0

replied on August 14, 2023

This setting change resolved the issue. Thank you for your help!

0 0

You are not allowed to follow up in this post.

Question

Question

Form view for download/print/email submission cutting off after database lookup

Answer

Replies

Sign in to reply to this post.