I have a bot that sends an email which is based on a template. Recently the table has been limited to returning no more than 20 rows of information. If one of my tables has 20 lines it stops and if I have 3 tables that combined equal 20 lines it stops as well. Any idea what is limiting the table?
Would you please take a printscreen from your template first, thanks.
You can see where it got to a point and then just stopped. There are about 10 more lines that should be included
Would you please take a printscreen from the template that generates this pdf.
Yeap, thanks. Has this ever worked properly? By any chance do you have a slice or security filter that is filtering the data and then those rows don’t show up in your report?
I dont have a filter this is based on. It works perfectly if there is less than 21 rows total. it seems like its being limited in appsheet or google sheets. If you look at the first picture you see the 21st row has just the name and it stops after that
Have you checked that you don’t have any rows with duplicate key values?
Yes I have, no duplicates
What happens if you write the formula something like <<START: TOP(Table[KeyColumn],30)>> but of course using your own names?
Finally figured it out. The table was being clipped by the email, at the bottom you just click view entire message and the rest is there.