How to make a field visible only if it's not blank

[RachelS]

Hi,

I'm pulling data from a spreadsheet and have 'note' type fields to show the results. Is there a calculation to only show a field if it doesn't have blanks?

Any help much appreciated.

Thanks

Rachel

[clt_cabq]

generally this would be something you put in the Relevant column - is that where you are putting your expression? Also, make sure the 'Yes' is reflecting the stored value of the question and not the 'label' that is applied to that. For instance, if your stored value is 'yes' and its label is 'Yes' that won't work.

[RachelS]

HI,

Thanks sorry I just updated my post before I saw your reply.

I got the Yes question to work using this ${calculatetestpermit}='Yes'

Any ideas on the only showing if it's not blank?

Thanks

[abureaux · Accepted solution]

string-length(${question_name})>0 to show when not null

selected(${question_name},'name') for select_one and select_multiple

EDIT: Yes, technically ${question_name}='name' will work for select_one, but I don't advise you do that. selected() is the preferred approach.

[RachelS]

This worked a treat, thank you!

Rachel