I have a repeating group and its one cell pulls data from a list.
I have set my repeating group source constraint to " isn’t empty"
It still shows the row from the table which has this field empty.
Even tried applying filtered to the data source, get the same above option, but it does not work.
Any suggestions how to ignore rows showing into a repeating group where a the data row has a field(of type list) which is empty?
Thank you
Can you post screenshots of the sources and filters you’re using? It’s likely some detail that’s causing this.
One thing you might try is instead of filtering by if the list is empty, is filter by if list:count is 0.
Can you please try “ignore empty constraints”. And as @johndurso share screenshots with more details
I resolved this by adding NA to the field which was left blank.
Then in RG code put a constraint to show only items with not NA.
Tried ignore empty constraints - Did not work. (Looks like a bug for list constraints)
Could not find option for list:count is 0.
Thank you both for your suggestions @johndurso / @kazimdgoni
I wouldn’t call that a solution so much as a workaround. If you want to post screenshots of what you were doing that wasn’t work I’d be happy to take a look, but if you’re happy with the workaround that’s cool too.
Here you go @johndurso
A search for a thing.
Constraint on a field(of type list) which isn’t empty
Also ignore empty constraints.
Both above did not work and still displayed the row in the repeating group output where the field RepOfBlock was blank.
Ah, I see why you didn’t have the count. So your intention is that if the Committee’s Rep-Of-Block list has no items, then you don’t want the Committee to show in the RG at all, right?
In that case the count method would work but you have to use an advanced filter after the search, for example:
I seem to remember the reason your method doesn’t work because technically the Rep-of-Block field isn’t empty because it has a list in it. So even if each item in the list is empty, or if the list contains no items, the list still exists and so the field is not empty. I could be wrong on those details though.
Edit: Oh and be careful with the use of Advanced filters; if you’re running this on a lot of data it could slow things down. Just something to keep an eye on and weigh in your solution.
I agree and would not prefer using Advanced filter, it indeed slows down the page.
Hence used the workaround.
In debugger the “is empty” is a yes. That means bubble does recognize its empty but still the constraint does not work!
Yes that is strange - just came back here to say your original method is working for me when I set up a test of it, so not sure why it wouldn’t be working for you.
You probably already tried this but what happens when you unclick “Ignore empty constraints”?
Tried Ignore empty constraints, still no joy.
Also simulating your screenshot for advanced filter, i do not get an option for “List of RepOfBlock”
Can you show me what your Committee datatable looks like?
Also, you wouldn’t see “list of Rep-Of-Block”, it would be
Committee's Rep-Of-Blocks:count is not 0
In my example “List of texts” is the name of the field, sorry that was confusing.
The count parameter works in filtered. Thanks.
But I used that just for testing!
Below is the table structure for Committee
I can’t see why there’s an issue, perhaps it’s time to file a bug report with Bubble.
This topic was automatically closed after 70 days. New replies are no longer allowed.
