First time reporting a bug? Refer to our Start Here post.
Team ID: OeMY6oXk0zp8Idl8i4yg
App ID: gpwADN2NxeHrMxPSovlh
Description
Somehow is not showing the correct data from its own table. I thought this might be a cache/cookies issue so i cleared, did it in a different browser, etc. but it persists for a while. Then it goes back to working? it’s gone back and forth once this morning, and we are having the same problem in other flows as well. I haven’t changed anything this morning, and it shouldn’t be a sync issue because the content in the “:booleans and selections” sheet hasn’t changed in about a month
How to replicate
view recording at incomplete data from own table
- from home screen, “make a non-event related request” > “Submit Meeting Minutes” > “Open new request”
- choice item does not appear because there are no options that meet filter criteria, despite such options existing in the “booleans and selections” table under the data tab. Looking at data view on the bottom and/or manipulating the filter to display all options reveals that only rows 1 - 10 of “booleans and selections” are populating
- Now that i have successfully captured this bug in a recording, that flow works, but “submit Reimbursement” doesn’t
I suspect your filter has a trailing space.
it doesn’t i already checked that! That also doesn’t have anything to do with the missing rows past 10
I duplicated the table that it wasn’t pulling all the rows from and remapped the question. Below, you can see that despite the copied table having multiple rows, only a selection appear even with no filter. There’s also no row owner applied on that table so it’s not an issue of visibility. There really doesn’t seem to be much rhyme or reason here.
I’ve tried to put together the bits and pieces I could get out of your video and screenshots, but nothing is jumping out to me as being incorrect…but I do have to ask why your original filter used ‘Includes’ instead of ‘Is’ if you are looking for an exact matching value for your filter.
If anything, you may want to copy the value from the google sheet and apply it to your filter instead of typing it in. I have to wonder if maybe there is a hidden character or a different type of space character in the table vs what you are typing into the filter.
2 Likes
How many total rows do you have in the App? (check your Usage dashboard)
1 Like
25,622 rows - maybe that’s the issue? We have a paid Maker account. It appears to be pulling 10 rows at random, which I noticed is the default number for “limit items” though we don’t have the limitation selected.
it originally did use “is”, I changed it to “includes” when i was experimenting with trying a substring match to avoid invisible characters preventing an exact match. that obviously didn’t pan out but i didn’t think to revert it before recording, i will try to remember to next time.
1 Like
Yes, that’s almost certainly the issue. The limit is 25k rows per App, and that is enforced.
You may want to consider moving some of your data to Big Tables, or remove/archive some data.
3 Likes
