Discussions

Expand all | Collapse all

icon formula for currency

  • 1.  icon formula for currency

    Posted 08-09-2018 16:04
    i am trying to create an icon that will display when the [price] is equal to 0.

    I tried an If statement and a Case statement and i am getting compatibility errors. What to i start the formula out with for currency type field? do i need to convert it to numeric first?



  • 2.  RE: icon formula for currency

    Posted 08-10-2018 02:12
    There is a list of icons you can use here.

    https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=160



    You can make a formula Rich text field like this

    IF([Price]=0, "<img src=https://images.quickbase.com/si/24/204-warning.png>")


  • 3.  RE: icon formula for currency

    Posted 08-10-2018 02:13
    That got wrapped a bit.  The beginning will look like

    IF([Price]=0, "<img src= ........


  • 4.  RE: icon formula for currency

    Posted 08-16-2018 14:49
    How would i modify the formula to not show the symbol if the field is left blank? i only want the symbol when the user enters zero.


  • 5.  RE: icon formula for currency

    Posted 08-16-2018 16:30
    Set the field properties on the Price field to not treat blank as zero.