Forum Discussion

ArshadKhwaja's avatar
ArshadKhwaja
Qrew Commander
8 years ago

Hyperlinking Field to Original Table

Hyperlinking a field  when summed from a child table is a great option to allow user to drill down. In my situation I have a summary field from table A in the parent table.   As this info is quite interesting I have also chosen to share this with table B by passing it down from parent table.  Issue is that when user clicks on the hyperlink they are taken back to project screen.  Is there a possibility that we could allow user to go to Table A instead?   
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Just to close the loop on this one.  I spoke to Arshad directly.  The issue was that the numerical field was a lookup from a parent record of a summary field.  Clicking that "number", just opened up the Parent record, and did not do the drill down.

    So a quick and dirty solution was to change that number so it did not appear "as a link to the Record", and put a button beside it with this code

    URLRoot() & "db/" & [_DBID_CHILD_TABLE FOR DRILL DOWN]& "?a=q&qid=10&nv=1&v0=" &[Related Project]

    So it will run that report, ask a question and answer its own question and display the drill down results.