Forum Discussion

JeffPatrick1's avatar
JeffPatrick1
Qrew Member
4 years ago

Two Text List Fields - Find value in one and corresponding value in the other Text List

Hi - I have two Text List fields in a table representing tags and their tag id's: Tag List Here is sample data             tag1,tag2, tag3 Tag ID List Here is sample data              8,10,14...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Can you explain the structure of your app so far with respect to these tag names and tag numbers?  

For example is this
 tag1,tag2, tag3

On a record in a long text field or is that multiple records.

When you say "search",  are we just searching the data on one record or on many records?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
JeffPatrick1's avatar
JeffPatrick1
Qrew Member
4 years ago
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
------------------------------
  • JeffPatrick1's avatar
    JeffPatrick1
    Qrew Member
    4 years ago
    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      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
      ------------------------------