Forum Discussion
ColeenSchmitt1
7 years agoQrew Cadet
Hi, are you able to post the working example here? I'm running into the same thing where I'd like to include the URL in a Rich Text field but it is not reading my var text in the HTML code.
- NathanCall6 years agoQrew TraineeI have a working example for a formula URL field that I found to work great. For whatever reason, I couldn't' get Javascript to work withint the Formula Rich Text Field after the update to that fields properties that Quick Base did.
Mine has an IF statement but works either way. I have found that this will reload you on your current page without redirecting you to a different page. It also keeps you in the same spot of the report that you are on which is nice. Here is my example:
If(
[Call Phone Trigger] = false,
"javascript:" &
"$.get('" &
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=xxxxxxxxx&_fid_264=true&rid=" & [Record ID#]&
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);",
"javascript:" &
"$.get('" &
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=xxxxxxxx&_fid_264=false&rid=" & [Record ID#]&
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);")