Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

Conditional Drop Down in Grid Edit based on a lookup field

I would like to set up a conditional drop-down for data entry in an embedded grid edit report while sitting on a parent record in edit mode. The conditional drop-down will depend on a value which is l...
Grid edit
efvrvo's avatar
efvrvo
Qrew Member
3 months ago

A bit late but thought its worth sharing for others in the future.

The conditional dropdown list will work in legacy forms with a grid edit table in edit mode with a lookup condition if the condition that is also the proxy field. The proxy field is prefilled in the grid edit tables in the legacy forms like the master related field.

Tested it on my side and worked. The only down side is that my proxy field is now taken.

  • jross's avatar
    jross
    Qrew Cadet
    3 months ago

    Hey Efvrno,

    It's crazy that you just made this post as this is a problem that my current company has going on right now.  I built out your idea in a test environment but the proxy field does not pre-fill in the form like the related field does.  Is there any other trick to this?

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 months ago

      .. are you in Legacy Forms?  This only works in Legacy forms at present, not New Forms.

      • jross's avatar
        jross
        Qrew Cadet
        3 months ago

        Hey Mark!  Oh yes, I am ALWAYS in legacy forms.  haha  (New forms are still too slow and clunky for me but that is a separate topic)

         

        To be clear, the proxy field does fill, but just with the RID/Key of the parent.  Once the record it saved, it then switches to the value of the field I selected.