It's possible to create e-mail templates and saving them directly on your sheet design in order to have users send out e-mails that contain your entry values saved in your database. Users can directly press an action button created with the Send Custom E-mail option to send out e-mails that have been automatically filled with your values. The e-mail template's subject and body text can contain parameters described below.
Use cases include sending order confirmation details to customers or sending purchase receipts to vendors.
Navigate to the Design Mode on your form page and click Form Tools > Send Custom E-mail under the Custom Buttons title.
A pop-up window will allow you to compose your e-mail template. You can use HTML formatting and the parameters Ragic supports.
You can click on which will show you a demo on what the custom e-mail looks like.
If you decide to use our standard template instead, click on will discard all the changes you've made.
Furthermore, you may also attach URL, Excel, PDF, or mail merge file of the record; or other attachments. When you attach the URL of the record, please make sure you have granted the access right of the sheet to the recipients. Otherwise, they'll have a blank page when they access the database through the entry URL.
Once the editing is complete, remember to save before you exit the pop-up window.
You can check Automatically run when saving if you want to automatically execute this action button after saving.
After sending a custom e-mail, you may click on the mail icon to view custom e-mail history.
Variable | Description |
---|---|
{{AP_NAME}} | Name of your Ragic account |
{{SHEET_NAME}} | Sheet name |
{{TITLE_FIELD}} | Name of the title field |
{{TITLE_VALUE}} | Field value of the title field |
{{USER_NAME}} | Name of sender |
{{USER_EMAIL}} | Email address of sender |
{{DEFAULT_REPLY_TO}} | Email address of the entry. In the on-premise plan, it will display your setting in SMTP_SENDER_EMAIL |
{{RECORD_ID}} | Record ID. For details, click here. |
{{RECORD_LINK}} | Record URL |
{{RECORD_SUMMARY}} | Summary of the record |
{{FIELD ID}} | Value of a specific field. For example, if you would like to display the value of the “Customer Name” field, and the field ID of that field is 1001001, you can set the parameter as {{1001001}}. |
{{FIELD NAME}} | Value of a specific field. For example, if you would like to display the value of the “Customer Name” field, you can set the parameter as {{Customer Name}}. |
{{USERNAME_FIELD ID}} | User name of the "Select User" field. The variable does not support subtable fields. |
{{USERNAME_FIELD NAME}} | User name of the "Select User" field. The variable does not support subtable fields. |
{{GROUPUSERS_FIELD ID}} | E-mail list of the "Select Group" field. The variable does not support subtable fields. |
{{GROUPUSERS_FIELD NAME}} | E-mail list of the "Select Group" field. The variable does not support subtable fields. |
Note: if there are duplicated field names on the sheet, please use {{FIELD ID}} to retrieve the field value instead.
There are some additional settings you can configure for action buttons, you may refer to this article for detailed information.
If you want to remove the action button, you may refer to this article.