Embed a Report into Another Report's Field
I'm trying to embed a report as a field in another report. Basically this: I've created the code page:
[iol] & "modulecontracts.js" & [/iol]
&
"<span class='QBU_ToggleChildren'" &
" data-rid=...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendSo "IOL" is long dead so nevermind that.
But can we dumb this down a bit. Why not just make a simple native Report Link field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
But can we dumb this down a bit. Why not just make a simple native Report Link field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
What we're wanting is a little tricky. We need a BVA report for individual grants. Each grant contains multiple projects. Within those projects, there are multiple contracts that we want certain information to show. I've tried a field that contains multiple combined fields, but it's very cumbersome and the combined fields don't always match the other related combined fields correctly. eg. when there are multiple contracts the PO #, contract amount, etc. don't always correspond properly.
I also tried a rich text field with a table listing all the information, but I can't get the formula to work, so maybe that's what I need.
------------------------------
Bethany Hudson
------------------------------
I also tried a rich text field with a table listing all the information, but I can't get the formula to work, so maybe that's what I need.
------------------------------
Bethany Hudson
------------------------------
- MarkShnier__YouI'm skiing today, but while I'm taking a few runs, can you describe your tables in their relationships, which is the one in which is the many? And which records you were trying to show on which record?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Many Projects to one Grant Budget. Each Grant Budget has its own budget, expenses, encumbered, cash balance, and available balance.
Then each Project may or may not have many Contracts and each will have its own budget, expense, etc. and then a vendor, PO #.
This is what an Excel spreadsheet looks like:
I'd love to have it match, but I know having the currency fields like this isn't possible.
------------------------------
Bethany Hudson
------------------------------