Forum Discussion
JeffPatrick1
3 years agoQrew Member
Hi Mark - Tag List and Tag ID List are text fields on a single record. Search in this case means look (only) at the Tag List text field, find the position of a particular Tag in the list, and then find the corresponding position in the Tag ID List. So, everything is happening on a single record.
------------------------------
Jeff Patrick
------------------------------
------------------------------
Jeff Patrick
------------------------------
JeffPatrick1
3 years agoQrew Member
I know I can use Part() function to pull in the Tag ID from the Tag ID List field but I can't figure out how to get the Tag List item # (i.e. not the character position in the text string but rather the nth item on the Text List).​
So, here is the example:
Tag List
Sample data tag1,tag2,tag3
Tag ID List
Sample data 10,14,18
Is there a function to look at Tag List and find "Tag2" and return Position 2 in the list.
Then, I can use the function: Part([Tag List],2,",") to produce "14" - the second item on the Tag ID list.
------------------------------
Jeff Patrick
------------------------------
So, here is the example:
Tag List
Sample data tag1,tag2,tag3
Tag ID List
Sample data 10,14,18
Is there a function to look at Tag List and find "Tag2" and return Position 2 in the list.
Then, I can use the function: Part([Tag List],2,",") to produce "14" - the second item on the Tag ID list.
------------------------------
Jeff Patrick
------------------------------
- MarkShnier__You3 years ago
Qrew Legend
try this
var text TagOne = Trim(Part([Tag List],1, ","));
var text TagTwo = Trim(Part([Tag List],2, ","));
etc
var text TagNine= Trim(Part([Tag List],9, ","));
var number Position = IF(
Trim([Search Term])= $TagOne, 1,
Trim([Search Term])= $TagTwo, 2,
etc
Trim([Search Term])= $TagNine, 9))
Part([Tag IDs], $Position, ",")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------