Discussions

Expand all | Collapse all

Copy and Pasting lookup field's results into another field but retain ability to change the lookup field

  • 1.  Copy and Pasting lookup field's results into another field but retain ability to change the lookup field

    Posted 01-17-2018 04:39
    I need to copy certain results that show when a selection is made in a lookup field, paste those results into another field on the form and then have the ability to select another result in the lookup field without changing the data in the paste field. Basically give the ability to choose two results from one lookup field.


  • 2.  RE: Copy and Pasting lookup field's results into another field but retain ability to change the lookup field

    Posted 01-17-2018 20:49
    Can you clarify the business case for this? What's your intent?


  • 3.  RE: Copy and Pasting lookup field's results into another field but retain ability to change the lookup field

    Posted 01-18-2018 00:13
    So the user makes a selection in the lookup field (item 1.1, item 1.2, item 1.3) and that pulls that items description and cost onto the form. I want to cheat a little and give them a kind of ability to choose multiple choices from the lookup field by clicking a checkbox or something that would copy the current data from the lookup field and paste it into another set of fields and then allow them to make another selection in the lookup field and the 'paste fields' keep the data from the first choice.


  • 4.  RE: Copy and Pasting lookup field's results into another field but retain ability to change the lookup field

    Posted 01-18-2018 05:07
    If you're doing something with Items / Cost, I would encourage you to do a proper Parent/Child relationship where the user would build multiple line items. Each line item (similar to how an invoice or receipt looks) would have a single product and description. You could still set it up so that the description is copied over to an editable field so the user can then manipulate the description as needed.