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
how did you structure your DB? can you screenshot the two things you’re trying to compare in the DB
these are the 2 DB that i’m trying to compare
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
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
You are comparing a list of numbers with a list of texts. Right ?
These are 2 different data types.
no sorry i just realise that i have change it to comparing 2 lists of numbers and it still isnt working
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 ?
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
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
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
if that makes sense
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 ?
yes it works thanks you so much