| Home Variables Forms Reports Queries Groups Globals Preferences Triggers Updaters Audit Tables Timed Tasks Import Export Help Macros Report a Bug |
|
|
|
addedValue Builtins
addedValues allows you to use a number of builtin functions in your forms, reports and query definitions. These are not legal macros in the normal Manila sense, they are additional functions from the underlying Frontier scripting language which enhance the capabilities of addedValues without risk to the Frontier object database.
Click on a link for the Userland documentation.
| abs(x) |
acos(x) |
addedValueMacros.dateDayBegin(dt) |
| addedValueMacros.dateDayEnd(dt) |
addedValueMacros.dateOffset(startDate, day, month, year, hour, minute, second) |
addedValueMacros.durationString(duration, formatString) |
| addedValueMacros.isShortCut(shortcutid, flpicturewanted) |
addedValueMacros.siteLastModified(dformat) |
addedValueMacros.suffixToMimetype(suffix) |
| addedValueMacros.version |
asin(x) |
atan(x) |
| boolean(val) |
ceil(x) |
clock.now |
| cos(x) |
cosh(x) |
currentMemberKey |
| date(param1) |
date.abbrevString(param1) |
date.dateToIso8601String(d) |
| date.day(theDate = clock.now () |
date.dayOfWeek(param1) |
date.dayOfWeekToString(daynum) |
| date.dayOfYear(d) |
date.daysInMonth(param1) |
date.dayString(theDate) |
| date.firstOfMonth(param1) |
date.getCurrentTimeZone |
date.hourToString(hournum) |
| date.iso8601StringToDate(s) |
date.lastOfMonth(param1) |
date.longString(param1) |
| date.minute(theDate = clock.now () |
date.month(theDate = clock.now () |
date.monthToString(monthnum) |
| date.netStandardString(localDate) |
date.nextMonth(param1) |
date.nextWeek(param1) |
| date.nextYear(param1) |
date.prevMonth(param1) |
date.prevWeek(param1) |
| date.prevYear(param1) |
date.sameDay(d1, d2) |
date.set(day, month, year, hour, minute, second) |
| date.shortString(param1) |
date.timeString(theDate = clock.now () |
date.tomorrow(param1) |
| date.weekInYear(d) |
date.weeksInMonth(param1) |
date.year(theDate = clock.now () |
| date.yesterday(param1) |
double(val) |
environment.isCarbon |
| environment.isMac |
environment.isPike |
environment.isRadio |
| environment.isWindows |
environment.maxTcpConnections |
environment.osFullNameForDisplay |
| environment.osMajorVersion |
environment.osMinorVersion |
environment.osVersionString |
| exp(x) |
file.bytesInFolder(path) |
file.created(path) |
| file.exists(path) |
file.filesInFolder(path, level) |
file.freeSpaceOnVolume(path) |
| file.getPathChar |
file.modified(path) |
file.size(path) |
| floor(x) |
Frontier.version |
log(x) |
| log10(x) |
long(val) |
ManilaExtras.isCurrentMemberInCohort(cohortid) |
| memberAttribute(memberKey, variable, groupname="") |
messageBestURL(msgnum) |
mod(x, y) |
| number(val) |
power(x, y) |
random(lower, upper) |
| regexReplace(s, searchfor, replacewith, maxReplacements=32767) |
round(x) |
roundToPlaces(n, x) |
| short(val) |
shortcutStaticURL(shortcut, templateID) |
shortcutURL(shortcut) |
| sign(x) |
sin(x) |
single(val) |
| sinh(x) |
sqrt(x) |
string(val) |
| string.addCommas(num) |
string.countFields(s, chdelim) |
string.countWords(s) |
| string.delete(s, ix, ct) |
string.dropNonAlphas(s) |
string.ellipsize(s, ct) |
| string.filledString(ch, ct) |
string.gigabyteString(size) |
string.hashMD5(s, flTranslate = true) |
| string.hasSuffix(suffix, s) |
string.hex(n) |
string.innerCaseName(name) |
| string.insert(source, dest, ix) |
string.isAlpha(ch) |
string.isNumeric(ch) |
| string.isPunctuation(ch) |
string.kBytes(num) |
string.lastWord(s) |
| string.latinToMac(s) |
string.length(n) |
string.lower(s) |
| string.macToLatin(s) |
string.megabyteString(size) |
string.memAvailString |
| string.mid(s, ix, ct) |
string.nthChar(s, n) |
string.nthField(s, chdelim, n) |
| string.nthWord(s, n) |
string.padWithZeros(num, places) |
string.patternMatch(pattern, s) |
| string.percent(numerator, denominator, rodPlaces=3) |
string.popLeading(s, ch) |
string.popSuffix(s, chseparator='.') |
| string.popTrailing(s, ch) |
string.quotedPrintableDecode(s) |
string.ratio(numerator, denominator, places) |
| string.replace(s, searchfor, replacewith, flCaseSensitive = true) |
string.replaceAll(s, searchfor, replacewith, flCaseSensitive = true) |
string.timeString(d) |
| string.trimWhiteSpace(s) |
string.upper(s) |
string.urlDecode(s) |
| string.urlEncode(s) |
string.wildcardMatch(s, pattern, flCaseSensitive=true) |
stringToList(s, delim) |
| tagAttribute(shortcutName, attribute) |
tan(x) |
tanh(x) |
| timeMilitary(seconds shortcutName) |
todaysDate |
trunc(x) |
|
