AnsweredAssumed Answered

Calculation fields that require HTML

Question asked by Macz on Feb 24, 2018
Latest reply on Feb 24, 2018 by philmodjunk
  • Comment • 6

Hello all! I hit another snag and was hoping someone could help.

My goals is to have a field that depending on what is selected in the filed will output something different in a second field.

 

As a test I used the following Calculation field:

 

Case ( Hemingray Insulators reference::Verified? = "Verified" ; "V" ; Hemingray Insulators reference::Verified? = "Not Verified" ; "N")

 

This worked as Expected. Problem is the actual thing I want to have the second filed changed to is HTML code so causes an script error  (Need it to export html as when I export a CSV file and upload it to my website it will display font awesome icons instead of text)

 

<i class="fa fa-check" style="color:#00ca00"></i>

<i class="fa fa-ban" style="color:#cb0000"></i>

 

So how do I get my desired effect of user selects something in a drop down and it puts the pre define HTML in the second field?

 

Thanks!

Shaun

beverly
beverly Expert Feb 24, 2018 1:54 PM
Correct Answer

TIP: writing HTML in a calculation, must be quoted text (double-quotes). So for quotes in attributes, use a single quote:

<i class="fa fa-check" style="color:#00ca00"></i>

becomes:

> ""

  "<i class='fa fa-check' style='color:#00ca00'></i>"

 

Next, if you need something "dynamic" in the HTML (calculated), make use of the & (concatenate text) character:

 

"<i class='fa fa-check' style='color:#" & <<yourCalcHere>> & "'></i>"

 

I might first set the <<yourCalcHere>> with a variable and use that in the HTML:

"<i class='fa fa-check' style='color:#" & $myColor & "'></i>"

 

You just have to watch those quotes! FileMaker will tell you if you did it wrong.

 

Beverly

 

EDITED: code got munged in email reply

See the reply in context
No one else had this question

Outcomes