Translate combined-text (summary) into multiple-choice field
Background
One project has many order lines, or items on the estimate. We often will label multiple order line items with a "group" name for custom sorting and displaying. The [Group] field is just a text field, so it can contain whatever the user wants to call the group. The project has a combined text field summarizing/listing the different groups the user has entered on the order lines.
Scenario
I want the user to be able to select one of those group names in order to generate a PDF estimate with only the order lines with that group name. (Never mind the PDF logistics; we have that under control) I thought it would make sense to have a multiple-choice field that populates with the text that's combined in that summary field.
What I expect, and maybe what I need instead
Something like "Input type: From another field" and then you would select the combined-text field. But that's not an option. Is there a workaround? Perhaps an interim format (some kind of text field?) that could be used as the source of the multiple-choice entries?
Many thanks!
------------------------------
Ryan Farrington
Graphic designer, project manager, copywriter, engraver, internal Quick Base developer
rfarrington@experiencepinpoint.com
------------------------------
One project has many order lines, or items on the estimate. We often will label multiple order line items with a "group" name for custom sorting and displaying. The [Group] field is just a text field, so it can contain whatever the user wants to call the group. The project has a combined text field summarizing/listing the different groups the user has entered on the order lines.
Scenario
I want the user to be able to select one of those group names in order to generate a PDF estimate with only the order lines with that group name. (Never mind the PDF logistics; we have that under control) I thought it would make sense to have a multiple-choice field that populates with the text that's combined in that summary field.
What I expect, and maybe what I need instead
Something like "Input type: From another field" and then you would select the combined-text field. But that's not an option. Is there a workaround? Perhaps an interim format (some kind of text field?) that could be used as the source of the multiple-choice entries?
Many thanks!
------------------------------
Ryan Farrington
Graphic designer, project manager, copywriter, engraver, internal Quick Base developer
rfarrington@experiencepinpoint.com
------------------------------
