InfoQube IM - Community

Submitted by David_H on 2016/06/02 19:46

In the Properties Field, there is an option for "default value". Could an option be added if the user wants the default value to get added to EVERY item (upon creation)? Currently if an entry is made in the default value area, the field has to be clicked on in a column to add the default value. Here is my a case...

I have two values I assign to every single item in my IQ database. For instance, I have a status of open or closed for every item. Being able to set a default of open for every new item would be immensely beneficial and help make sure I don't forget to assign a value. It would also make it pretty much impossible to have "orphan" items....at least insofar as all items would show up in my "open grid" until assigned a value of "closed", at which point it would show up in the closed grid.

In the business software I use I am used to being able to define default values for items - I would find it a very useful feature for IQ.

Thanks for considering.

Comments

Maybe use an auto-assign equation in your item field.

E.g.

A:[open]=-1

But I wonder what's the use of "open" if all items are "open" by default. Since it's implied, you could use only one field : closed.

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Armando]

Maybe use an auto-assign equation in your item field.

E.g.

A:open=-1

But I wonder what's the use of "open" if all items are "open" by default. Since it's implied, you could use only one field : closed.

[/quote]

Agreed...

Pierre_Admin

IQ Designer

[quote=Armando]

Maybe use an auto-assign equation in your item field.

E.g.

A:[open]=-1

But I wonder what's the use of "open" if all items are "open" by default. Since it's implied, you could use only one field : closed.

[/quote]

Thanks Armando, duh, I didn't consider that I could just use an auto-assign on the default item field.

The answer to your second point is that I was simplifying so as not to bore people with the various statuses I use, it's actually several more than open and closed, hence my interest in defaulting new items to open.

But the real question remains... why bother ? There are so many other ways to do what you want...

Pierre_Admin

IQ Designer

I can see the use if there are many different values, for certain item types. But not for ALL items in the DB.

I don't think it would help finding "orphan" items. After a few years, all that extra data will probably seem redundant and it will probably be impossible to know if it's there because you forgot about it or because you consciously didn't check "closed" (e.g.) -- or any other mutually exclusive field.

If you create a grid 1- with the right columns 2- and the right filters (for those important fields you tend to use on all items ; e.g. closed), you could easily see what's been "tagged/checked" properly or not, without needing to have every "2 states" (opened/closed) represented for all items

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

Pierre, your last comment came over at almost the same time as my second post, was it in response to me first post, or my second post?

The first I think. I see now that you have many status, so that explains it... It seems however that having such status for every item is an over-kill.

But IQ is all about options and experimenting, so do come back to us on how it is working for you !!

Pierre_Admin

IQ Designer

[quote=David_H]

In the Properties Field, there is an option for "default value". Could an option be added if the user wants the default value to get added to EVERY item (upon creation)?

[/quote]

Like Armando suggested, you can use an auto-assign on the item field A:YourField=_auto. This will set the default value when an item text is added

HTH !

Pierre_Admin

IQ Designer

[quote=Pierre_Admin]

Like Armando suggested, you can use an auto-assign on the item field A:YourField=_auto. This will set the default value when an item text is added

[/quote]

I just learned something knew...! Or maybe I just forgot about that "_auto" value. I see it's mentioned in the "forms" section of the help file.

IQ geek

Windows 8.1

CPU: Intel i5 2.6ghz

[quote=Armando]

I just learned something knew...! Or maybe I just forgot about that "_auto" value. I see it's mentioned in the "forms" section of the help file.

[/quote]

In the Properties pane too, to set the default values to multiple items. Just enter _auto and press Enter

Pierre_Admin

IQ Designer