Get Selected Value or Row from Pop-up Control

Comments

4 comments

  • Avatar
    Nik

    I believe for us we just needed to exactly match the field names in the pop up look up to field names on the form we wanted to output to. We are using SQL lookup instead of REST for this but I assume should be the same.

     

    No documentation states that, needed help from consultant.

     

     

    Edit: We needed to populate about 40 fields, but only wanted a handful of fields in the pop up select. So we then have an auto lookup trigger on an ID field from the pop up select so that the rest of the form fields populate and it keeps the pop up select manageable for the user. 

  • Avatar
    Hong Nguyen

    Hi Nik

       Thanks for replying!   I am not sure what you mean when "match"?

    Are you referring to the "Map Schema" section?

  • Avatar
    Nik

    Ah, there is a difference for SQL lookups - we have to alias each field to be the same field name as the field on the form we want it to write to.

     

  • Avatar
    Hong Nguyen

    Hey Nik

      No problem.  I was able to get something to work but it is not ideal.  In the "map schema" section, I chose "Multiple Columns" option.  Then I am able to map the REST fields to a sub-form fields.  This does get the value selected from the user, but the popup control shows two separate pagination sections which is not ideal:

     

     

    I will see if there is a better way to do this.  I'm sure this scenario has been done before.  It seems to common of a situation.

Please sign in to leave a comment.