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

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • In Progress
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.
Photo of Joshua Hamilton

Joshua Hamilton

  • 110 Points 100 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Can you clarify the business case for this? What's your intent?
Photo of Joshua Hamilton

Joshua Hamilton

  • 110 Points 100 badge 2x thumb
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.
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.