I don’t know anymore what formula to use to get this to work. What I want is from a list() group - the list() column will return the remainder of the right-hand side list.
it doesn’t work like this photo I’m showing,
can someone help me???
Original post:
[How to filter selection according to criteria](https://community.appsheet.com/t/how-to-filter-selection-according-to-criteria/56394) Questions
"I have a transaction form like the following, The problem is I only want to display the months that have not been paid, currently it still displays the entire month selection And in the form that currently exists, I only managed to give a valid error if the month period has been paid” [Presentation1]
For reference:
Please post a screenshot of the complete expression you’re using.
Yes, I have used test…
but the results are not as expected.
for with one item, like screenshot “Jan” can work, but with reduction Jan,Feb,Mar
Reduction doesn’t work
Wrap your SELECT() expression with CONCATENATE() and SPLIT():
SPLIT(CONCATENATE(SELECT(...)), " , ")
See also:
Please post your [Pembayaran Bulan] config.
Like this:
Seems like you were playing with the Item separator. By default it is " , ". Leave it as default
1 Like
Good point!
it works @Steve…
thank you,
I had thought about using split, but was confused about how to combine it.
1 Like
SkrOYC:
Seems like you were playing with the Item separator. By default it is
" , ". Leave it as default
Could you check this anyway? Just to make sure we are not fixing a problem made initialy by changing the Item separator so that others could avoid it in the future
1 Like
Thanks.
Seems like Item separator is "," instead of " , "
1 Like