Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
Let�s start simple.
Try making formula URL field, not a formula Rich Text field
var text URLONE = URLRoot() & "db/" & [_DBID_ACCESS_LOGS] & "?act=API_AddRecord" & "&_fid_6=" & ToText([Record ID#]));
var text URLTWO = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#]& "/e7/v0\";
// be sure to set the 7 in e7 above to be the field Id Number if the field that is the file attachment
$URLONE
& "&rdr=" & UREncode ($URLTWO)
I put an app in the Exchange that explains this syntax. It is called URL formulas for Dummies. Search on Dummies and you should get a hit.
If you get this working and want to be able to control the appearance if the button and have it be a link with the file name, let's tackle that one after the easier version is working.
Let me know how it goes and if you get any syntax errors please post you formula and the error.
Try making formula URL field, not a formula Rich Text field
var text URLONE = URLRoot() & "db/" & [_DBID_ACCESS_LOGS] & "?act=API_AddRecord" & "&_fid_6=" & ToText([Record ID#]));
var text URLTWO = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#]& "/e7/v0\";
// be sure to set the 7 in e7 above to be the field Id Number if the field that is the file attachment
$URLONE
& "&rdr=" & UREncode ($URLTWO)
I put an app in the Exchange that explains this syntax. It is called URL formulas for Dummies. Search on Dummies and you should get a hit.
If you get this working and want to be able to control the appearance if the button and have it be a link with the file name, let's tackle that one after the easier version is working.
Let me know how it goes and if you get any syntax errors please post you formula and the error.