URL for opening grandparent record
I?m working with three tables: Use Profiles, Sites, and Reports. - Sites is a parent to Reports - User Profiles is a parent to Sites The User Profiles table has a Qui...
Forum Discussion
Hey,
I tried to use this formula to get into the grandparent record as well and it doesn't seem to be working. You don't mention it in the comments but I used a formula URL field. not sure which formula field I need to create the hyperlink.
var text URL = URLRoot() & "db/" & [_DBID_IDSS] & "?a=dr&rid=" & [Related IDS];
This is the formula that I came up with from your breakdown and I seem to get an error... "A variable declaration must end with a semi-colon"
also, what do you mean by "[_DBID_Table name that you get from Advanced properties in square brackets]" I found the "Table Alias" in advanced settings and assumed that's what you're talking about but want to make sure.
------------------------------
Jack Woods
------------------------------
I tried to use this formula to get into the grandparent record as well and it doesn't seem to be working. You don't mention it in the comments but I used a formula URL field. not sure which formula field I need to create the hyperlink.
var text URL = URLRoot() & "db/" & [_DBID_IDSS] & "?a=dr&rid=" & [Related IDS];
This is the formula that I came up with from your breakdown and I seem to get an error... "A variable declaration must end with a semi-colon"
also, what do you mean by "[_DBID_Table name that you get from Advanced properties in square brackets]" I found the "Table Alias" in advanced settings and assumed that's what you're talking about but want to make sure.
------------------------------
Jack Woods
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legend1. Yes, I meant the Table Alias.
2. Can you post your complete formula, it looks like you just posted part of it.
3. The field type should be formula Rich Text.
4. The Record ID that you will want to display is the Record ID# of the Grand Parent record. I'm not sure if what's in the field [Related IDS] is the Record ID# of the Grand Parent .. is it?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
2. Can you post your complete formula, it looks like you just posted part of it.
3. The field type should be formula Rich Text.
4. The Record ID that you will want to display is the Record ID# of the Grand Parent record. I'm not sure if what's in the field [Related IDS] is the Record ID# of the Grand Parent .. is it?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- 1. Great thanks
2. You're right - I missed your last line there (Formula Below)
3. I change the field type
4. You're right I reference the wrong field there - I wanted the related Grandparent ID through the middle or junction table which is called Survey.
var text URL = URLRoot() & "db/" & [_DBID_IDSS] & "?a=dr&rid=" & [Survey - Related IDS]"<a href=" & $URL & ">" & $Words & "</a>"
Now the error is in bold - "a variable declaration must end in a semi colon"
------------------------------
Jack Woods
------------------------------- MarkShnier__YouTry this
var text Words = [lookup field from the grandparent to the parent to the grandchild to identify the Grandparent];
var text URL = URLRoot() & "db/" & [_DBID_IDSS] & "?a=dr&rid=" & [Survey - Related IDS];
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- That worked. I might be back later with another case. I'm working with the magic buttons app and am try to make some cool things happen :)
------------------------------
Jack Woods
------------------------------