|
|
absolute value tile
|
Absolute value [Abs o]
|
add tile
|
Addition [o + o]
|
and tile
|
Both true [o And o]
|
annuity rate tile
|
Annuity rate [Annuity rate o o times]
|
arc tangent tile
|
Arc tangent [Atan o]
|
average for tile
|
Average for [Average o for o]
|
average tile
|
Average [Average o]
|
change modification date tile
|
Change modification date [Change o mod. date to o]
|
change name tile
|
Change name [Change o name to o]
|
change path tile
|
Change path [Change o path to o]
|
change type tile
|
Change type [Change o type to o]
|
compound interest tile
|
Compound interest [Compound rate o o times]
|
contains tile
|
contains [o contains o]
|
cosine tile
|
Cosine [Cos o]
|
count for tile
|
Count for [Count for o]
|
count tile
|
Count [Count]
|
date tile
|
Convert to date [Date o]
|
date time tile
|
Make date-time [Date o Time o]
|
day of month tile
|
Day of month (1 - 31) [Day o]
|
day of week tile
|
Day of the week (sunday = 0) [Day of Week o]
|
defined tile
|
Defined [Defined o]
|
delta days tile
|
Change in days [o ∆ days o]
|
delta hours tile
|
Change in hours [o ∆ hours o]
|
delta minutes tile
|
Change in minutes [o ∆ minutes o]
|
delta seconds tile
|
Change in seconds [o ∆ seconds o]
|
delta weeks tile
|
Change in weeks [o ∆ weeks o]
|
delta years tile
|
Change in years [o ∆ years o]
|
display tile
|
Display [o]
|
divide tile
|
Division [o / o]
|
document creation date tile
|
Document creation date [Doc. Create Date o]
|
document modification date tile
|
Document modification date [Doc. Modify Date o]
|
document name tile
|
Document name [Doc. Name o]
|
document path tile
|
Document path [Doc. Path o]
|
document size tile
|
Document size [Doc. Size o]
|
document storage tile
|
Document storage [Doc. Storage o]
|
document type tile
|
Document type [Doc. Type o]
|
ends with tile
|
Ends with [o ends with o]
|
equals tile
|
Equals [o = o]
|
extract text tile
|
Extract [Extract o through o from o]
|
fixed point tile
|
Convert to fixed point [Fixed Point o]
|
flag tile
|
Convert to flag [Flag o]
|
followed by tile
|
Concatenate text [o followed by o], undefined if either text input is undefined
|
followed or tile
|
Concatenate text [o followed/or o], use other text input if either text input is undefined
|
form average for tile
|
Queried average for tile [Form Average o for o]
|
form average tile
|
Queried average [Form Average o]
|
form count for tile
|
Queried count for [Form Count for o]
|
form count tile
|
Queried count [Form Count]
|
form maximum for tile
|
Queried maximum for [Form Max o for o]
|
form maximum tile
|
Queried maximum [Form Max o]
|
form minimum for tile
|
Queried minimum for [Form Min o for o]
|
form minimum tile
|
Queried minimum [Form Min o]
|
form previous tile
|
Previous, using form index and query [Form Previous o]
|
form time tile
|
Form time [Form Time]
|
form total for tile
|
Queried total for [Form Total o for o]
|
form total tile
|
Queried total [Form Total o]
|
fraction tile
|
Decimal [Fraction o]
|
greater than or equals tile
|
Greater than or equal to [o ≥ o]
|
greater than tile
|
Greater than [o > o]
|
hour minute second tile
|
Make time [Hour o Minute o Second o]
|
hour tile
|
Hour [Hour o]
|
if then else tile
|
Conditional tile [If o Then o Else o]
|
integer part tile
|
Truncate [Integer o]
|
larger tile
|
Larger [Larger of o o]
|
length tile
|
Text length [Length o]
|
less than less than or equals tile
|
Less than, less than or equals [o < o ≤ o]
|
less than less than tile
|
Less than, less than [o < o < o]
|
less than or equals less than or equals tile
|
Less than or equals, less than or equals [o ≤ o ≤ o]
|
less than or equals less than tile
|
Less than or equals, less than [o ≤ o < ]
|
less than or equals tile
|
Less than or equals [o ≤ o]
|
less than tile
|
Less than [o < o]
|
locate text tile
|
Locate [Locate o starting at o in o]
|
log tile
|
Decimal logarithm [Log o]
|
lookup summary tile
|
Lookup summary [Lookup o Summary in o]
|
lookup tile
|
Relational lookup [Lookup o for o = o in o]
|
lower case tile
|
Convert to lower case [Lower Case o]
|
maximum for tile
|
Maximum for [Max o for o]
|
maximum tile
|
Maximum [Max o]
|
minimum for tile
|
Minimum for [Min o for o]
|
minute tile
|
Minute [Minute o]
|
mixed case tile
|
Convert to mixed case [Mixed Case o]
|
month day year tile
|
Make date [Month o Day o Year o]
|
month tile
|
Month [Month o]
|
multiply tile
|
Multiplication [o * o]
|
natural log tile
|
Natural logarithm [Ln o]
|
negation tile
|
Unary minus [- o]
|
new line tile
|
New line [New Line]
|
not equals tile
|
Not equal to [o ≠ o]
|
not tile
|
Complement [Not o]
|
number tile
|
Convert to number [Number o]
|
or tile
|
Either true [o Or o]
|
picture tile
|
Convert to picture [Picture o]
|
post time tile
|
Post time [Post Time]
|
previous for tile
|
Queried previous [Previous o for o]
|
previous tile
|
Previous [Previous o]
|
raise to power tile
|
Raise to power [o to power o]
|
round tile
|
Round [Round o]
|
round to nearest tile
|
Round to nearest [Round o to nearest o]
|
second tile
|
Second [Second o]
|
sine tile
|
Sine [Sin o]
|
smaller tile
|
Smaller [Smaller of o o]
|
square root tile
|
Square root [√ o]
|
starts with tile
|
Starts with [o starts with o]
|
styled text tile
|
Convert to styled text [Styled Text o]
|
sub average for tile
|
Relational average [Sub-Average o for o = o in o]
|
sub count for tile
|
Relational count [Sub-Count for o = o in o]
|
sub maximum tile
|
Relational maximum [Sub-Max o for o = o in o]
|
sub minimum tile
|
Relational minimum [Sub-Min o for o = o in o]
|
sub total for tile
|
Relational total [Sub-Total o for o = o in o]
|
subtract tile
|
Subtraction [o - o]
|
tangent tile
|
Tangent [Tan o]
|
text tile
|
Convert to text [Text o]
|
today tile
|
Today's date [Today]
|
total for tile
|
Total for [Total o for o]
|
total tile
|
Total [Total o]
|
undefined becomes tile
|
Undefined becomes [Undefined o becomes o] Output first text input if defined, otherwise output second text input
|
undefined tile
|
Undefined [Undefined o]
|
unique tile
|
Unique [Unique o]
|
upper case tile
|
Convert to upper case [Upper Case o]
|
use from tile
|
Use from [Use o from o] Get a value from another relation (or template in that relation) which must be part of the active view
|
user name tile
|
User Name [UserName]
|
word equals tile
|
Word equals [o word = o]
|
word starts with tile
|
Word starts with [o word starts with o]
|
year tile
|
Year [Year o]
|