Forum Discussion

samhari's avatar
samhari
Qrew Trainee
7 years ago

Autofill Multiple Child records from sibling table

Hello i am brand new to quickbase so please forgive me if some of my terms are incorrect or misleading, I'm trying to be as clear as possible. So say i have 4 tables Jobs, Job Details, Travelers, and ...
Forms
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Here is some code for a URL formula button

var text SetFocus =
URLRoot() & "db/" & [_DBID_USER_FOCUS] & "?act=API_EditRecord"
& "&apptoken=xxxxxxx"
& "&rid=1"
& "&_fid_7=" & [Record ID# of Job];

var text RunImport = 
URLRoot() & "db/" & [_DBID_table name from its advanced properties]
& "?act=API_RunImport&ID=10"
& "&apptoken=xxxxxxx";

var text DisplayRecord=
URLRoot() & "db/" & Dbid()  &"?a=dr&rid=" & [Record ID#];


$SetFocus
& "&rdr=" & URLEncode($RunImport)
& URLEncode("&rdr=" & URLEncode($DisplayRecord))