|
|
|
|
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] |