Forum Discussion

DavidLessin's avatar
DavidLessin
Qrew Member
4 years ago

How to use GenAddRecordForm and update the child record's multiple fields using data from the parent record

I am trying to add a related record and update the URL code to include updates to the child record with data from one more than one field on the parent record.  I have been unable to find any code exa...
APIs and custom code
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
OK, no problem

URLRoot() & "db/" & [_DBID_ACCESS] & "?a=API_GenAddRecordForm"
& "&_fid_21=" & URLEncode ([WAN-Xchange Loc ID])
& "&_fid_11 =" & URLEncode [Client (Related)]
& "&z=" & Rurl()

I suggest lining up the _fid_ 's vertically to get the syntax correct.

Note also that the & at the beginning of each line is concatenation just like Excel,   but the & inside the quotes says to Quickbase "Heads up! Parameter comin' at ya", and then it specifies the type of Parameter.





------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
DavidLessin's avatar
DavidLessin
Qrew Member
4 years ago
Thank you Mark! 

Lining up the _Fid_ was an extremely helpful suggestion, which allowed me to focus on misplaced "! 

This is what I ended up with, and I have at least a dozen other action buttons that an use similar treatment, so I will get plenty of practice!

URLRoot() & "db/" & [_DBID_ACCESS] & "?a=API_GenAddRecordForm"
& "&_fid_9 =" & URLEncode ([Client (Related)])
& "&_fid_11 =" & URLEncode ([Project (Related)])
& "&_fid_21 =" & URLEncode ([WAN-Xchange Loc ID])
& "&z =" & Rurl()

------------------------------
David Lessin
------------------------------