Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report? | Discussions

Expand all | Collapse all

Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

  • 1.  Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Posted 10-17-2017 21:46
    Can you display a table's report on a form that highlights the current form's record on the report? 


  • 2.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Posted 10-17-2017 23:04
    Not easily.  I can think of an approach, but it would not be a casual undertaking.  You would need to control how a user accesses a record to view or edit it, and then have them click a spewcial buttn to View or edit the record. 

    That would record the user's "Focus Record ID#" and then that Focus Record ID# would be able to be looked up back down into the table and then a formula would be able to highlight.


  • 3.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Posted 10-17-2017 23:08
    Ok.  These users can't edit.  It is not a hard requirement for my task.  More of a curiosity at this point.  I think I'll pass on it for now, but thanks for the reply as I may reference it again in the future if needed.


  • 4.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Top
    Contributor
    Posted 10-18-2017 01:53
    I am totally confused by your question. Do you have one table you are dealing with or are their two related tables involved? I am sure there is a ridiculously short solution to your problem using script so please elaborate or even attach an annotated sketch of what you want things to look like.


  • 5.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Posted 10-18-2017 02:04
    I believe the OP is saying that there is a single table of say Orders. Then on that table there is a form of a particular open order. On that form she wants to list all the open orders which she can do with the report link field and a filter on the report to just so show open orders, but she wants to highlight the order record she is sitting on which is appearing I�m on others in that embedded report of other open orders.


  • 6.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Top
    Contributor
    Posted 10-18-2017 02:11
    Oh that is easy to do with script. Let me give you a head start with your native solutions and we can compare notes.


  • 7.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Posted 10-18-2017 02:15
    There is not a good native solution. It would take me 45 minutes working with my solution to get it working.


  • 8.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Top
    Contributor
    Posted 10-18-2017 02:21
    I tell you what - put in a User Voice suggestion for a native feature and I will give you a two year head start. To make it a fair challenge I will not use any script technique that does not already exist as of today. Deal?


  • 9.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Posted 10-18-2017 10:27
    no deal :)


  • 10.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Top
    Contributor
    Posted 10-18-2017 10:59
    Let me sweeten the pot. I will give you a ten yeas head start for your native solution and on my part I will come up with a dozen uniquely different ways to solve the same problem with script. Deal?


  • 11.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Top
    Contributor
    Posted 10-18-2017 03:16
    It is basically one tiny line of script. View or Edit a record:




    Highlight Row In Embedded Report
    https://haversineconsulting.quickbase.com/db/bm6ytxgqx

    Pastie Database
    https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=608


  • 12.  RE: Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

    Posted 10-18-2017 13:10
    That is what I was looking for.  Thank you so much!