Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoreplace this
?a=dr&r=bn&rl=ck"
?a=dr&rid=" & [record ID# of the Grand Parent]
you will get the record ID# of the grand parent by a lookup off the parent record which might be called [Related Parent], but on the lookup call it something like [Record ID# of Grand Parent] (obviously substitute the real name of the table)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
DanMcLaughlin
5 years agoQrew Trainee
Ok I did that but now I keep getting an error that it cannot find the record. I am assuming i have a parsing error in here somewhere?
var text redirectafter = URLRoot() & "db/" & Dbid() & "?a=dbpage&pageName=success3.html";
"<a class='Vibrant Snowy' style=\"width:310px; text-align: center;\" onclick='RedirectURL.value=\"https://scenicsolutionsllc.quickbase.com/db/bqnffbzdf?a=dr&rid="&[LINE ITEM - Related Cost Estimate]& $redirectafter &"\";editform.rl.value=(\"\");DoSave()'; href='#' > Save and Go to Estimate</a>"
------------------------------
Dan McLaughlin
------------------------------
var text redirectafter = URLRoot() & "db/" & Dbid() & "?a=dbpage&pageName=success3.html";
"<a class='Vibrant Snowy' style=\"width:310px; text-align: center;\" onclick='RedirectURL.value=\"https://scenicsolutionsllc.quickbase.com/db/bqnffbzdf?a=dr&rid="&[LINE ITEM - Related Cost Estimate]& $redirectafter &"\";editform.rl.value=(\"\");DoSave()'; href='#' > Save and Go to Estimate</a>"
------------------------------
Dan McLaughlin
------------------------------
- MarkShnier__You5 years ago
Qrew Legend
I suggest that you look at value in the field for [LINE ITEM - Related Cost Estimate] to see if that is in fact the Record ID that you want to display.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- DanMcLaughlin5 years agoQrew TraineeId do have a value appearing for the record ID
------------------------------
Dan McLaughlin
------------------------------- MarkShnier__You5 years ago
Qrew Legend
If you put this into a URL what happens
https://scenicsolutionsllc.quickbase.com/db/bqnffbzdf?a=dr&rid=13
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------