Create Duplicate Record from Child Subtable
I have a subtable of child records on a parent form. I want to create a button that can be clicked from the subtable. When it's clicked, I want it to add a new child record, & copy over all of the val...
Forum Discussion
Downloaded, and the formulas you have there make sense. The part I'm stuck on is how to populate the fields dynamically based on which child record the button is clicked from. In your examples, the field values are hard-coded ("PO Line Approved"}. Or maybe I'm just missing something obvious.
------------------------------
Harrison Smith
------------------------------
------------------------------
Harrison Smith
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendOK, here is another example
var text ClockPunch = URLRoot() & "db/" & [_DBID_TIME_PUNCH] & "?act=API_ADDRecord"
& "&apptoken=xxxxxxxxxxxx"
& "&_fid_17=" & URLEncode([Field 1])
& "&_fid_81=" & URLEncode([Field 2]);
var text ReturnToEmployeeClockForm= URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];
$ClockPunch
& "&rdr=" & URLEncode($ReturnToEmployeeClockForm)
// in this example i am putting the values from Field 1 into field ID 17.
// if you have Application Tokens enabled, the you will also need to include that line
// if the data you are putting into any of the fields might have spaces or special characters, then you should URLEncode them or it might fail. You are creating a URL click which needs to travel though the mysteries of the internet and the internet does not like spaces or special characters in URLs.
if your formula does not work, please post an editable copy and paste the code and not a screen shot of the code.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text ClockPunch = URLRoot() & "db/" & [_DBID_TIME_PUNCH] & "?act=API_ADDRecord"
& "&apptoken=xxxxxxxxxxxx"
& "&_fid_17=" & URLEncode([Field 1])
& "&_fid_81=" & URLEncode([Field 2]);
var text ReturnToEmployeeClockForm= URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#];
$ClockPunch
& "&rdr=" & URLEncode($ReturnToEmployeeClockForm)
// in this example i am putting the values from Field 1 into field ID 17.
// if you have Application Tokens enabled, the you will also need to include that line
// if the data you are putting into any of the fields might have spaces or special characters, then you should URLEncode them or it might fail. You are creating a URL click which needs to travel though the mysteries of the internet and the internet does not like spaces or special characters in URLs.
if your formula does not work, please post an editable copy and paste the code and not a screen shot of the code.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------