Maximum Number of "Field Lookup"s Limit?

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
What is the maximum number of New Lookup Fields I can add to a Table?

I have over sixty types of jobs I would like to track; therefore, I would like to add over sixty Lookup Fields to my Activities Table from my Projects Table. I wanted to make sure I can add that many before I put in all the effort since I can only add three at a time. 

Thanks!
Photo of Britney Menconi

Britney Menconi

  • 100 Points 100 badge 2x thumb
  • a little weary

Posted 6 months ago

  • 0
  • 1
Photo of Gil Spigelman

Gil Spigelman

  • 870 Points 500 badge 2x thumb
Hi Britney,
No limit that I know of. I have a table with well over 200 lookup fields.
Photo of Britney Menconi

Britney Menconi

  • 100 Points 100 badge 2x thumb
Excellent! Muahahaha!

I sincerely thank you for your quick response. Now if only I could add more than three at a time...
Photo of Gil Spigelman

Gil Spigelman

  • 870 Points 500 badge 2x thumb
That's the annoying part.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
There is no limit to the number of lookup fields.  But from your description, I cannot understand why you need 60 lookup fields.  It might be worth explaining the business purpose of what you are doing just to cross check that there is not a better approach.
Photo of Britney Menconi

Britney Menconi

  • 100 Points 100 badge 2x thumb
There are this many types of inspections that we track, each having its own process flow and requirements. Each project can have anywhere from one to about thirty different types of required inspections. So there will be some Form Rules sprinkled in as well so users don't have to see all 60 types on every project.
(Edited)