Hello,I want to create a button that displays an embedded report from a different table that is related to what's on the current record. I want a button to go in the green circle and open that report that's embedded and related to that unit. Thank you! And I'm such a novice, so please be elementary with me :) ------------------------------Renee Hansen------------------------------

Renee, I'm sure we can do this, but I just need a bit more information.It's also helpful if we can use your real table namesI see that one table is called Calc Entries? If you are just looking to show an embedded table of calc entries matching he field on our record, hen you can create a report link field and set the left side to be that field you have circles, and then on the right aside, locate the matching field in calc entries.If what I posted above does not seem to answer your question can you describe any relationships you have between these two tables and tell us the name of these two tables so we can refer to them. ------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Hi! Yes, in my mind it seems like it should be something we could do :) Ok, let me explain a little further: I have a units table that shows all of the information for that unit, and each unit has a well or many wells. Each well has net royalty interest (NRI) that we get paid on. So we have units, wells, and calculations for the NRI (calc sheet). The relationship for the calc sheet is Leases & Units + Calc Sheet which is a join table for the leases and units. Accounting needs to verify the NRI before assuming it's correct. So my idea is: To have a button that says "request nri verification" that opens up that units calc sheet in a special/unique form: So then, we can approve/not approve for accounting.additionally, on this form shown above - I'd like approve button, not approve button, and the reasons and/or notes. Then a button to email it to accounting and then they can print the hard copy for their records. So it's a multi-step issue - and I feel like the first part is just getting a button created that will open this form that shows the calc sheet for the related unit. does that explain it better? Thank you!!! Renee------------------------------Renee Hansen------------------------------

*also if there is a better way to do this, I'm open to suggestions.------------------------------Renee Hansen------------------------------

Do these only need to be approved once? Or is this a monthly (or other regular time period) approval process? If it's more than one time, you may want to consider having a separate Review/Approval record that is a child to the Unit.------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quick Base Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

These only need to be approved once, and we don't need to keep an ongoing record of approval. It's more-so for accounting to know "yes we are getting paid the correct amount, you can file this away" And I'll note: the special form i created for this is on the Units table, but the embedded report is coming for the calc sheet table, so I'm wondering do i need to change that special form to be on the calc sheet table?------------------------------Renee Hansen------------------------------

Create a button that displays an embedded report from a different table

MarkShnier__You
Qrew Legend
5 years ago
Renee, I'm sure we can do this, but I just need a bit more information.
It's also helpful if we can use your real table names

I see that one table is called Calc Entries?

If you are just looking to show an embedded table of calc entries matching he field on our record, hen you can create a report link field and set the left side to be that field you have circles, and then on the right aside, locate the matching field in calc entries.

If what I posted above does not seem to answer your question can you describe any relationships you have between these two tables and tell us the name of these two tables so we can refer to them.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- ReneeHansen
  Qrew Member
  5 years ago
  Hi!
  
  Yes, in my mind it seems like it should be something we could do :)
  
  Ok, let me explain a little further:
  
  I have a units table that shows all of the information for that unit, and each unit has a well or many wells. Each well has net royalty interest (NRI) that we get paid on.
  
  So we have units, wells, and calculations for the NRI (calc sheet).
  
  The relationship for the calc sheet is Leases & Units + Calc Sheet which is a join table for the leases and units.
  
  Accounting needs to verify the NRI before assuming it's correct. So my idea is:
  
  To have a button that says "request nri verification" that opens up that units calc sheet in a special/unique form:
  
  So then, we can approve/not approve for accounting.
  additionally, on this form shown above - I'd like approve button, not approve button, and the reasons and/or notes.
  
  Then a button to email it to accounting and then they can print the hard copy for their records.
  
  So it's a multi-step issue - and I feel like the first part is just getting a button created that will open this form that shows the calc sheet for the related unit.
  
  does that explain it better?
  
  Thank you!!!
  
  Renee
  
  ------------------------------
  Renee Hansen
  ------------------------------
  - ReneeHansen
    Qrew Member
    5 years ago
    *also if there is a better way to do this, I'm open to suggestions.
    
    ------------------------------
    Renee Hansen
    ------------------------------

Forum Discussion

Create a button that displays an embedded report from a different table

Related Content

Display Thumbnail Image

embedded reports

Default column widths on embedded reports obscuring data

Add button to create record in different app

Embedded Grid Edit Report Pre-filtered Conditional Dropdown