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
TIP: writing HTML in a calculation, must be quoted text (double-quotes). So for quotes in attributes, use a single quote:
becomes:
> ""
Next, if you need something "dynamic" in the HTML (calculated), make use of the & (concatenate text) character:
I might first set the <<yourCalcHere>> with a variable and use that in the HTML:
You just have to watch those quotes! FileMaker will tell you if you did it wrong.
Beverly
EDITED: code got munged in email reply