This tutorial explains how to manipulate data for a better presentation in the app.
Remember that you have to type these values in the "source" of the Layout Editor.
Example:
<label field="date" type="date" format="dd" field="pubdate" fontsize="17" textColor="support" />Date and Time
d : Day of the month (1 – 31)
dd : Day of the month in two digits (01 – 31)
ddd : Abbreviated name of the day
dddd : Full name of the day
M : Month (1 – 12)
MM : Month in two digits (01 – 12)
MMM : Abbreviated name of the month
MMMM : Full name of the month
y : Year without the century (2009 is displayed as 9)
yy : Last two digits of the year (2009 displayed as 09)
yyyy : Full year including the century (2009)
h : Hour (1 – 12)
hh : Hour in two digits (01 – 12)
H : Hour in 24-hour format (0 – 23)
HH : Hour in 24-hour format in two digits (00 – 23)
m : Minute (0 – 59)
mm : Minute in two digits (00 – 59)
s : Seconds (0 – 59)
ss : Seconds in two digits (00 – 59)
t : First character of AM or PM
tt : Both characters of AM or PM
z : Time zone hour (+6)
zz : Time zone hour in two digits (+06)
zzz : Time zone hour and minutes (+06:00)
Visibility
<container direction="horizontal" visible="AM:HasValue([{data:starttime}])" only shows the container when the item starttime has a value. When starttime is NULL the container will be invisible.
Text
value="AM:TruncateWithDots([{data:Description}],[70])" shows the first 70 characters followed by two dots of the field Description.
value="AM:Upper([{data:column1}])" shows the text of column1 in capitals
value="AM:Lower([{data:column1}])" shows the text of column1 in lower case