Formatting decimal field to currency using sprintf

[milesreid]

I am trying to get a decimal field to display with a currency symbol using sprintf in the Formatting property of the element - see attached. The values in this field might be £1.xx up to £9999.xx

The sprintf function that I am using is %c($) as per the advice at :
https://codev-process.carrefour.com...Sprintf Function for Formatting Currency.html

I don't think that the input mask property is what I need, but I stand to be corrected

Nothing seems to work: am I inputting the parameters correctly? What am I doing wrong?
Thanks
Miles

 

[lousyfool]

You should use something like this in "format string":

£%s

and set other formatting for the decimal format you want further up in the tab.

If you search this forum for e.g. "currency", you'll find out this and more... e.g. here: http://fabrikar.com/forums/index.ph...cimal-currency-type-element-posible-bug.52994

More on sprintf also here:
https://www.php.net/manual/en/function.sprintf.php
https://www.w3schools.com/php/func_string_sprintf.asp

 

[milesreid]

Thank you @lousyfool - I understand much better now
Kind regards
Miles