Notification

Overview¶

This function automatically notifies you by email or communication tools such as Teams, Slack, and Chatwork when you perform operations such as creating, updating, or deleting records in time-limited tables. By combining it with View, you can specify the notification conditions.

Limitations¶

1. When sending notifications by bulk update, only fixed email addresses can be notified. "RelatedUsers" and "Owner" cannot be used.
2. Subject settings are only valid for creating, updating, deleting, and copying.

Settings Screen¶

With the relevant table open, click "Manage" - "Manage Table" from the navigation menu.
*Not displayed for users who do not have Site Administration Permission.

Detailed Columns¶

*1. Enter the string "[Column name]" in the subject to display the column value, "[NotificationTrigger]". By entering the string, you can insert the string of the operation performed by the user (create/update/delete).
(Example) If you set "[NotificationTrigger]Notification - [[Status]] [Title]" in the subject

• When creating a record

  "Create notification - [Not started] Record title"

• When deleting a record

  "Delete notification - [Not started] Record title"

If not set, the same wording as the success message when creating, updating, or deleting. ("XX has been created.", etc.)
2. Displayed when Chatwork, LINE, LINE group or InCircle is specified.
3. Displayed when "Use custom design" is checked ON.
4. Displayed when a view is set.
5. Used only when the notification timing is "After update".

Specify The Notification Type¶

Specify the notification type. You can select from the following notification types that you have enabled in "Notification.json".

*If you want to be notified by email, you need to set up email sending.

Specify The Timing Of Notification¶

Specify the timing of notification. Notifications will be sent when the checkboxes on the settings screen are checked.

Dynamically Set Email Notification Destination¶

Email notifications can be sent to not only specific email addresses, but also to the Owner, Manager, and other email addresses specified in any field.
This setting can be used in the "Address", "Cc", and "Bcc" fields.

Targets that can be specified as recipients¶

Setting to Send Email Notifications to Related Parties of A Record¶

Select Email as the notification type and enter [RelatedUsers] as the address. When you set this, notifications will be sent to the email addresses of users who are the record creator, updater, manager, or owner. The target person check also includes the record update history. No notification will be sent if the target person does not have an email address set.

Example Of Settings And Sending Results¶

If you set the notification destination as shown below, an email will be dynamically sent to the destination according to the record contents shown in the table below.

Setting Example¶

If you set it as follows, a fixed notification will be sent to example＠example.com, and if the Owner registered for each record and the content contains an email address, a notification email will also be sent to that address.

example＠example.com, [owner], [content]

Dynamic Destination Specification By User/Department/Group¶

If the notification type is "email", you can dynamically specify the destination. However, users/depts/groups that are disabled will not be notified.

Specifying An ID Directly In The Address¶

You can directly specify a user ID/depts ID/group ID in the address. The name of the user/depts/group will not be displayed, so be careful not to make any mistakes in the ID you specify.

Setting Example:

Specify Class Column For Address¶

You can specify class column with "Users Option List", "Department Option List", and "Group Option List" set for the address. Use this when you want to dynamically change the destination for users/depts/groups set on a record-by-record basis. If the class column is set to "Multiple Selection", all multiple selections will be notified.

Example of settings:

Notification Message¶

Format Elements That Make Up The Notification¶

The notification body is made up of the following elements.

1. Fixed string
2. Placeholder
3. Format string

{"Name":"[Work process]","Prefix":"■","Delimiter":" : ","Allow":" => ","Always":true}

{"Name":"[Title]", "DiffTypes":"DiffMatchPatch", "StartBracket":"[", "EndBracket":"]", "DeletePrefixSymbol":"del:", "DeleteSuffixSymbol":"/del", "AddPrefixSymbol":"add:", "AddSuffixSymbol":"/add"}

Title: [del:document/del][add:design/add]create[add:work/add]

Message Body¶

Default Message¶

The following format is used as the default message text.

Note that column name N in the following is a repeating column that includes all the columns in the table.

{Url}
{"Name":"[Column name N]"}

{UserName}<{MailAddress}

Using Custom Design¶

You can customize the notification text using the format elements mentioned above.

<summary>Click here to see the configuration example</summary>

The following information has been updated.
http://servername/items/999/edit
★Title ☆ Check network requirements ◆ Check network requirements and equipment
Comment: The requirements specification document has been created. The deliverables have been stored in the specified folder.
Yamaguchi Taro < taro@yamaguchi123.co.jp >

Supported Versions¶