Forum Discussion

Qrew Captain

5 years ago

Rich Text Field Showing Javascript Code

Hi everyone, I have a rich text field with a button that "completes" a task. It shows up in multiple places (including my dashboard reports) so I used javascript to return it to the current page. ...

APIs and custom code

Formulas and functions

Qrew Elite

5 years ago

Ivan,

Give them an icon to look at

var text IMG = "<img src=https://images.quickbase.com/si/48/016-email_0.png>";

"<a href=\"javascript:" & "$.get('" & $URL & "', function(){" & "location.reload();" & "});" & "void(0);\">"& $IMG &"</a>"

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------

IvanWeiss
Qrew Captain
5 years ago
Don, will that image show on the button? The button is supposed to say "Complete" as it is to Complete a task....

------------------------------
Ivan Weiss
------------------------------
- DonLarson
  Qrew Elite
  5 years ago
  Ivan,
  
  You can substitute any image or text in that position of the href.
  
  Technically you do not even have to change the name, you can still call it IMG but that is not good practice. It is a declared variable of the type text.
  
  Substitute
  
  var text Message= "Complete";
  
  and then stick $Message in the href.
  
  Since you are setting fields 24 and 36, you can add more logic to allow the User to only execute it once.
  If you add two more variables:
  
  var text TaskComplete = "Task is Complete";
  var text Executable = "<a href=\"javascript:" & "$.get('" & $URL  & "', function(){" & "location.reload();" & "});" & "void(0);\">"& $IMG &"</a>";
  
  Your logic then becomes:
  
  If ( [FID24]<>"Complete", $Execute, $TaskComplete )
  
  Substitute the real name of FID24 in the block. If it has been marked then the Executable will not show and the User will see the message "Task is Complete" and not have a button to push.
  
  ------------------------------
  Don Larson
  Paasporter
  Westlake OH
  ------------------------------