Solved: Send notifications to the certain users when field... - Page 2

Alex_Ye · 09-27-2022 06:56 AM

I want to be able to send notifications to the users of the app.

There is a lessons table and there is a field with link, when lesson record is created later lesson link will be added to the record to the lesson link field.

Also there is a student table that is related to the lesson table through the access table to create many to many relation so that each lesson could have multiple students.

So each time I add lesson link to the lesson record I want my app send notification to the students assigned to the lesson.

Please help to understand how to create it.

Thank you in advance.

Suvrutt_Gurjar

1. Please create a data change event bot on the Lessons table. The condition of this bot should be

AND([_THISROW_BEFORE].[Lesson LINK Field] <> [_THISROW_AFTER].[Lesson LINK Field], ISNOTBLANK([_THISROW_AFTER].[Lesson LINK Field]))

This condition ensures the bot fires only when the lessons link is added or changed. Please make the bot to run suitably on record add or record updated.

2. In the step for the notification, in the To Field please add an expression something like [Related Students][Student Email] where [Related Students] is the reverse reference column in the Lessons table. [Student Email] is email of each student from the Students table.

3. Please add suitable message and Deep =link as required in the notification bot step.

In the screenshots above "Order" table is mentioned. You need to place "Lessons" table in its place.

View solution in original post

Send notifications to the certain users when field in a record is updated.