addedValuesDocs

 
Home

Variables

Forms

Reports

Queries

Groups

Globals

Preferences

Triggers

Updaters

Audit Tables

Timed Tasks

Import

Export

Remote Search

Tropes

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 linguistMacros.storyLanguage
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)



Create your own Manila site in minutes. Everyone's doing it!