Show connected values with decimal field or currency?

Hi,

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.

1 Like

Can you show us screen shots as an example?

@Kristen

Please see attached (both from Form component & the builder). It are connected fields from the User table.

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.

Screenshot 2025-02-11 at 1.45.07 PM

Screenshot 2025-02-11 at 1.45.54 PM

2 Likes

@SuiteUpstairs

Wow Cam, thanks for the suggestion! This will help me in the meantime.

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.