Select to view content in your preferred language

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

195
4
Jump to solution
3 weeks ago
RachelS
Occasional Contributor III

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

0 Kudos
1 Solution

Accepted Solutions
abureaux
MVP Regular Contributor

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.

View solution in original post

4 Replies
clt_cabq
Occasional Contributor III

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.

0 Kudos
RachelS
Occasional Contributor III

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

0 Kudos
abureaux
MVP Regular Contributor

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
Occasional Contributor III

This worked a treat, thank you!

Rachel

0 Kudos