Database Design Documentation
How can we help?
Full Site Search

Fields 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 TypeFormatting AppliedInputFormatted ValueNotes
Dateyyyy/MM/dd201510222015/10/22Ragic will format your date value according to what you enter.
Datedd-MM-yyyy102222-10-2015If you do not enter the year value, Ragic will input the current year.
Dateyyyy/MM/dd222015/10/22If you only enter the day, Ragic will autofill with the current month and year.
Dateyyyy, MMMM, dd EE222015, October, 22 ThursdayPlease check the section below for custom date formats
Numeric#,###.##3266.5283,266.53Your input will be rounded to the nearest decimal according to the formatting.
Numeric#,##0.0032663,266.00If no value exists in a position, access displays a zero (0).
Auto GeneratePO-{1,date,yyyyMMdd}-{0,number,000} PO-20150519-029Auto Generate fields do not require input from the user, and will generate a serial number in sequence.
Money$#,###.##12859.2$12,859.2You can change the currency symbol in the formatting box by replacing $.
Phone(XXX) XXX-XXXX9497692270(949) 769-2270You can enter your own formatting if your country isn't listed.
Special FormatXXX-X-XX-XXXXXX-X9781451673319978-1-45-167331-9Some 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:

FieldFull FormShort Form
Yearyyyy (4 digits)yy (2 digits), y (2 or 4 digits)
MonthMMMM (name. Ex. January),MMM (abbr. Ex. Jan), MM (2 digits), M (1 or 2 digits)
Day of Monthdd (2 digits)d (1 or 2 digits)
Day of WeekEEEE (Monday)E (Mon)
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)KKK (1 or 2 digits)
Hour (1-24)kk (2 digits)k (1 or 2 digits)
Minutemm (2 digits)m (1 or 2 digits)
Secondss (2 digits)s (1 or 2 digits)
AM/PMa

Displaying the date field in the Japanese calendar format

If you would like to display the date information in the Japanese calendar format, you can create your own custom date formats by using code from the table below. For example, if you want to display the date information as “Nov 11, Reiwa 3”, you can do it by typing “MMM dd, JGGG Jyy” in the formatting.

CodeMeaning Display in English
JGGGJapanese era nameReiwa
JGG / JGShort form of the Japanese era nameR
Jyy / JyJapanese year 1, 3, 5
EEEEDays of the weekTuesday
E / EE / EEEShort form of the days of the weekTue
aAM/PMAM, PM

Custom Numeric Formatting

In Ragic, you can also change the system's numeric format decimal and thousand separators setting. On the left sidebar numeric field setting, click Advanced beside the Format Type. Then, untick the "Use system separators" checkbox and change the separator format under it as shown below.

Setting Default Formatting Through Account Settings

It's extremely useful to apply default formatting from your Company Setting > Account Settings section for designing your sheet if you have a regularly used formatting for numeric field type or date field type.

Top of Page Table of Contents

Start Ragic for Free

Sign up with Google