0

Dynamic Multiple and Choice fields help

I need to set up a commission check list system for equipment and it seems to me the best way to do this is with Dynamic type choice fields.  To give an example:

I have an Item in my Inventory table eg:  A TV

Various tests are required during commission phase.  For example:

Under Equipment Tests there could be:
Is it level Y/N
Is the bracket secure Y/N

Under Video Tests we could have:
Display Image Y/N
HDMI  Input Y/N

Under Audio Tests we could have:
Speakers L/R Phase Y/N
Microphones Level Set Y/N

And so on.

In my Inventory Table I would then pick the various Tests that apply.  So a Microphone would not require an Equipment Check for example but it would need the Microphone Level in the Audio Test group.

I would welcome any advice, ideas, suggestions on how best to set up the table structure in terms of relationships.

My thinking so far is:

Parent = Inventory (TV, Microphone...)
    Child = Test Type (Equipment, Video, Audio....)
        Child = Test For (SPK Phase, Mic Level.....)

A screenshot of a paper version:
 


Apologies for wordy post :-(

5 replies

null
    • Alan_Cooke
    • 2 yrs ago
    • Reported - view

    I already have the Inventory Table

    • Cloud DevOps Fullstack Engineer
    • Martin_Mueller
    • 2 yrs ago
    • Reported - view

    I don't think you need a second child layer "Test For (SPK ... " The Test data can be part of the first child layer. I think I would have one parent table Inventory and child tables for the concrete Type Tables Equipment, Video, Audio . And those Type Tables do have the test data as well.

      • Alan_Cooke
      • 2 yrs ago
      • Reported - view

      Martin Mueller Thanks - what I should have mentioned is the 3rd and 4th column in the screen shot.  How would I drill down for them?

      For example there is:

      Video > Display image > clear
                                               > resolution

      Occurs to me that Video is one of many choices with Display Iamge one of Many (HDMI input etc) which has Clear and Desired Resolution as well.

    • Fred
    • 2 yrs ago
    • Reported - view

    Here is one possibility for a solution.

    To add tests you click on the Add Tests button and then select the tests according to test category.

    Let me know if you have any questions.

      • Alan_Cooke
      • 2 yrs ago
      • Reported - view

      Fred Thanks for this Fred, much appreciated.  I am playing around with it now.

Content aside

  • 2 yrs agoLast active
  • 5Replies
  • 111Views
  • 3 Following