Problem: nesting Selected function inside the If function is not working

vocono1953

The selected function returns an integer with is the evaluated by the If function that should return text to display in a text field. It’s not working. No doubt a syntax error but cannot see the error.

if(selectede(${lst_crew_cnt}) > 1, 'Data Entry Staff','Gardener')

It’s placed in the calculate field for the target text field.

Thank you for any help you can give.

--Bob

dougbrowning

Form seems to work fine for me with the single quotes.

To wait for user input you can do 2 ways.  

One is to use relevant of  ${lst_crew_cnt} != ''.  That way the field is not shown until the crew count is picked.  Not sure why you are doing 1 and One.  May be a data issue later esp if you want to use it as a number.

The other way if you want to always see the field is to wrap your if in another if, again checking for empty.

if(${lst_crew_cnt} != '',if(selected(${lst_crew_cnt},'1'),'Data Entry Staff','Gardener'),'')

You have a ton of groups in here and it is going to be pretty slow for you staff to fill out this form.  Basically they have to open a group for almost every question.  I would at least expand all of these but really the form is so short I would remove all the groups.  I personally think all that green burns the eyes but that is just an opinion.  In my experience all these font tags will become a pain when trying to use the data since it will be burned in there.  Take a look at it in a web map and see.  Again on such a simple form I do not think all this formatting is really needed.  Just an idea.  Not sure if this would bother color blind users.

Hope that helps