|
Setting Invoice2go Formulas
The Set Formula window is used to create formulas in styles and tables.
A formula is a small piece of programming that creates dynamic information
This window is accessed from the following screens.
Formula Field
In this field write the formula you want to use. You can check if it is a Valid
formula by clicking the "Check Formula" button.
Fields List
This is a list of all the fields you can include in you formula.
Check Formula Button
Click on this button if you want to see if the formula is valid. Note: You cannot close this window
with an invalid formula.
Functions
abs
bitmap
ceiling
case
char
cos
currentrow
date
datetime
day
dayname
daynumber
exp
fact
fill
getappdir
geticondir
getworkdir
getlocation
getrow
gettext
hour
if
int
integer
isdate
isnull
isnumber
istime
left
lefttrim
len
log
logten
long
lower
match
mid
minute
mod
month
now
number
numbertowords
page
pagecount
pi
pos
profileint
profilestring
rand
real
relativedate
relativetime
replace
rgb
right
righttrim
round
rowcount
second
secondsafter
sign
sin
sqrt
space
string
tan
time
today
trim
truncate
upper
wordcap
year
|
