Forum Discussion

JeffPatrick1's avatar
JeffPatrick1
Qrew Member
3 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
3 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
3 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
------------------------------