Case function syntax error
I am trying to implement the solution described in this article http://quickbase.intuit.com/quickbase-blog/colorful-icons-make-quickbase-faster but I am getting a syntax error on my case function. Hel...
Forum Discussion
A similair situation though a bit different...
I would like to use the progress bar icons
https://login.quickbase.com/db/bcgnn27bx?act=QuickSearch&srchtxt=progress&Find=
on a 'Formula%" field based on a field called ie %Milestone
something like (in my human logic & language)
if ( [ %milstone]=0, "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rzd/eh/va/progress0.png>",
if ( [ %milstone]> 0 and [ %milstone] <25 , "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rze/eh/va/progress25.png>",
if ( [ %milstone]> 24 and [ %milstone] <50 , "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rzf/eh/va/progress50.png>",
if ( [ %milstone]> 49 and [ %milstone] <75 , "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rzg/eh/va/progress75.png>",
if ( [ %milstone]=100, "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rzh/eh/va/progress100.png>",
)))))
This is however not the proper code for QB i'm afraid.
I tried different variations but can't find the proper context yet
syntax check replies "Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets." and points to the first '('
Any suggestions?
I would like to use the progress bar icons
https://login.quickbase.com/db/bcgnn27bx?act=QuickSearch&srchtxt=progress&Find=
on a 'Formula%" field based on a field called ie %Milestone
something like (in my human logic & language)
if ( [ %milstone]=0, "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rzd/eh/va/progress0.png>",
if ( [ %milstone]> 0 and [ %milstone] <25 , "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rze/eh/va/progress25.png>",
if ( [ %milstone]> 24 and [ %milstone] <50 , "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rzf/eh/va/progress50.png>",
if ( [ %milstone]> 49 and [ %milstone] <75 , "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rzg/eh/va/progress75.png>",
if ( [ %milstone]=100, "<img src=https://login.quickbase.com/up/bcgnn27bx/g/rzh/eh/va/progress100.png>",
)))))
This is however not the proper code for QB i'm afraid.
I tried different variations but can't find the proper context yet
syntax check replies "Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets." and points to the first '('
Any suggestions?
I did find this thread...
https://community.quickbase.com/quickbase/topics/status-icon-formula-help though when that is indeed the only sollution I would need to bring some more code into the %milstone formule so that can only produce 0,25,50,75 or 100 as result.
This thread https://community.quickbase.com/quickbase/topics/what-could-be-wrong-with-this-case-formula indicated it should work somehow witth the IF -function also
https://community.quickbase.com/quickbase/topics/status-icon-formula-help though when that is indeed the only sollution I would need to bring some more code into the %milstone formule so that can only produce 0,25,50,75 or 100 as result.
This thread https://community.quickbase.com/quickbase/topics/what-could-be-wrong-with-this-case-formula indicated it should work somehow witth the IF -function also