Production list has columns 'Heat Number' and 'Campaign'.
A Campaign may appear in the Production list several times (see 318
in the attachment below).
I have the following lookup in the default of TextInput1. It is returning
one Heat Number, rather than ALL Heat Numbers associated with the
Campaign number chose (318).
In my example TextInput1 ('Heat Number') should contain '4828, 4829,
4830 and 4831'.
How do I update my lookup so that it pulls in all relevant 'Heat Numbers'?
I've tried both of the following. Each returns a single Heat Number -
Lookup() by definition only returns the first item that meets the criteria in the lookup. If you want multiple items then you need to use Filter, not Lookup. You want something like this to return a string of all the Heat_Numbers in a single Campaign as a comma delimited string. I'm assuming Title is the field that has been renamed to hold the Heat_Numbers.
----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!
Paul Papanek Stork, MVP Blog: https://www.dontpapanic.com/blog
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
4,884
All responses (
Answers (
