InfoQube IM - Community

Submitted by David_H on 2015/10/09 22:55

Let's suppose I have 3 grids named:

- Grid 1

- Grid 2

- Grid 3

Let's assume that like most grids that when they were created they automatically created a corresponding yes/no field to use as the source for the grid.

Is there a way to create a column that has a pop-up field that allows me to select one of those grids (yes/no fields)? The selection would always be mutually exclusive, I only want to select 1 of the 3 in this manner. This would be much more effective for me in some instances than having (3) separate check-mark columns, especially since the use of these fields is that they are always mutually exclusive.

Thanks

Comments

Hi David,

Ecco had these kind of popup list (you would arrange the folders in a hierarchy and the parent folder when shown in a column could show the list of sub-folders as a pop-up list). It was not mutually exclusive though. This is definitely planned and quite easy to implement, but not yet done...

The best I can suggest is to either use multi-level headers or use the properties pane (forms or grids section).

Regarding mutually exclusive field values, this was also requested (by user gregory IIRC) and is also planned.

HTH !

Pierre_Admin

Just as extra info : mutually exclusive fields can be created with auto-assigns equations. You will still have three separate fields though.

Let's say you have three fields

Bird

Plane

Superman

In Bird you'll add those auto-assign equations:

A:plane=

A:Superman=

Which means that when Bird is checked, plane and superman are unchecked. They are mutually exclusive.

Then you apply the same logic to the other fields

E.g. for Plane:

A:Bird=

A:Superman=

etc.

This is only a basic explanations. Auto-assign equations can be used for all kinds of stuff.

(See the auto-assign section of the manual for more details.)

What can also be done is to have a master field trigger a popup letting you enter a letter/number that will be interpreted as a "check" in a other specific fields. This done with auto-assign equations, again, but it also involves some scripting. Providing you know VBScript a bit, it's fairly easy to do. I use popups all the time so that I don't forget to enter data in specific fields when I create items.

-------------------------------------------------------

Windows 8.1

Sony Vaio S Series 13 (SVS131E21L)

Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

Pierre, any closer to implementing this?

Armando, a belated thank you for your detailed explanation above.

[quote]

Pierre, any closer to implementing this?

[/quote]

Hi David,

I'm afraid it isn't on the radar at the moment. Lots of other more urgent stuff to do... Do you want to see my list ? It's depressingly long !!!

Pierre_Admin

IQ Designer