Laserfiche forms Dropdown Variable

asked on May 10, 2016

Hi, I hope you can assist me the following issue.

I have a dropdown field to upload documents in form1,please see uploaded JPG called Form1.Dropdown. The list of documents that you need to upload is determined by a lookup rule which is looking at an external table, please see uploaded JPG called 'SQL.Required.Documents'. In form2 I am using the same dropdown variable which also has the same lookup rule pointing to the external SQL table.

The issue I am facing is that the last document type value that I have selected in form1 is being transferred by the dropdown variable to form2. I understand why the dropdown assigns this value to the variable but my question is, why does the lookup rule on form2 not remove this value as it does not match up with the lookup rule.

My resolution would be to clear this dropdown variable before moving the data to form2.

Please let me know if you have any suggestions on why this could be happening or if you have any other method of preventing the dropdown variable to pull through.

Form1.Dropdown.JPG (87.34 KB)

| Download

Form2.Dropdown.JPG (64.88 KB)

| Download

SQL.Required.Documents.JPG (74.06 KB)

| Download

0 0

replied on May 10, 2016

Hi François,

The value is kept because when you create the "Document Type" field in form1 you are actually also creating a variable, e.g. Document_Type. The value of this variable will persist throughout the process. Because of this, in form2 it will keep the value given in form1. Since it is a dropdown field, this value has to be in the options, so it is displayed as one of them.

If the "Document Type" field in form2 is completely independent from the field in form1, I would create a brand-new dropdown field instead of pulling over the dropdown called "Document Type" created in form1. You can set the label to still be "Document Type", and it should automatically create a new variable for this field, e.g. Document_Type_1 or something like that. Then it will be a completely different variable in the process and will not pull the value left over from form1.

Am I understanding your process well enough? Hope this helps.

0 0

Question

Question

Laserfiche forms Dropdown Variable

Replies

Sign in to reply to this post.