Trigger emails with the SENDMAIL function. It can be used to send notifications when data is updated in the report.
Syntax
SENDMAIL(recipients,subject,header)
Arguments
recipients - List of email IDs.
subject - Subject of the email.
header - Email content.
Example
Data input dropdowns have an On Change Formula section where you can specify the actions to be triggered when a user selects an option. In this example, an email notification is automatically triggered when the TaxRate field is updated.
Using SENDMAIL to trigger notifications
In this example, the email notification captures the data updates in the TaxRate field.
Email notification triggered when data inputs are updated
