Ragic Logo
<< Default values Table of Contents Additional field settings >>

Date and number formatting

Setting the Formatting of your Fields

You can change the formatting of field values, or choose from the offered formatting options when applicable, depending on the field type.

The formatting that is set will automatically format the input value, according to your custom format string. This makes it easier to make quick inputs on entries in Ragic.

You can set the formatting of certain field types in the Design Mode of your form, under Field Settings > Basic.

Example Formatting Types

See some of the examples on what you can do with custom field formatting below.

Field Type Formatting Applied Input Formatted Value Notes
Date yyyy/MM/dd 20151022 2015/10/22 Ragic will format your date value according to what you enter.
Date dd-MM-yyyy 1022 22-10-2015 If you do not enter the year value, Ragic will input the current year.
Date yyyy/MM/dd 22 2015/10/22 If you only enter the day, Ragic will autofill with the current month and year.
Date yyyy, MMMM, dd EE 22 2015, October, 22 Thursday Please check the section below for custom date formats
Numeric #,###.## 3266.528 3,266.53 Your input will be rounded to the nearest decimal according to the formatting.
Numeric #,##0.00 3266 3,266.00 If no value exists in a position, access displays a zero (0).
Auto Generate PO-{1,date,yyyyMMdd}-{0,number,000}   PO-20150519-029 Auto Generate fields do not require input from the user, and will generate a serial number in sequence.
Money $#,###.## 12859.2 $12,859.2 You can change the currency symbol in the formatting box by replacing $.
Phone (XXX) XXX-XXXX 9497692270 (949) 769-2270 You can enter your own formatting if your country isn't listed.
Special Format XXX-X-XX-XXXXXX-X 9781451673319 978-1-45-167331-9 Some options include the standard ISBN, SSN, and VIN, but you can also enter your custom format.

Custom Date Formatting

If none of the available date formats fit your requirements, you can write your own formatting with the table below:

Field Full Form Short Form
Year yyyy (4 digits) yy (2 digits), y (2 or 4 digits)

Month MMMM (name. Ex. January),MMM (Aabbr. Ex. Jan), MM (2 digits), M (1 or 2 digits)
Day of Month dd (2 digits) d (1 or 2 digits)
Day of Week EE (name) E (abbr.)
Hour (1-12) hh (2 digits) h (1 or 2 digits)
Hour (0-23) HH (2 digits) H (1 or 2 digits)
Hour (0-11) KK K (1 or 2 digits)
Hour (1-24) kk (2 digits) k (1 or 2 digits)
Minute mm (2 digits) m (1 or 2 digits)
Second ss (2 digits) s (1 or 2 digits)
AM/PM a

Setting Default Formatting Through Account Settings

It's extremely useful to apply default formatting for designing your sheet if you have a regularly used formatting for numeric field type or date field type.

Top of Page
<< Default valuesTable of ContentsAdditional field settings >>
Learn more about Ragic: Why we created Ragic | Webinars | User Guide.
Keep in touch: Blog | Email | Facebook | Twitter.
Ragic, Inc. | +1 888-666-8037 | Terms | Privacy