Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
You can make a Hyperlink field and use that as the group by for the rows of your summary report.
The Syntax for a general hyperlink field is a formula Rich Text field
var text $Words = [your field name here foe the words];
var text $URL = [The URL formula field or formula field you want to execute];
"<a href=" & $URL & ">" & $Words & "</a>"
now whether this syntax will work is dependent on the complexity of the URL. It should work if you just do one API call.
Like this
var text URL= URLRoot() & "db/" & [_DBID_TABLE_1] & "?act=API_EditRecord"
& "&rid=" & URLEncode ([Record ID#])
& "&_fid_7=" & URLEncode ([Status])
& "&apptoken=" & "XXXX";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
I suggest getting the URL formula field working first, and then getting the Hyperlink to work
The Syntax for a general hyperlink field is a formula Rich Text field
var text $Words = [your field name here foe the words];
var text $URL = [The URL formula field or formula field you want to execute];
"<a href=" & $URL & ">" & $Words & "</a>"
now whether this syntax will work is dependent on the complexity of the URL. It should work if you just do one API call.
Like this
var text URL= URLRoot() & "db/" & [_DBID_TABLE_1] & "?act=API_EditRecord"
& "&rid=" & URLEncode ([Record ID#])
& "&_fid_7=" & URLEncode ([Status])
& "&apptoken=" & "XXXX";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
I suggest getting the URL formula field working first, and then getting the Hyperlink to work