Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Try this
URLRoot()&"DB/"&[_DBID_xxxxx] &"?A=API_EDITRECORD&rid="&[Record ID#]
& "&_fid_22=" & ToText(Now())
& "&_fid_999=" & ToText([Calculated Secret Code]
&
"&rdr=" & URLEncode(URLRoot() & "db/" &[_DBID_xxxxx] & "?a=er&key="&[Record ID#]&"&dfid=12")
//999 is the fid of the secret code field
URLRoot()&"DB/"&[_DBID_xxxxx] &"?A=API_EDITRECORD&rid="&[Record ID#]
& "&_fid_22=" & ToText(Now())
& "&_fid_999=" & ToText([Calculated Secret Code]
&
"&rdr=" & URLEncode(URLRoot() & "db/" &[_DBID_xxxxx] & "?a=er&key="&[Record ID#]&"&dfid=12")
//999 is the fid of the secret code field