Skip to main content

Creating Catalogs to Email from Table Views

  • August 26, 2022
  • 2 replies
  • 22 views

Forum|alt.badge.img+14

Hi there!

I am trying to figure out a way to create book catalogs to automatically email customers from specific table views. I do something similar for sales: When the Shipped field from my Sales table is checked, an email notification automatically goes out. In this case, though, I’m hoping to send multiple books in a single email, and hoping to avoid the awkward bunching together of ALL TITLES, ALL AUTHORS, etc. Ideally, all the records would be displayed with their seven fields in this format:

AUTHOR. Title. Place: Publisher, Year. Description. Price.

Any suggestions? Are there any extensions that might make this possible? Thanks in advance for any ideas or expertise you might be willing to share!

This topic has been closed for replies.

2 replies

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Alba_Machado2

The best way to do that is to have a formula in the Books table with those fields, then link the books to the customers, then you can lookup / rollup the new formula field to the customers table where you can send the email


Forum|alt.badge.img+14
  • Author
  • Known Participant
  • August 28, 2022

Hi @Alba_Machado2

The best way to do that is to have a formula in the Books table with those fields, then link the books to the customers, then you can lookup / rollup the new formula field to the customers table where you can send the email


Gonna try it out. Thanks for the suggestion! I’ll let you know how it goes . . .