[Resolved] display numeric value as money format

[Author]

Posts

[matthewS-8]

Tell us what you are trying to do?
I would like to always display the field 'wpcf-current-price' (numeric format) as money format ($xxx,xxxx)

Is there any documentation that you are following?
Yes, reviewed these:
https://toolset.com/forums/topic/display-numeric-value-as-currency/

but not sure how to isolate the function just to this field globally....
I'm currently in the process of changing the price values from strings to numbers (i.e, manually removing dollar signs and commas)

[Shane]

Hi Matthew,

Thank you for contacting our support forum.

The solution in the ticket was implemented as a shortcode. So instead of using the default types shortcode you will use this custom shortcode.

function format_my_number($atts)
{
    $atts = shortcode_atts(
        array(
        'num' => '',
        'sym' => '',
    ),
        $atts
    );
    $num = $atts['num'];
 
    return $atts['sym'].' '.number_format($num, 0, '.', ',');
}
add_shortcode('format-currency', 'format_my_number');

So it would be [format-currency num="types shortcode goes here" sym="$"]

Please let me know if this helps.
Thanks,
Shane

[matthewS-8]

Hi Shane,
I'm getting a php error after adding this to my functions.php file.

Your PHP code changes were rolled back due to an error on line 170 of file wp-content/themes/total-child-theme/functions.php. Please fix and try saving again.

syntax error, unexpected '&'

Also, not sure where to place the short code to get the results? If I put it on the Content Template that this view is using, I get this result.

[Shane]

Hi Matthew,

I see the issue. You code snippet is being replaced with the ASCII equivalent for some of the items.

Try copy and pasting from here.
https://pastebin.com/UJsXMdtL

[matthewS-8]

Thanks Shane, that fixed the php error.
And I've registered both functions under View>View Settings > Third party Shortcode Arguments

Now how do I wrap my entry in this shortcode in a view ?
This gives me no results:
<div class="homePrice">[format-currency]{!{types field='wpcf-current-price'}!}{!{/types}!}[/format-currency]</div>

And this displays "[format_my_number1539900"
<div class="homePrice">[format_my_number]{!{types field='current-price'}!}{!{/types}!}[/format_myNumber]</div>

[Shane]

Hi Matthew,

The shortcode is actually used like this.

[format-currency num="[types field='wpcf-current-price'][/types]" sym="$"]

Thanks,
Shane

[matthewS-8]

Thanks Shane,

I found that I needed to remove the 'wpcf', and that did the trick!!

Now I can simply wrap it in my CSS class of "homePrice" for styling.

<div class="homePrice">[format-currency num="[types field='current-price'][/types]" sym="$"]</div>

Thank-you for your help.

[Shane]

Hi Matthew,

Happy I was able to assist you.

If there are no further issues on this then you can proceed to marking this issue as resolved.

Thanks,
Shane

[matthewS-8]

My issue is resolved now. Thank you!