AnsweredAssumed Answered

Get originating field

Question asked by christianmarin on Nov 10, 2016
Latest reply on Nov 21, 2016 by emha

Good day to all!

 

Say you have a list with 18 fields.  These fields contain values that are associated by name in six groups of three.  Example: 

Project 1         Task 1           Subtask 1         Project 2        Task 2        Subtask 2         Project 3     Task3......

 

 

The goal is to query any given row for the value of a defined variable and return which field it was found in. 

Example:

 

Project 1         Task 1           Subtask 1         Project 2        Task 2        Subtask 2         Project 3     Task3......

   One               Green              Cotton               Two             Blue               Wool              Three         Red

 

 

If we query the current item for a variable with value  "Two," then we know that it came from Project 2.  Ultimately we would use this as a "key" of sorts to then bring the associated Task and Subtask with it.

 

 

Any thoughts on this would be appreciated.  Thanks in advance to the community.

Outcomes