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

Discussion

Discussion

Forms drop down list - labels & values

posted on October 14, 2021

Hi,

We are drafting up a form which allows users to calculate risk scores for entities as part of a review process and are using multiple drop down lists with pairs of labels and values. The labels describe the risk topic (i.e. High Risk Country, High Risk Activities etc) and the value is the risk score.

The issue is that each item/label can have different risk scores, or the same but in the case of the latter, if a user selects an option which shares the same value/risk score, it changes back to the first option with that value/score. The behaviour seems a little odd so not sure if it is by design or a bug of sorts. 

I did notice that when I first created the lists, it did automatically change the values, i.e. 10 became 10_1, 10_2 etc) but the values need to be the same for risk score calculation purposes so I changed them back. There are probably other ways around this but this would be the optimal solution as it is handled entirely in the form and form fields.

 

Thanks,

 

Nigel.

0 0
replied on October 14, 2021

Hi Nigel

I've run into this as well. Each Value in a Drop down must be unique which is why it put the _1, _2 on your values. The simpliest way I get around this is when I put the value in, I would put something like 10.001, 20.000,10.002 for the values. When I add them up I just display the Integer (no Decimals) as I'm using such small fractions then never add to a whole number or I use Round in my calculation field to remove the .000 ie: =ROUNDUP(543.21, 0) = 543

1 0
replied on October 15, 2021

Hi Steve - that's interesting as I ended up using a similar function myself in the end, except it extracts everything to the left of the "_". 

I had to update quite a few fields but the end result is that it works so all good!

 

Cheers,

 

Nigel.

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

Sign in to reply to this post.