Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Hiding null values.

Raffe
Level 2
Level 2

Some help with this one please.

I have a few text fields that have quite a few entry's in it derived from questions asked via radio buttons.  Before any answers are given all I have in these text fields are a lot of null expression.  Then as the questions  get answered the nulls change to the given responses. At the end of the form I am left with answers mixed up with nulls.  Is there a way of hiding the nulls and only displaying the answers.

I have tried a couple of scripting ideas but none have worked with the hidden expression.

Raffe.

9 Replies
Jono_Moore
Level 10
Level 10

You can do it with Patterns - from the Field tab of the Object palette.

You want to check the boxes under Handling Empty and Zero Values - Allow Empty and Allow Zero. At least I know Allow Zero gets rid of zeroes and I think the Allow Empty will stop nulls but I'm not sure.

Raffe
Level 2
Level 2

Thanks Jono.

Have tried this but its not working. Text is being displayed in theses text fields not numbers, so the null's are not being removed and only the selected answers from the radio buttons get displayed.

This is the script that I am trying to get to work but not having any joy.

if (this.rawValue == "" || this.rawValue == "null")

{

     this.presence = "hidden";

}

 

this.rawValue = "" + Q11.MT.TF1.rawValue + "\n"+ Q12.MT.TF1.rawValue + "\n"

Raffe.

Jono_Moore
Level 10
Level 10

So how are you getting the values into the text fields?

If the text fields are generating nulls to begin with you are using the Calculate event? If you are filling the text fields via the radio buttons then it would be better to use the Change event on the radio buttons.

Raffe
Level 2
Level 2

Hi Jono.

I have various radio buttons with 4 options each. They give an answer to a

text field associated with the question and radio button. Then at the

beginning of my form I have 4 separate text fields that give an overview of

the answers generated by all the questions as an executive brief.

To get all my answers I am using the calculated event as suggested by you.

It is in these text fields that would like to hide all the nulls generated

from the text fields lower down on my form. As at the moment all these

nulls run over 3 pages. Once my form is finished at the moment I now have

to go and delete all nulls. It would be a lot better if said nulls were

just hidden.

Raffe.

Jono_Moore
Level 10
Level 10

Can you share your form? It would be easier to figure out what's going on.

Raffe
Level 2
Level 2

Hi Jono.

Thanks for offering to have a look at this form and try and find a

solution. I am away from a pc at the moment and only on my phone and the

browser doesn't support the page that allows one to share files. Here's my

email address raffe.stone@gmail.com. Make contact and I will forward it on

to you from there.

Thanks.

Raffe.

Jono_Moore
Level 10
Level 10

Hi Raffe, got the file - I'll take a look at it as soon as I can.

Raffe
Level 2
Level 2

Thanks Jono. I hope you can come up with a solution to this little problem.

Much appreciated.

Raffe.