Forum Discussion
DavidLessin
4 years agoQrew 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
------------------------------
------------------------------
David Lessin
------------------------------
MarkShnier__You
Qrew Legend
4 years agoOK, 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
------------------------------
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
------------------------------
- DavidLessin4 years agoQrew MemberThank 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
------------------------------