Question

Can a form be saved showing dynamically updated labels>

Forms Classic Form Designer

Updated January 22

asked on January 15

We have a form (Classic Designer) used to record City Council votes for each meeting. The label for each members vote is generic, such as W1P1 for Ward 1 Position 1, and a database lookup updates the labels to the correct council member's name and position based on the meeting date.

This has worked well for many years; however, they would like to begin using these completed forms in the minutes as the voting record. We have found that the stored version of the form shows the generic labels rather than those updated dynamically.

Does anyone know if there is a way to store these forms with the updated labels?

Thanks in advance for any help!

0 0

Replies

replied on January 18

Hi Sarah, could you let us know which fields you are using to display the labels and what lookup rules you have applied to update them?

0 0

replied on January 19

More specifically if you are filling a table or standalone fields on your form.

The simple answer is javascript to solve both field types, but that type of JS is not available in classic.

0 0

replied on January 20 • Show version history

Hello and thanks for the responses. This is an old form, so it is the classic designer. These are labels for dropdown fields that are populated with the council person's name when the meeting date is entered. This uses a database lookup to store the names in single line fields and javascript to populate the labels.

0 0

replied on January 22

Lookup rules do not run on completed forms. If your labels rely on lookup rules, they will not appear on the completed forms.

0 0

replied on January 22

May I ask what about the form isn't working for them as a voting record? Is it because the single line fields used in the lookup are hidden on the form?

You could try placing the single line fields above each dropdown field, with labels on top

Make each field XL width

And then add the CSS class col-xs-6 to each of the ward/voting position single line and dropdown pairs.

In the end it looks like this:

Where you can actually style it a little better where you hide the labels with CSS (don't remove the label text). And make the single lines readonly since they're filled via lookup anyway.

Side note: if you want to make the single lines smaller and the dropdowns larger you can use any combination that adds up to 12 for each pair
single line: col-xs-4 , dropdown: col-xs-8
single line: col-xs-3, dropdown: col-xs-9

1 0

replied on January 22

Zachary, I'm going to give this a try. Thanks!

Zanbo, I don't think the lookup is needed after the values are stored in the single line fields. Thanks!

1 0

You are not allowed to follow up in this post.

Question

Question

Can a form be saved showing dynamically updated labels>

Replies

Sign in to reply to this post.