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

Question

Question

Form not refreshing SQL table look up values

Forms
Updated May 21, 2017
asked on January 30, 2017

Hi,

I am having an issue where whats in a SQL table is not reflected in a form. I tried a few things and also searched for answers on this site but couldn't find anything.

I have a read-only form table control linked to a SQL table so that it displays what is in the table. When a user actions a form, a Laserfiche Workflow inserts the table with values then updates the metadata and returns to the same user as a separate step as shown below. Table rows appear based on the instance ID value.

Currently I only see the first row.

If I manually refresh Instance ID Field to something else and then back to current instance ID, it looks up fresh data but doesn't do it on form load.

In the table field, I have tried using both 'Range of Rows' and 'Append rows to rows populated...'

In the Look-up rule, I have ticked 'as new row'.

Any idea what I am missing?

Thanks,

Adarsh

0 0

Answer

SELECTED ANSWER
replied on May 11, 2017

On the user task, since the lookup target fields have carried value (already submitted in previous steps), the lookup rule would be ignored because carried value has higher priority;

If you want to force lookup to be executed, you can try the following custom script (change Field3, Field5 to your lookup target field id):

$(document).ready(function() {
  $("#Field3\\(1\\)").attr("vo", "e");
  $("#Field5\\(1\\)").attr("vo", "e");
})

 

1 0
replied on May 21, 2017

Thanks Rui,

I will remember to try this next time :)

Regards,

Adarsh

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...