Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
5 years ago

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

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
------------------------------
Relationships

8 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years 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
    ------------------------------
    • MattMakris's avatar
      MattMakris
      Qrew Assistant Captain
      5 years ago
      I have, but it won't display in Grid Edit mode for some reason.


      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years 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
        ------------------------------