Quick Base Discussions

Expand all | Collapse all

reports not pulling required information

  • 1.  reports not pulling required information

    Posted 03-27-2017 16:18
    Our company bids construction projects to multiple Contractors at a time. I've set up our bid table to link to the company table and can select multiple companies for each bid created. When I do this, the actual bid shows all that we bid to but the company itself does not show it. This is skewing out metrics quite a bit. Anyone know how to fix this?


  • 2.  RE: reports not pulling required information

    Posted 03-27-2017 16:18


  • 3.  RE: reports not pulling required information

    Posted 03-27-2017 16:29
    When you use a multi select field like there are limitations and benefits compared to having a "proper" child table for bidder companies.

    But here is a formula to count the number of bidders in that multi select field.

    var text $value = ToText([Bid To]);

    Count(
    Trim(Part($value,1,";")),
    Trim(Part($value,2,";")),
    Trim(Part($value,3,";")),
    Trim(Part($value,4,";")),
    Trim(Part($value,5,";")),
    Trim(Part($value,6,";")),
    Trim(Part($value,7,";")),
    Trim(Part($value,8,";")),
    Trim(Part($value,9,";")),
    Trim(Part($value,10,";")),
    Trim(Part($value,11,";")),
    Trim(Part($value,12,";")),
    Trim(Part($value,13,";")),
    Trim(Part($value,14,";")),
    Trim(Part($value,15,";")),
    Trim(Part($value,16,";")),
    Trim(Part($value,17,";")),
    Trim(Part($value,18,";")),
    Trim(Part($value,19,";")),
    Trim(Part($value,20,";"))
    )