Forum Discussion

JohnJohn2's avatar
JohnJohn2
Qrew Trainee
9 years ago

reports not pulling required information

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?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    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,";"))
    )