reports not pulling required information

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
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?
Photo of John

John

  • 50 Points

Posted 2 years ago

  • 0
  • 1
Photo of John

John

  • 50 Points
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
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,";"))
)