Forum Discussion

Qrew Member

3 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

DavidLessin

Qrew Member

Thanks Mark... I am very familiar with relationships, but the business is pretty dynamic and we get numerous quotes that for the same sites. In fact the bid ID will change, but in the case, I just to see how to update the fields. In the long tern, I will update the relationship so only 1 field will vary (bids).

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

MarkShnier__You

Qrew Legend

3 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
Qrew Member
3 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
------------------------------