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

Question

Posted to Laserfiche Lounge

Anyone know how to set up an easily update-able Data Source to pull from that can autopopulate fields in Forms 10?

asked on February 7, 2017

I'm fairly new to this whole system, and have been brought on to fix an HR process for goal setting and performance evaluation, so please bear with me!

One of the things they've asked me for is a way to select a job title from a list, and then have a set of pre-written goals matching that title automatically fill in. I know how to make the lookup rules work once the data source is attached to the process, but I'm not sure how to go about setting that up.

It's important that the source can be easily updated, e.g. they initially set a goal for the coop student position to convert 3 processes to Laserfiche during a work term, but after the first batch of students came through they realized that wasn't enough work and want to change it to 5 for the next batch. This needs to be changed at the source instead of in the form itself because you might have 20 odd people in any given position and the changes may be more substantial than just swapping a number.

 

 

0 0

Replies

replied on February 8, 2017
1 0
replied on February 7, 2017

Hi Ben,

If you don't have any other way of updating the data in SQL, you can use a combination of Forms and Workflow.  The following post has a more complex process than you will require, but has a lot of detail and screenshots that may help to see how it can work:

https://answers.laserfiche.com/questions/96697/Add-single-row-back-to-SQL-table-that-is-retrieved-from-forms

Cheers,

Mike

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

Sign in to reply to this post.