Big Tables - Lookup 100 rows limit 🤯

Ask for Help
1

Hi

I have a Query from a Glide Table to a Glide Big Table which returns over 100 rows.

All good, but I need to lookup the row IDs from the results - but of course I only get the first 100 - which is no good for me.

Is there a work around?

Andrew

2

May have answered my own question.

Is it to use a Joined List to do the lookup, then split text if necessary?

3

Do you mean using Joined List through the query? Or just a joined list of all IDs and then calculate only the relevant IDs somehow?

4

Oh

Use a joined list through the query then split text it.