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
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Can you display a table's report on a form that highlights the current form's record on the report? 
Photo of Tamara

Tamara

  • 396 Points 250 badge 2x thumb

Posted 2 years ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,884 Points 50k badge 2x thumb
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.
Photo of Tamara

Tamara

  • 396 Points 250 badge 2x thumb
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.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,884 Points 50k badge 2x thumb
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.
(Edited)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
Oh that is easy to do with script. Let me give you a head start with your native solutions and we can compare notes.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,884 Points 50k badge 2x thumb
There is not a good native solution. It would take me 45 minutes working with my solution to get it working.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,884 Points 50k badge 2x thumb
no deal :)
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
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?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,184 Points 20k badge 2x thumb
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
Photo of Tamara

Tamara

  • 396 Points 250 badge 2x thumb
That is what I was looking for.  Thank you so much!