Submitted by dtsig on 2010/03/24 21:25

Where can I find some documentation on equations. Specifically functions available and what are the types? A, E ... others? What are A and E

Also where the equations go. There is an equation box and an edit line for row equation. what is the difference? when to use which.

I have been playing with ones i see posted like

A:DateChanged=int(now()) | E:DateChanged= | A: ItemColor="powder" | E:ItemColor="yellow"

which seems to be pretty powerful .. but how long until i put in a formula to format my hard drive by playing <G>

PS ... after the post i found

4.042 Equations, Rules, and Scripting

If there is more out there please point me in the right direction ...

Thanks

Comments

If you haven't read them, you can start with these pages:

-- link to nonexistent node ID 1071 --

Field Management Dialog - Equations

HTH

Thanks for the Pierre ... So a column does not have to be part of a grid for the grid to calculate using it? I am looking at the invoices grid and breaking down the [total] field. Taxes and subtotal are not part of the grid but are used for the calculations.

Thanks for any info ..

[quote=dtsig]

Thanks for any info ..

[/quote]

Hi Dtsig

fields don't need to be shown as "columns" in grids to be used in calculations. Apart from "conditional formatting" (see the manual), what is displayed in the grid (items or fields) doesn't have any incidence on calculations (row or column).

It is possible to create equations based on conditions : they won't be performed unless certain conditions are met.

Thanks for that. Do i understand right that the scripting is VBScript and not jscript etc.

Thanks

Correct.

FYI, the script engine used also supports jscript, but it is not currently enabled.

[quote=Pierre_Admin]

Correct.

FYI, the script engine used also supports jscript, but it is not currently enabled.

[/quote]

And would "enabling it" be feasible and a "productive" move ?

Some functions might be handled better (and quicker) with jscript than vbscript.

If someone wants to convert the existing vbscript code to jscript, I don't mind enabling the jscript.

[quote=Pierre_Admin]

If someone wants to convert the existing vbscript code to jscript, I don't mind enabling the jscript.

[/quote]

I see... It could be an interesting project for me when/if I get better (am not there yet :( ).

Jscript isn't far from java, so it shouldn't be too hard, even if I'm a beginner.

I guess that would also mean converting new functions as/when they're added by yourself (I don't think this happens too frequently, does it ?).

Lately this hasn't happened often, but one never knows. Also, you should be able to do the same thing in vbscript as in jscript, sometimes not as concise... but still. I would not consider this high priority

[edited: added "not"]

[quote=Pierre_Admin]

I would consider this high priority

[/quote]

Really ? Because jscript is more ~~prominent~~ wide spread maybe?

Corrected my post. I would not consider this high priority

[quote=Pierre_Admin]

Corrected my post. I would not consider this high priority

[/quote]

I thought so.