Record who presses a URL Button
Hi, We are using QB as a Knowledge Hub, uploading documents from our various projects and programmes. The documents are our companies IP. Accordingly we want to be able to track who is download...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt would be better to have a child table to log who viewed the file as the logged field could get to be very long, but try this. I am using formula variables to break up the formula into smaller pieces.
var text Log = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_99=Viewed"; // replace 99 with the logged field with logging the time enabled..
var text ViewFile = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0";
var text LogAndView =
$Log
& "&rdr=" & URLEncode($ViewFile);
If([Restricted Access]=false and ToText([Attachment])<>"",
$LogAndView)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text Log = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_99=Viewed"; // replace 99 with the logged field with logging the time enabled..
var text ViewFile = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0";
var text LogAndView =
$Log
& "&rdr=" & URLEncode($ViewFile);
If([Restricted Access]=false and ToText([Attachment])<>"",
$LogAndView)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Awesome!
Thank you very much Mark!
For those playing at home, you can't use Log as a variable, so just changed to Loog and it worked perfectly. (I didn't know that, QB told me.)
I just need to insert the app token into the formula and we are all good, turn app tokens back on and we are all good!
The child record approach might be much better, as then we could quite easily search and aggregate data on who is downloaded what, and how much. Pointers for this appreciated. (If complicated or stretching the friendship i can live with this solution for now!)
Thanks again.
Gerome
------------------------------
Gerome Rich
------------------------------
Thank you very much Mark!
For those playing at home, you can't use Log as a variable, so just changed to Loog and it worked perfectly. (I didn't know that, QB told me.)
I just need to insert the app token into the formula and we are all good, turn app tokens back on and we are all good!
The child record approach might be much better, as then we could quite easily search and aggregate data on who is downloaded what, and how much. Pointers for this appreciated. (If complicated or stretching the friendship i can live with this solution for now!)
Thanks again.
Gerome
------------------------------
Gerome Rich
------------------------------
- MarkShnier__YouThis is the line which edits the record to update that log field.
var text Log = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_99=Viewed"; // replace 99 with the logged field with logging the time enabled..
If you make a child table to the main table with the file on it, you can populate the field for Related Knowledge Hub record.
so you can change that line to just this.
var text Log = URLRoot() & "db/" & Dbid() & "?act=API_AddRecord"
& "&_fid_10=" & [Record ID#]
& "&apptoken=xxxxxxxxxxxxx";
Normally when adding a child record you would also populate specific fields. But in this case the record owner will be the person who pushed the button and of course the date created will be the date and time that the record was created. So the only field that we need to update is the field for related Knowledge hub record. so you would replace the 10 with the field ID for that field. Since the value we want to populate into that field for Related Parent is of course the Record ID of the Parent then we just put the Record ID into that field because we are in fact launching the button off the parent record.
And yes you are correct that I neglected to mention that if you have left the need for application tokens enabled then you do need to provide the application token when you are adding or editing records.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Super Star!
Thank you very much.
A bit of tweaking on the & dbid () to reference the actual table, and we were away. (for those playing at home!)
Much better solution!
You are a star. I really appreciate your time.
Regards
Gerome
------------------------------
Gerome Rich
------------------------------
