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

Discussion

Discussion

Force a form to use the lookup rule and overwrite the table variables

Laserfiche Forms Layout Designer Version 11
Updated April 22
posted on April 17

Good Afternoon,

      I have a form that presents a total received count of an item and the total ordered count in a table based on a lookup rule. I am looping the form back to the same user task until the total received count and total ordered count match. However, the table is retaining the variable values, so the lookup rule is not run and the count does not change as new orders are received. Is there a way to force a table to use a lookup rule instead of the recorded variable values?

Thank You, 

0 0
replied on April 18

Since you are assigning the form back as a separate task, you could use Workflow to clear the variable value before it is assigned back - by setting it as a NULL.

Alternately, if you are going the route of using Workflow in between the user tasks, you could just have Workflow do the lookup and populate the value, so it's already there before the form loads, and you don't have to even worry about the lookup.

2 0
View 3 previous replies
replied on April 18

That is a good idea.  I was curious if there was additional information being submitted on the same form which would update SQL through WF. 

I use the button because the updated data is coming from a different form that is updating SQL data and there isn't a loop assignment happening.

1 0
replied on April 21

Good Morning @████████and @████████

 

    I tried setting the variable to NULL via work flow, but this is what I am getting in the form.

Am I doing this correctly? This is my Set Business Process Variables task.

 

Thank You,

 

 

0 0
replied on April 21

When you click on the token, you want to select Special and then use the DB.NULL for the fields you want to clear.

2 0
replied on April 21

That worked! Thanks @████████

0 0
replied on April 21

My apologies for not being more clear on that from the beginning.

1 0
replied on April 22

No problem @████████. I appreciate the help!

0 0
replied on April 18

@████████ posted this JS: How do I force refresh on table pulling from database in Modern Form Designer? - Laserfiche Answers, but I haven't gotten it to work properly.  

I use an html button to send a value to a hidden field that will trigger the lookup to run again.  I use show/hide rules to make sure the end user clicks the button first before they can see the updated results.  

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

Sign in to reply to this post.

Details
Related Posts
Loading ...