AppMachine Help Center

How can we help you?

Follow

Custom Events View with Excel file

A customer asked how we can add "custom formats" to a date field (11/6) like the picture below (right one).

In your <label> element you can add the property "type" and "format".

- type you can give it the value "date"

- format you can give it the below formats

Format options

Specifier ---> Description ---> Output
d ---> Short Date ---> 08/04/2007
D ---> Long Date ---> 08 April 2007
t ---> Short Time ---> 21:08
T ---> Long Time ---> 21:08:59
f ---> Full date and time ---> 08 April 2007 21:08
F ---> Full date and time (long) ---> 08 April 2007 21:08:59
g ---> Default date and time ---> 08/04/2007 21:08
G ---> Default date and time (long) ---> 08/04/2007 21:08:59
M ---> Day / Month ---> 08 April
r ---> RFC1123 date ---> Sun, 08 Apr 2007 21:08:59 GMT
s ---> Sortable date/time ---> 2007-04-08T21:08:59
 
Y ---> Month / Year ---> April 2007
dd ---> Day ---> 08
ddd ---> Short Day Name ---> Sun
dddd ---> Full Day Name ---> Sunday
hh ---> 2 digit hour ---> 09
HH ---> 2 digit hour (24 hour) ---> 21
mm ---> 2 digit minute ---> 08
MM ---> Month ---> 04
MMM ---> Short Month name ---> Apr
MMMM ---> Month name ---> April
ss ---> seconds ---> 59
tt ---> AM/PM ---> PM
yy ---> 2 digit year ---> 07
yyyy ---> 4 digit year ---> 2007
: ---> seperator, e.g. {0:hh:mm:ss} ---> 09:08:59
/ ---> seperator, e.g. {0:dd/MM/yyyy} ---> 08/04/2007

 

To make things easy I already scripted the above events view in combination with an Excel sheet.

I've uploaded both the Excel file used + the view XML in this post. You can copy / paste the XML into your pro block and possibly change the fields according to your Excel sheet if needed.

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Martin Bazuin

    Great work, many thanks for this tutorial! :-)