Action button to email PDF Template

I currently have a kitchen food order report that is automatically emailed every day at end of business as a PDF template. Insteadโ€ฆ I would like to change this to having a โ€œsendโ€ or โ€œsubmitโ€ action button that that my team can click when they are finished inputting their order quantities. just need to email to the same 2 people every time. I want it to use the PDF template Iโ€™ve already created. Pretty new to appsheet so please detail process as much as possible

0 2 2,059
2 REPLIES 2

Hi @billjohnson
Have you checked out this doc

Yes. I have read it.

Sending Email from an Action Button

You can use an Action button on the app to perform a data change. As a result, a single click of an Action button in the app can trigger a customized Email message that is sent to one or more recipients by the AppSheet backend service. You can label the Action button to make it clear that an email will be sent when the Action button is clicked.

The โ€œOrdersโ€ table and the โ€œOn Change in Ordersโ€ workflow rule illustrate how to send email from an Action button. It works as follows:

  1. The โ€œOrdersโ€ table includes the email column โ€œEmailโ€ and the numeric column โ€œEmailsSentโ€.
  2. When the user is viewing a row in the โ€œOrdersโ€ table, they can click the โ€œEmail This Orderโ€ Action button. That increments the value in column โ€œEmailsSentโ€.
  3. The workflow rule โ€œOn Change in Ordersโ€ is triggered on the ApppSheet backend service each time the โ€œOrdersโ€ table is updated. It uses the expression below to determine if column โ€œEmailsSentโ€ has changed. If so, it generates an email and sends it to the email address contains in column โ€œEmailโ€. AND(ISNOTBLANK([_THISROW_AFTER].[EmailsSent]), [_THISROW_BEFORE].[EmailsSent] <> [_THISROW_AFTER].[EmailsSent])

This explains how it works but how do I add to my app?

Top Labels in this Space