Users will not be logged into Quickbase. The ultimate goal is to track how many times the QR code was scanned.
Qrew LegendA suggestion then would be to make a child table to record scans. We would open up the child table to be open to Every On The Internet (EOTI) to be able to add records and allow the EOTI Role to view the -parent records - call these say Items.
Then to see how many times the item was scanned we just to a summary count of the #of children. Does that approach work for you?
Yes. I think that will work.
Qrew LegendOK, here's what the code would look like. I have not tested it so it may need some syntax debugging. Post back if there are any issues you can't solve.
// create a child record and populate related parent with the Record ID#
// of the related parent
var text LogUse = URLRoot() & "db/" & [_DBID_of_the_child_Log_table] & "?act=API_AddRecord"
& "&_fid_6=" & [Record ID#];
var text DisplayRecord = URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];
$LogUse
& "&rdr=" & URLEncode(DisplayRecord)
Thanks, Mark. Fortunately, I have had some practice putting the formula URLs together so, I should be fine from here. Thanks for the input and direction.
