Skip to main content
Question

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

  • October 17, 2022
  • 0 replies
  • 203 views

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

There are three tags (tag1,tag2,tag3) and their Tag IDs are 8,10, and 14

I want to search Tag List to find a specific tag, and return the corresponding Tag ID for that Tag.

Is there any way to do this in a formula field?

Thanks

Jeff



------------------------------
Jeff Patrick
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • October 17, 2022
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
------------------------------