Forum Discussion
MarkShnier__You
Qrew Champion
Scott
I will break down the explanation of the formula so you can understand what its doing.
URLRoot() & "db/" & [_DBID_TABLE_4]
// the above takes the user to your table
& "?a=API_GenAddRecordForm&_fid_48=" & URLEncode ([Record ID#])
// the above puts up an Add Record form and populates field 48 with the value of the Record ID#
// that you launched off of. That way the Bill is connected to the Parent Shipment
& "&z=" & Rurl()
The above will return the user back to the parent Shipment record after the bill is saved.
So what we need to do to the above formula is also to populate the field on the Bill record for [Related Contact].
URLRoot() & "db/" & [_DBID_TABLE_4]
& "?a=API_GenAddRecordForm&_fid_48=" & URLEncode ([Record ID#])
& "&_fid_99=" & ([Related Contact])
& "&z=" & Rurl()
// so we will add in an extra line. You will need to look at your field list or relationships to
find the field ID to populate and put that where the 99 is. Then you will have to see which
//field in your Shipment table has the Record ID# of the Related contact, but it is probably
// called [Related Contact]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I will break down the explanation of the formula so you can understand what its doing.
URLRoot() & "db/" & [_DBID_TABLE_4]
// the above takes the user to your table
& "?a=API_GenAddRecordForm&_fid_48=" & URLEncode ([Record ID#])
// the above puts up an Add Record form and populates field 48 with the value of the Record ID#
// that you launched off of. That way the Bill is connected to the Parent Shipment
& "&z=" & Rurl()
The above will return the user back to the parent Shipment record after the bill is saved.
So what we need to do to the above formula is also to populate the field on the Bill record for [Related Contact].
URLRoot() & "db/" & [_DBID_TABLE_4]
& "?a=API_GenAddRecordForm&_fid_48=" & URLEncode ([Record ID#])
& "&_fid_99=" & ([Related Contact])
& "&z=" & Rurl()
// so we will add in an extra line. You will need to look at your field list or relationships to
find the field ID to populate and put that where the 99 is. Then you will have to see which
//field in your Shipment table has the Record ID# of the Related contact, but it is probably
// called [Related Contact]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
SCOTTALARCON
5 years agoQrew Member
That did the trick! Thank you so much for taking the time to break down the formula!
------------------------------
SCOTT ALARCON
------------------------------
------------------------------
SCOTT ALARCON
------------------------------