Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
5 years ago

Multi Select Field Populated from Another Field Question

I have a two table application where I am getting training feedback.  On the Training Results form I have a Multiple Choice field with "From another field" selected called "Classes" that is being populated from the "Classes" table.  This is where I enter the class names and they show on the Training Results form.  The question I have is it possible to control the order in which the classes are displayed in the Classes field and still enter the classes in the Classes table as individual records?  I have added a "Sort" field and sorted the "List All" report by that field, but I don't know how to make the "Classes" field display like the sorted report.

Thanks for the help!
Brian

------------------------------
Brian Brian
------------------------------
Relationships
Tables and fields
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    You're not going to be able to sort them with the way that you currently have this setup. The only way you would be able to sort them is if you have a relationship between the Classes and Feedback tables, where Classes is the Parent. I would then suggest using the Name or Date or some combination of those as the Proxy for the relationship so that this would then be the drop-down you would use, instead of a Multiple-Choice field.

    Once you have this setup, you can change how the drop-down works in the Elements properties on the form editor and select the report you would like to base the drop-down on. The drop-down would then use any sorting / filtering settings you've setup for the presentation of the choices in the drop-down.

    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------