Discussions

Expand all | Collapse all

How to display related field value from a grid edit dropdown selector (rather than record id#)

  • 1.  How to display related field value from a grid edit dropdown selector (rather than record id#)

    Posted 16 days ago
    I have a grid edit table report that requires the user to select the "Related Content Allocation" before editing the rest of the columns/fields. However, the dropdown is displaying the related field's record ID, which isn't very user-friendly. Is there a way to display other related field values in this dropdown rather than the record ID# easily?



    ------------------------------
    Matt Makris
    ------------------------------


  • 2.  RE: How to display related field value from a grid edit dropdown selector (rather than record id#)

    Posted 16 days ago
    Have you set a Proxy field for that related Content Allocation field and included it on the grid edit report?  Edit the field properties and set a proxy field from one of the lookup fields.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: How to display related field value from a grid edit dropdown selector (rather than record id#)

    Posted 16 days ago
    I have, but it won't display in Grid Edit mode for some reason.





  • 4.  RE: How to display related field value from a grid edit dropdown selector (rather than record id#)

    Posted 16 days ago
    Is the first column of the Record Picker in Advanced settings for the table set to something useful and not Record ID#

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: How to display related field value from a grid edit dropdown selector (rather than record id#)

    Posted 16 days ago
    Yes, it is set to a non-record ID # field.





  • 6.  RE: How to display related field value from a grid edit dropdown selector (rather than record id#)

    Posted 16 days ago
    .. sorry, I'm out of ideas ......

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: How to display related field value from a grid edit dropdown selector (rather than record id#)

    Posted 16 days ago
    Maybe Quick Base doesn't allow proxy field values while in Grid Edit mode? ��‍♂️