Discussions

Expand all | Collapse all

Hyperlinking Field to Original Table

  • 1.  Hyperlinking Field to Original Table

    Posted 08-20-2017 23:24
    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?   


  • 2.  RE: Hyperlinking Field to Original Table

    Posted 08-21-2017 23:22
    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.


  • 3.  RE: Hyperlinking Field to Original Table

    Posted 08-21-2017 23:40
    ... ie this was an <ask the user> report with 1 question.