Well a big hurtle I run into is sending emails that need data formatted as a table in the body of the email. I know this can be achieved by just making a view of the table in a canvas column, but it becomes really difficult to manage when I have to send the email to 200 people or more.
So what I’d love is either:
- A formula that I can use to generate a grid. Something like makegrid(column formula,row formula) or something. This option would be ideal because I don’t always know how many rows I’ll need.
- If they could get the format() formula to work with grids. I usually have a Templates table, and the template will be in a canvas column, then I reference it in each row that actually contains the data I need. But when I try to do this with a grid, it doesn’t work. See this post.
I’ve tried a lot of different methods to send tables in the body of emails but it’s always a major pain to get them set up.