How do I track different attributes for different record types?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have to think this is a common thing, but I'm having trouble finding an answer.  If there is one out there please link me!  

I'm building an application that tracks vendors, the products/services they offer, and attributes about that service.  I have my vendors table and my products table and I have linked them up just fine.  

My problem is that I need to track different attributes for different products.  All products have certain attributes, like support contact name, version number, etc..., but Product A may be of a certain type where attributes 1, 2, 3 need to be tracked and Product B may be of another type all together where attributes 1, 2, 3 don't make any sense, but attributes 4, 5, 6 do.  And to make matters worse, attributes 1, 2, & 5 may be simple checkboxes, but 3 and 4 are single-selection drop down choices and 6 is a free-text field.  

Photo of Eric


  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Few questions;
- Is it possible to just leave that information blank?
- Is the "product type" a multiple choice field or a relationship?
- Do you have some examples of your attributes?
- What is the end goal of having some 'apply' and others 'not'?
     -- Is this for form rules, or do you just want to keep things simple for the end user?

Photo of Eric


  • 0 Points
Thanks for the reply.  To answer your questions:
- yes, if I'm understanding the question correctly
- product type is a multiple choice field
- (both of the last questions) - as an example if you sell cars & trucks, a checkbox for whether the vehicle has a hatchback is irrelevant to a truck, and bed size is irrelevant to a car.  Yeah, I guess it's mostly about making it easy to use and not allowing users to enter non-valid info.

But I found a solution and I'll post it here in case it helps someone else.  

I added all attributes for all product types into my product table.  In the form, I divided the attributes up into sections by product type and I added a set of "Dynamic Form Rules".  One rule for each type so that it only shows the section if the corresponding type is selected.  It seems to work so far.