Forum Discussion
MarkShnier__You
Qrew Champion
Correction to the above
var text Dummy = URLRoot & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxxxxxx" // needed if you have the need to app tokens enabled
& "&_fid_100=1"; // make the Dummy checkbox true
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var text Dummy = URLRoot & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxxxxxx" // needed if you have the need to app tokens enabled
& "&_fid_100=1"; // make the Dummy checkbox true
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MelissaFreel1
4 years agoQrew Cadet
Mark:
Thanks for the help. I got it to "slightly" work. I think the place where I am struggling is with your fid10 and fid 11. I think I am misunderstanding what you mean by "5". Here is what I have so far:
//Add Utility Allowances
var text LABEL= "Add Allowance";
var text Dummy = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [HH Record ID#]
& "&_fid_3037=1"; // make the Dummy checkbox true
var text URLONE = If([Heating Natural Gas]=false, $Dummy, URLRoot() & "db/" & [_DBID_TEST] & "?act=API_AddRecord"
& "&_fid_3=" & [HH Record ID#]// Record Id of Parent
& "&_fid_33=" & 5 // Related Record in Child
& "&_fid_8=" & [Structure]// change the structure field in child to the selected information in parent [Structure]
& "&_fid_11=" & "Heating Natural Gas"//change the utility type field in child to utility type identified with check box 1
& "&rdr=");
//Put 9 more in
var text URLTEN = URLRoot() & "db/" & Dbid() & "?a=dr&rid=[ & [Record ID#]"; // redisplay the Parent record
var text URLALL=$URLONE & URLEncode($URLTEN);
"<a class='Vibrant Alert' href='" & $URLALL & "'>" & $LABEL & "</a>"
------------------------------
Melissa Freel
------------------------------
Thanks for the help. I got it to "slightly" work. I think the place where I am struggling is with your fid10 and fid 11. I think I am misunderstanding what you mean by "5". Here is what I have so far:
//Add Utility Allowances
var text LABEL= "Add Allowance";
var text Dummy = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [HH Record ID#]
& "&_fid_3037=1"; // make the Dummy checkbox true
var text URLONE = If([Heating Natural Gas]=false, $Dummy, URLRoot() & "db/" & [_DBID_TEST] & "?act=API_AddRecord"
& "&_fid_3=" & [HH Record ID#]// Record Id of Parent
& "&_fid_33=" & 5 // Related Record in Child
& "&_fid_8=" & [Structure]// change the structure field in child to the selected information in parent [Structure]
& "&_fid_11=" & "Heating Natural Gas"//change the utility type field in child to utility type identified with check box 1
& "&rdr=");
//Put 9 more in
var text URLTEN = URLRoot() & "db/" & Dbid() & "?a=dr&rid=[ & [Record ID#]"; // redisplay the Parent record
var text URLALL=$URLONE & URLEncode($URLTEN);
"<a class='Vibrant Alert' href='" & $URLALL & "'>" & $LABEL & "</a>"
------------------------------
Melissa Freel
------------------------------
- MarkShnier__You4 years agoQrew ChampionMelissa,
This line here
& "&_fid_3=" & [HH Record ID#]// Record Id of Parent
You cannot populate the [Record ID#] field of a Table. Fid 3 on the child table is the field for its Record ID#. The field to populate is the field in your relationship for [Related parent].
There are also likely other problems which will require working with you one on one to get this working.
The other approach that is possible on a no code basis would be to set up a table of nine records and have an Automation copy those nine records in, and then have the next step of he Automation delete the ones which are not valid based on the checkboxes selected in he parent.
I think we need to either work one one one to get the URL method working or else switch gears and try to get an Automation working.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------