InfoQube IM - Community

Submitted by David_H on 2016/07/21 01:36

When using a pop-up list items using that pop-up field can get assigned blank values. Those blank values can then (at times) cause the item to show up in grids you don't want them to show up in. How do I remove blank values??

Screenshot example attached, this item has a blank value of "type". That causes it to show up in several grids that filter on type*. How do I delete the (blank) value?!

Edit: OK, so it seems I can click on the blank value and clear it out. Sometimes refreshing doesn't appear to work and i have to leave the grid and come back to see it take effect, so that's what was confusing me.

Thanks

*Yes, I know I could filter out blank values, but I want to know how to remove the blank value altogether.

Comments

[quote=David_H]

When using a pop-up list items using that pop-up field can get assigned blank values.

[/quote]

Is it a good thing that a blank value can be inserted using the pop-up list ? It is probably not really blank but just a space...

Good to see that you solved it yourself. Yes, you can filter for all items with type = " " and clear all values in one shot using the properties pane

HTH !

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]It is probably not really blank but just a space..[/quote]

Is there any scenario when IQ can make such items a blank on its own? i.e. under certain conditions?

If the source of a grid is a text field, adding TLI items will set the text field to " ". This, to ensure that the item stays in the grid.

A true blank is not a value in IQ

Pierre_Admin

IQ Designer

That's what I thought. I am pretty sure that's probably what caused these items to be blanks - as they should have been for the reasons you state above.

So that being the case, I guess I don't see any reason to allow someone to actually type in a space. But of course I suppose some advanced user could have some reason they purposely do that to make an item stay in a grid :D. I guess I'd vote for leaving it as is.

[quote=Pierre_Admin]

If the source of a grid is a text field, adding TLI items will set the text field to " ". This, to ensure that the item stays in the grid.

A true blank is not a value in IQ

Pierre_Admin

IQ Designer

[/quote]

There's actually a case where it seems that fields can be blank, but I might be one of the very few to experience it as I make extensive use of custom input boxes (vbscript) to enter values in fields (through auto-assign equations).

The fields' data appears blank (without space - there's actually nothing there, AFAICT) if I press cancel to discard an input box. Those blank values cause fields to be displayed in the properties pane "values" section, and items to be displayed in grids (depending on the filter). They are also erasable with a simple focus on the cell + delete.

I noticed that IQ gets rid of these values after a repair (and maybe a "compact", but I'm not sure).

[Edited 2016 07 21 -- 15 39]

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Armando]

The fields' data appears blank (without space - there's actually nothing there, AFAICT) if I press cancel to discard an input box.

[/quote]

Have you tried to check the return of your inputbox statement and assign a null to the variable if the return is an empty string ? That may do the trick.

That said, I'll see if I can check on my end, that if the return of a script returns an empty string, that nothing gets stored.

HTH !

Pierre_Admin

IQ Designer

I thought about doing that but I didn't bother as I actually don't care too much.

I was just mentioning it for the record.

In my daily usage It can actually be useful to see values that should/could've contain data but didn't get any because of acute distraction (you know...ADHD).

But if you decide to remove those values it's also good, I guess... Cleaner.

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz