Discussions

 View Only
  • 1.  Check to see if a value in one list, is contained in another list

    Posted 09-09-2020 20:15
    How would I search through one list and see if any of those values are contained in another list?

    Then return it as a formula checkbox, or formula text, the output doesn't matter I can deal with that. Just not how to approach this.

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Check to see if a value in one list, is contained in another list

    Posted 09-09-2020 20:20
    so two field son the same record.

    like

    cats;dogs;parrots

    and the other list is
    fish;hamster;cats

    so that would be TRUE because they both contain cats?


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Check to see if a value in one list, is contained in another list

    Posted 09-09-2020 20:24
    Correct. It's TRUE if ANY of the words in list 1, is contained in list 2.

    In my case it's two lists of dates.

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 4.  RE: Check to see if a value in one list, is contained in another list

    Posted 09-09-2020 20:25
    Edited by Michael Tamoush 09-09-2020 20:33
    Bonus points if you can return every duplicate in a text list. So instead of returning true, return a list of each item in list 1 that is contained in list 2.

    My gut says I need to use the Part function and just manually create a formula with the max number of items I believe will be in list 1.
    ------------------------------
    Mike Tamoush
    ------------------------------



  • 5.  RE: Check to see if a value in one list, is contained in another list

    Posted 09-12-2020 08:35
    Mike
    Here is an example using Multi select fields for the input and output. The result will be a multi select apparance with the unique values.

    var text ListOne = ToText([List 1]);
    var text ListTwo = ToText([List 2]);

    var text A = Trim(Part($ListOne,1,";"));
    var text B = Trim(Part($ListOne,2,";"));
    var text C = Trim(Part($ListOne,3,";"));
    var text D = Trim(Part($ListOne,4,";"));
    var text E = Trim(Part($ListOne,5,";"));


    Split(List(";",
    If(Contains($ListTwo,$A), $A),
    If(Contains($ListTwo,$B), $B),
    If(Contains($ListTwo,$C), $C),
    If(Contains($ListTwo,$D), $D),
    If(Contains($ListTwo,$E), $E)))


    .........

     and here is the count of the # of common terms

    var text String = ToText([List 2 in List 1]);

    Count(
    Trim(Part($String,1, ";"))<>"",
    Trim(Part($String,2, ";"))<>"",
    Trim(Part($String,3, ";"))<>"",
    Trim(Part($String,4, ";"))<>"",
    Trim(Part($String,5, ";"))<>"")



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------