Money Data Types allow users to manage monetary values, preceded by a currency symbol of their choice.
This prototype might be outdated due to global component updates. Please refer to the link under ‘Setting Options’ for an updated version of the shared components.
The user opens the menu for the desired column and selects the ‘Data Type Options’ menu item. From the list, they can set the type to money. Under advanced options, the user may set the currency and decimal places.
The following is an interactive representation of the various options that users can set for this type:
Money Type Options
The user can choose from multiple filter options to filter monetary values. The options will be the same as those used for numeric types.
The user might also choose to group the data based on the values of the ‘Money’ data type column.
Mathesar will allow users to view columns set to Postgres money type as a money type column. However, it will not allow users to set an existing column to Postgres money data type. To change from Postgres money data type to the custom Mathesar money type, the user would have to set the column to Number or other data type and then choose money again.
Mathesar’s custom money data type will allow users to set any currency and customize various display options. The custom money data type will be the only money type option that can be set in Mathesar. With Postgres money type being available only for existing database columns set to this type.