InfoQube IM - Community

Submitted by Tom on 2009/10/22 16:04

Field Management Dialog > General > Default Value

# 18 on page -- link to nonexistent node ID 1069 --

I quote from that page:

Enter the value of equation to use as the default field value. These are used when InfoQube needs to assign a field value (such as creating an item in a grid), or when users use one of the following shortcuts: double-click or ALT-click.

I know this can also be used to make a date field just date (no time) by adding =int(now())

I couldnt find any other info about this "Default Value" - could anyone elaborate &/or explain as I dont understand the text above

Thanks :-)

Comments

Tom,

for a numeric field, such as the HrsRate in the Invoices grid in the sample, you could simply put the number 25 in it. Then when you double clicked that column in the grid, it would fill in the default value of 25. I use that double-click a lot, and I assume the Alt-click does the same thing.

It also works for a date field as you know, and another example of that is =time , which will give the current time.

A yes/no field also appears to work, with =1

I'm not sure if a text field can work. I tried several ways, but couldn't get any of them to take.

[quote=KeithB]

not sure if a text field can work. I tried several ways, but couldn't get any of them to take.

[/quote]

This is now fixed. A default value of:

="Your Default Value", or
Your Default Value

will assign the string "Your Default Value" (no quotes) to the field on a double-click or an Alt-Click

Thanks Keith & Pierre

I'm creating a page about this (will add link when done) -- link to nonexistent node ID 1162 --

I now understand how it is used -

The default field value is used to quickly assign a default field value - double-click or ALT-click in the field and the default value is added

But have one more query:

is the default value sometimes applied automatically ? (or can it be?) - I believe not but want to make sure

Please someone look over the page as I not very familiar with this

> is the default value sometimes applied automatically ?

Definitely, in at least 2 instances:

When you put an item in a grid (through the grid source of the grid auto-assign fields)
Through other field auto-assign and forms (using the _auto keyword)

[quote=Pierre_Admin]

> is the default value sometimes applied automatically ?

Through other field auto-assign and forms (using the _auto keyword)[/quote]

could you (or someone) elaborate on that one - maybe an example?

I couldnt find anything about it on the auto-assign page Field Management Dialog - Equations

thanks!