Using Forms 9.2.1.1069. I have a simple lookup of account number and pin -> fills a field with data. It was working in 9.2.0. I upgraded to 9.2.1 and now that autofill button doesn't do anything on two forms with similar functionality. Where do I start trying to troubleshoot this?
Question
Question
Answer
Hi Eric,
Your reseller opened a support case on your behalf. The issue is that the match fields in your lookup are in a table and the fill field is outside the table. While this worked in Forms 9.2.0, it wasn't supposed to as the behavior is technically a bug. That's why in Forms 9.2.1 and up, this type of lookup no longer works. The reason is that in a table, there could be multiple rows so it's ambiguous as to which data from which row the lookup should be run on.
As a workaround, please use individual fields as opposed to a table. You can style the fields using CSS if you need them to display inline.
Regards
Replies
Hi there,
You can first check the lookup rules, whether there're conflict fill criteria, or create a new form with a basic two criteria fields fill in one target field rule, see whether it works there.
I rebuilt the same exact autofill function in a completely new form and it works. That's good. Except... the lookup is identical to the production lookup which still doesn't work. Same fields, same database, same output.
I deleted the lookup rule entirely, saved and recreated it, still no luck. I deleted the data source from that form, and re-added it. Still no luck. Any more suggestions would be greatly appreciated.
I did have css and javascript but I removed it all for testing this issue and it's broken even with no javascript
Hi there,
When you load your form, is there browser Console error? If not, can you open a support case for this?
There are no errors or warnings in the F12 console when the from loads, or when clicking autofill.
Silly question... how do I open a support case?
Hi Eric,
You can contact your Laserfiche reseller about opening a support case. It'd be helpful if you can export your business process and provide a copy of the xml file when opening the case.
Thanks
Hi Eric,
Your reseller opened a support case on your behalf. The issue is that the match fields in your lookup are in a table and the fill field is outside the table. While this worked in Forms 9.2.0, it wasn't supposed to as the behavior is technically a bug. That's why in Forms 9.2.1 and up, this type of lookup no longer works. The reason is that in a table, there could be multiple rows so it's ambiguous as to which data from which row the lookup should be run on.
As a workaround, please use individual fields as opposed to a table. You can style the fields using CSS if you need them to display inline.
Regards