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

Question

Question

Fetch the datas from the database and fill the Laserfiche Forms

asked on January 19, 2016

Hi,

In Laserfiche Form,I retrieves some fields and save to database using workflow,in the same process i need to fetch those saved information and populates the values in some other fields when user submit the form.

I don't want to use lookup rule here,because i have to show the information based on Instance ID which is saved in database,and i don't want to keep any new field for Instance ID in form,and there will be more than one row available having same instance ID.So i think i cannot apply lookup rule here,Is there any way to show the datas as per my requirement?Hope you understand my scenario.

Thanks in Advance..

0 0

Replies

replied on January 19, 2016

If it is the same process, you can use variable to pass data on different forms: for example, use two forms, on the first form you submit some data and retrieve the data using workflow, on the second form, drag from variables tab when adding fields, so the fields on the second form will use same variable as the first form, and the data submitted in first form will be passed to the second form when open it.

0 0
replied on January 20, 2016

Hi,

Actually i need to use a single form throughout the process,if i am using different forms,i can use the variables as you said.i have many users to process the forms and whenever user submit the form,some field information should be captured and for the next user the information should reflect in the same form.

 

 

0 0
replied on January 20, 2016

Then you can use workflow service task to manually update the value as you needed before user task get to the next user.

0 0
replied on January 20, 2016

Hi Abbey,

I am using workflow service task to update the data in the database,but now the problem is to populate those data in the form field.please check this link which describes the exact issue now i am facing

https://answers.laserfiche.com/questions/84042/Lookups-not-triggering-on-Form-load

0 0
replied on January 20, 2016

Lookup won't overwrite existing value unless the criteria field has a change, if you want lookup be triggered when the criteria field is not changing, you need to use javascript to trigger a change event on the criteria field.

0 0
replied on January 20, 2016

So in JavaScript section I have to add the code like this

$("#q42 input").change(); in my case q42 is Instance ID field.

I tried this also but lookup rule doesn't get triggered when form loads

0 0
replied on January 20, 2016

It won't trigger when page loads, you can trigger it after page loads. have a sleep or wait for the change.

0 0
replied on January 21, 2016

Hi,let me explain the issue here,my workflow design is like when user A creates the form A and submit to User B then User B getting Form B with some additional fields and enter values and sent it back to User A and then User A can view the values sent from user B and User A enter some values and send again to User B for Approval,here User B cannot able to view the values sent from User A and User B approve the form and submit the same form to User C,here User C can view the values entered by User A & User B,then User C enter some values and sent to other User and the process continues in this way,here i am using two forms A & B and the Form B travels towards the end.

my question is,In first step,lookup rule getting triggered and values are populated but in the second step the lookup rule not getting triggered and again in the third step its triggered.I cannot able to find where it went wrong.Is it happen using same form in that step?

0 0
replied on January 21, 2016

Hi there,

Please open a support case with your business process attached, and we can look more into this. Forms doesn't pass the form around in a process, it pass the submitted value around,  a single form is just a interface to present the value for a task.

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

Sign in to reply to this post.