Questions on forms and editing from a report
I have a report which currently is the only object on my role's Home Page. This report contains data from both a parent and the table being reported. When I am testing, I can see that if I click t...
Forum Discussion
What am I missing?
The report is on Tickets. It displays six field, all are fields in Tickets.
The problematic field 'Internet Client - Related Event - Event Date & Time' displays a EOTI form when I click on a value in this particular column.
The other five columns displays a Ticket form.
Both one of the other five columns, 'EOTI Clients and Registration - Full Name', and this problematic column are fields in Tickets. Both are lookup fields in the EOTI Clients and Registration (parent) < (or is it >?) Ticket (child) relationship. Neither are the reference or reference proxy field.
I went back and re-read your answer... I think the 'difference' is that for the problematic field, I have 'Display as a link to the related record' while the other field that is acting as desired, does not have this checkbox checked in the Field Properties. Did I pull those pieces together correctly?
I'll have to think if I want to be able to link back to the parent record from both fields (as they are both reference lookup fields and normally would be used at the same time).
------------------------------
Katherine Oakey
------------------------------
The report is on Tickets. It displays six field, all are fields in Tickets.
The problematic field 'Internet Client - Related Event - Event Date & Time' displays a EOTI form when I click on a value in this particular column.
The other five columns displays a Ticket form.
Both one of the other five columns, 'EOTI Clients and Registration - Full Name', and this problematic column are fields in Tickets. Both are lookup fields in the EOTI Clients and Registration (parent) < (or is it >?) Ticket (child) relationship. Neither are the reference or reference proxy field.
I went back and re-read your answer... I think the 'difference' is that for the problematic field, I have 'Display as a link to the related record' while the other field that is acting as desired, does not have this checkbox checked in the Field Properties. Did I pull those pieces together correctly?
I'll have to think if I want to be able to link back to the parent record from both fields (as they are both reference lookup fields and normally would be used at the same time).
------------------------------
Katherine Oakey
------------------------------
MarkShnier__You
Qrew Legend
Qrew Legendyes this is correct
I have 'Display as a link to the related record' while the other field that is acting as desired, does not have this checkbox checked in the Field Properties. Did I pull those pieces together correctly?
So you can disable the field acting as a hyperlink by deselecting the checkbox field. However you may have some internal users where that link is useful especially when on a form looking at a single record. If that is the case then you can make a new field where the formula is simply the field which is hyperlinked. The formula field will not end up being hyper linked. Use that non-hyperlink field on your dashboard reports.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I have 'Display as a link to the related record' while the other field that is acting as desired, does not have this checkbox checked in the Field Properties. Did I pull those pieces together correctly?
So you can disable the field acting as a hyperlink by deselecting the checkbox field. However you may have some internal users where that link is useful especially when on a form looking at a single record. If that is the case then you can make a new field where the formula is simply the field which is hyperlinked. The formula field will not end up being hyper linked. Use that non-hyperlink field on your dashboard reports.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thank you... I think the pieces are starting to fall into place :)
------------------------------
Katherine Oakey
------------------------------