You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Laserfiche Forms 11 Update 2 - Database lookup variable behavior changed

posted on February 3, 2022

I've built out a Invoice reimbursement form in modern Forms Designer (aka no javascript) which has  a number of SQL Server 2016 database lookups that need to be refreshed every time a form is opened.   Our approval process has one form being passed around between multiple user tasks.  All of this worked splendidly at 11.0.2108.10347 using a single line field  with a field rule that was hidden always and ignore data when hidden selected, and then using Calculation  to calculate the value of the hidden field into another field of my choice. We upgraded our test environment to 11.0.2201.20436 and none of the fields are refreshing on form load, and everything is one submit and done despite the field rules.  I built a fresh form to test a number of variations including toggling read only and changing field rules without any success.

I'm pretty new to forms development, so I'm not sure if I constructed my initial form using a methodology that wasn't intended or if this is some sort of bug. I hoping there's some some helpful advice  or best practice for variables that need a consistent database  refresh on form open using the modern Forms Designer in this version.

0 0
replied on May 24, 2022

I am running into the same issue.  Were you able to get this resolved?

0 0
replied on May 24, 2022

After a bit of troubleshooting, I was made aware by our solution provider that this database lookup behavior was not standard for LF Forms that it had been corrected in Update 2.   To resolve for this correction, I put a workflow service task in between each user task to reset the desired field values to %(DB.Null) which triggers the form to do a fresh database lookup when the user opens the form.  It was a bit time consuming to put in place, but having a workflow service task in between each user task has been quite beneficial in my subsequent development as I've been able to leverage it to bring the useful "Started by Laserfiche Forms" Input Parameters tokens into my Forms development.

2 0
replied on May 25, 2022

I knew this wasn't standard for the old designer but was hoping it was added functionality to make the new designer easier to use.  Oh well.  Thanks for the quick response on why it was removed and your work-around.  I ended up doing the Workflow option as well just to get it to work but here's hoping they add some built-in method to have lookups trigger every time the form loads.  Thanks again!

0 0
replied on February 3, 2022

Hi Rebekah,

I'm sorry to hear that the update appears to have broken some lookup functionality on your form. Could you please open a support case through your Solution Provider that includes the information above along with an exported copy of the Forms process in question? We'll be able to better assist you through that avenue.

Thanks,
Sam

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.