Skip to main content
Learning
Managing Settings

To manage regional settings, go to the Manage > Settings.

Locale​

Timezone​

A timezone is a region that observes a consistent standard time for legal, commercial, and social purposes. Timezones often align with country and regional boundaries rather than strictly following lines of longitude, as it is more convenient for areas that communicate frequently to share the same time.

Each timezone is defined by a specific offset from Coordinated Universal Time (UTC), ranging from UTC−12:00 to UTC+14:00. Most offsets are whole hours, but some zones use offsets of 30 or 45 minutes. Certain areas within a timezone may adopt a different offset for part of the year, usually one hour ahead during spring and summer, in a practice known as daylight saving time (DST).

GoAutomate fully supports IANA timezones, as documented here (refer to the TZ identifier column).

To change the timzone, click the pencil icon, select the timezone, then click save.

note

GoAutomate uses timezones in the following places:

  • In date and time-based formulas
  • When displaying dates and times in forms and other parts of the app

Default patterns​

Default patterns are used to convert text into dates or times using DATEVALUE and TIMEVALUE functions.

The default patterns are:

  • Date Pattern: A regular expression that checks and extracts the day, month, and year from a date in text.
  • Time Pattern: A regular expression that checks and extracts the hour, minute, and second from a time in text.
  • Year/Month/Day: A number sequence (e.g. 210) that indicates which parts of the Date Pattern represent the year, month, and day.

To change a default pattern, click the pencil icon, make your edits, then click save.

Default formats​

Default formats are used by the TEXT function to turn non-text values into text. If you don’t set a format, the function picks a default one based on the type of data.

Here are the default formats:

  • Default Number Format: Converts numbers to text
  • Default Logical Format: Converts true/false values to text
  • Default Date Format: Converts dates to text
  • Default Time Format: Converts times to text
  • Default Datetime Format: Converts combined date and time to text

To change a default format, click the pencil icon, edit the format, then click save.

For more details on display formats, click here.

Custom formats​

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.

Custom patterns​

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.

ON THIS PAGE