Discussions

 View Only
  • 1.  Embed a Report into Another Report's Field

    Posted 02-07-2023 17:34
    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='" & [Record ID#] & "'" &
    ">+</span>"​

    I'm having trouble with the formula field:
    (function(){
     $("img[qbu=modulecontracts]").remove();
      var dbid = "bqij8g449";
      var dbid GrantBudgets = "bqrnue9x7";
      var rid= "85";
      var apptoken = "b4bgu9_mk8a_0_dut3hpibru9pbtq884vsd7djvmt";
      var querystring=document.location.search;
     $(".QBU_ToggleChildren").on("click", function() {
          if ($(this).text() == "+") {
            $(this).text("-");
          } else {
            $(this).text("+");
          }
          var rid = this.dataset.rid;
          $("#child_rid_" + rid).toggle();
        });  })​

    I need help!


    ------------------------------
    Bethany Hudson
    ------------------------------


  • 2.  RE: Embed a Report into Another Report's Field

    Posted 02-07-2023 17:58
    So "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
    ------------------------------



  • 3.  RE: Embed a Report into Another Report's Field

    Posted 02-08-2023 09:14
    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
    ------------------------------



  • 4.  RE: Embed a Report into Another Report's Field

    Posted 02-08-2023 10:09
    I'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
    ------------------------------



  • 5.  RE: Embed a Report into Another Report's Field

    Posted 02-08-2023 11:27
    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
    ------------------------------