Forum Discussion

LarryThanner's avatar
LarryThanner
Qrew Member
6 years ago

How can i use a formula URL to add new child record then be redirected back to parent record

I have a parent table where when creating a record for this table, there is a button to add children to this record.  so rather than save and exit the form for making the parent record, I have the set...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Close, but you are are missing an equals sign

$Addchild & "&NextURL="& URLEncode($displayparent)

But you really could just stick with the native add child syntax


URLRoot() & "db/" & [_DBID_FA_IR_DATABASE] & "?a=API_GenAddRecordForm&dfid=2&_fid_22=" & URLEncode ([ID Number])
& "&z=" & Rurl()

that last part

& "&z=" & Rurl()

tells quick base to return to the place you came from, be it a report or a record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------