I prefer to use connected fields in order to minimize duplicates, but I found out that currency fields and number fields that are being shown through a connected field do not have decimal separators or currency marks, while the fields itself (on the connected table) are formatted like that.
Is there a quick way to fix this? Currently it just doesn’t look nice, when values which are in the thousands don’t have a separator.
I’m assuming this is an edit form. You may be able to target that field with javascript to format that number or a quick and easy fix is to add a formula field to the connected table that references the currency field and then display that on the edit form.