Question

Laserfiche Cloud

Pre-Fill Radio Button list when opening a form

Laserfiche Laserfiche Cloud Forms

Updated April 1, 2020

asked on March 31, 2020

Dear community,

I'm rather new with LF Cloud and trying to implement a quite simple form but not sure on how to approach this.

See the layout below :

This checklist concerns only one item. I would like to store all the data in a table (I'm guessing lookup table).

Then, when the next person comes in, the radio button should be pre-populated by data present in the lookup table.

My idea was:

- Create a lookup query for each individual item

- Select these different queries result from the form using lookup rules and set values for the different radio buttons

Question : The values seems to be rights but my radio buttons are not "Checked" how can i check them ?

I feel the solution that i came up with is a bit overkill. Would you recommend an easier way to do it ?

Thank you

Brice

0 0

Replies

replied on March 31, 2020

Can you explain the flow of this process a little more?

Are you looking to have these radio buttons pre-filled with a default value when the form is opened? Does someone do an initial inspection then another person with a user task needs to see and update the values? Does the database have known OK/OOO status and you are looking to have the user task pre-filled based on some item ID?

0 0

replied on April 1, 2020

Hi Jared,

Thank you for your feedback.

Here is the flow :

The form is a daily check for a specific item. An operator comes in, performs the daily checks and writes down whether each status is OK or OOO (Out of order).

The next day when another operator comes in and open the form to performs the daily checks he needs to see whether there is an item that is already out of order.

I have a lookup table where i store all checks status, and will write a workflow to update that lookup table when an operator submit the forms.

And yes i would like to pre-fill radio button with values from the lookup table and pre-check the radio button if they are OOO.

Thank you

0 0

replied on April 1, 2020

We do not currently support lookups filling in radio buttons. If you change the fields to use drop downs, you could have an option for OK and another for OOO, and those could easily be filled by lookups.

Otherwise, there are a few workarounds using Javascript you could try. Run a Forms lookup against your database to populate hidden fields with OK/OOO for each line item, then use JS to trigger the radio button based on that.

https://answers.laserfiche.com/questions/49121/How-do-I-use-Javascript-to-set-a-radio-button-in-Forms#67221

https://answers.laserfiche.com/questions/91616/How-to-initialize-a-radio-button-field-through-a-lookup-rule#91636

0 0

You are not allowed to follow up in this post.

Question

Question

Pre-Fill Radio Button list when opening a form

Replies

Sign in to reply to this post.