Hi i need help with comparing lists

Jaydengotham.G.E · 2025-01-08T10:39:53.296Z

i need some help with this how come this is not working
so i have 2 lists and i want to to be if one list does not contain the numbers from the other list then change the colour of the button

Screenshot 2024-12-20 13.45.11504×645 37.5 KB

geesonofgee · 2025-01-08T12:24:57.680Z

how did you structure your DB? can you screenshot the two things you’re trying to compare in the DB

Jaydengotham.G.E · 2025-01-21T09:41:15.813Z

these are the 2 DB that i’m trying to compare

Screenshot 2025-01-21 09.36.551837×908 107 KB

Screenshot 2025-01-21 09.37.261837×908 93.8 KB

so i’m trying to do it so if i call out the numbers
1
2
3
4
5
and the user has the numbers that has been called out it can be
1
2
3
4
or
1
2
3
it will change the box to green
but if they have a number that isnt in that list like
1
2
3
4
7
it will change the box red

geesonofgee · 2025-01-21T09:56:13.010Z

Instead of using the “contains” command, try using “is” if that available for you, that should work I think, so u’ll have something like:
Current cell’s submissions’s bingoo is in search for dot parties lives

Jaydengotham.G.E · 2025-01-21T10:27:00.407Z

it doesn’t let me use any of those commands

Screenshot 2025-01-21 10.25.52402×510 21.6 KB

ahmed.elkaffas · 2025-01-21T12:40:08.606Z

You are comparing a list of numbers with a list of texts. Right ?
These are 2 different data types.

Jaydengotham.G.E · 2025-01-21T12:50:58.098Z

no sorry i just realise that i have change it to comparing 2 lists of numbers and it still isnt working

ahmed.elkaffas · 2025-01-21T13:15:46.096Z

In this case, I believe you need to use an expression like the one below:
Search for Dot Parties Live:first item’s previous numbers: minus list Current Cell’s Submission’s bingoo:converted to number:count < 1

This means that you are checking out if the full list stored in your “previous numbers” field when you subtract from it all the items stored in your “bingoo” field after converting it to numbers instead of text, then the difference will be < 1 (i.e. the whole “previous numbers” list is included in the “bingoo” list).

Does this solve your problem ?

Jaydengotham.G.E · 2025-01-21T13:36:29.991Z

it doesnt let me use the :converted to numbers

Screenshot 2025-01-21 13.35.38377×340 21 KB

Jaydengotham.G.E · 2025-01-21T13:38:27.534Z

no sorry i just realise that i have change it to comparing 2 lists of numbers and it still isnt working both lists are now numbers

ahmed.elkaffas · 2025-01-21T13:38:55.314Z

Jaydengotham.G.E:

comparing

If both lists are numbers, then you needn’t the “converted to number” operator.

Your expression should be:
Search for Dot Parties Live:first item’s previous numbers: minus list Current Cell’s Submission’s bingoo:count < 1

Jaydengotham.G.E · 2025-01-21T13:59:56.686Z

it works ish
so what is happing is say i have
1
2
3
in one list
1
2
3
or
1
2
3
4
in the other list it works
but it need to be that it show change to green if the numbers in the bingo list are in the past numbers list as there will be more numbers in the past number list
so in the past number list there is
1
2
3
4
5
6
but in the bingo list there is
1
2
3
it should work as
1 2 3 and in the past number list

Jaydengotham.G.E · 2025-01-21T14:10:28.881Z

if that makes sense

ahmed.elkaffas · 2025-01-21T14:27:55.317Z

I believe you want here to know when a user won in the “bingo” game based on the numbers stored in the “previous numbers” field.
In this case, most probably the winner will have less list of numbers than the list of numbers in the “previous numbers” field unless this is a very lucky user whose numbers were displayed sequentially which is a very rare case !

So in this case and since you are using 2 lists of numbers to compare, then your expression might look like follows:
Current Cell’s Submission’s bingoo contains list Search for Dot Parties Live:first item’s previous numbers

This expression should return “yes” if the Bingoo list contains all the numbers in the “previous numbers” list of numbers

Does this solve your problem ?

Jaydengotham.G.E · 2025-01-21T14:54:04.322Z

yes it works thanks you so much