Forum Discussion

JoshuaHamilton's avatar
JoshuaHamilton
Qrew Trainee
8 years ago

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

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.
    • JoshuaHamilton's avatar
      JoshuaHamilton
      Qrew Trainee
      8 years ago
      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.
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      8 years ago
      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.