Skip to main content
Question

Max fields per table?

  • June 6, 2019
  • 0 replies
  • 113 views
Forum|alt.badge.img+11
I am working on a project management tool that stores projects, notes, sales data, and survey data.

The survey data can be a lot of fields when we survey. To me I would think it should be isolated from the other data as it is of a completely different type.  i am not tracking addresses and sales data but now engineering data.

Do I create a one to one relationship in a new table? can quick base support that? Or am I overthinking and just load the table up with fields and use tabs to keep my forms in order?

    Can you provide more detail? It sounds to me though that you will definitely want to use relationships.

    For example

    One Project has Many Project Notes.

    I would need to hav3 a better description if the Survey to suggest an approach there. How many Questions? How many Surveys per project.
    I do not recommend hard coding 30 to 50 fields on the project record for the survey questions.  You should have a model project(s) with a child table of Standard Survey Questions.

    Then use the Copy Master Detail wizard function in App management to create a button which will copy those questions into your Project.

    I don't have time right now to go into a lot of detail, but I will come back to this question when I have time.

    Here is some help on that.

    https://help.quickbase.com/user-assistance/copy_master_detail.html

    feel free to post back if you have questions.


    Terms & ConditionsAccessibility statement