Calculated Field Format or Mask Money format

  • Resolved metanoia77

    (@metanoia77)


    9 years, 7 months ago

    Hello

    I have a calculated field %slugA% * %slugB% and I have it in money format

    so it is 888.00 but when I get to 200000.00 or 10000.00 I need comma separation 200,000.00 or 10,000.00

    I can’t find out how to get the commas as they are more important than the .00

    so if I add an input mask on slugA ‘￡ [999,999]’ it breaks the calculation I only get 0.00
    so how can I calculate with a field with an input mask ? and how do I get commas in the money format please ?

    https://www.ads-software.com/plugins/caldera-forms/

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Contributor David Cramer

    (@desertsnowman)

    Hi there.

    Is the comma formatted purely for display or do you need it that way for storage? Technically 1000,000.00 is not a valid number it’s a currency formatted string.

    I am however adding to the next update currency formatting for the display part. the value you see in the calculator. but it still saves the standard float value.

    Thread Starter metanoia77

    (@metanoia77)

    Hello David

    No purely for display as $100,000.00 is easier to read than $100000.00 not storage I understand that to do maths the comma cannot be in the in the storage and computers don’t need commas ?? on the tricky humans

    But doing maths on a field with an input mask is a bit of a strange one
    If we could take the mask off to a hidden field to maths ?? so when the user enters into a masked field there is a way to take an unmasked value automatically to a hidden unmasked field ??? like Fieldb = Field A – mask ??

    Thanks

    Plugin Contributor David Cramer

    (@desertsnowman)

    ok, I added stripping , from masked inputs to make it acceptable calculation inputs. however adding other characters to the mask will break it still.

    this will be available in next update. or if you need it right this min. you can get the dev version from the github repo. https://github.com/Desertsnowman/Caldera-Forms

    Plugin Contributor David Cramer

    (@desertsnowman)

    this has been added to the current version 1.1.9.7 update to try it out.

    It works simply by setting the calculator field to Money Format.

    Aaaaaah! David! ??
    Cool you add the Feature but it destroys the layout for european users… sorry but we need dots! Example: 100.000 or

    derbuprofi

    Can you please add this? *pleasewithalittleaddofsugar*

    Plugin Contributor David Cramer

    (@desertsnowman)

    Ok sure. I’ll add in a setting to set your separator.

    7 Minutes for a solution… David “the lightning” Cramer! Big thanks!

    I will add a 5 star rating to caldera because I love it! ??

    Plugin Contributor David Cramer

    (@desertsnowman)

    Haha!

    Plugin Contributor David Cramer

    (@desertsnowman)

    Added. You’ll get a custom separator setting when checking money format. You can download the latest version from the github repo. https://github.com/Desertsnowman/Caldera-Forms

    Thread Starter metanoia77

    (@metanoia77)

    Hi David

    Thanks a lot ??

    I already gave 5* and already put support is truly amazing – but debasti has it nailed with the 7 mins. ??
    Thanks bro

    maninbowler

    (@maninbowler)

    Hi David.

    I read the announcment of additional features in this closed thread:
    https://www.ads-software.com/support/topic/input-masking?replies=3

    How are your plans on further inluding european formats?
    I would love to be able to pick the comma-separator (radixpoint) for the decimal digits.
    (100,99 € – onehundred euros and ninetynine cents)

    Regards

    Roman

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Calculated Field Format or Mask Money format’ is closed to new replies.