SELECT() inside email via template (google doc)

General
1

I have a bot that trigger one time a week that send via email a list of rows to some user to check for idle products.

My select brings me 100 rows, but in the email body just shows me 33 rows.

Checking some Appsheet IA agents brings me the info that the problem is about limitations of sending email via appsheet bots.

Has anyone else faced this problem?

Thank you!

1 Like
2

Hey @eduardo.fluxom , welcome to the community!

There isn’t really a limitation with bots in terms of the number of rows that it can produce inside an automation template.

Most likely what’s going on is a “fiddly bit” (as i like to call them) is not quite what it needs to be.

  • Usually has something to do with types
    • A column you’re using in your SELECT() doesn’t match the type for the column in the table you’re pulling data from

There’s usually some esoteric reason why a select() will produce a certain result in the editor, and then another result elsewhere - and these reasons usually stem from types.

Maybe take a look really close and see if maybe something is off.