Skip to main content

11.2 - How the Do Before Insert Event Works

Last updated 20/05/2025

With the

SaveBookBeforeUpdate()
function attached to the Do Before Update event on the Book table, we can now see how Rick receives a notification when Chelsea selects him in the Borrowed By field on the Books form. Once Chelsea accepts the request, the Request Book button will be removed from the Find Books dashboard as this book is no longer available to borrow until it is returned.
tip
Once you deploy/run the Book Club application, copy the URL for the Book Club application into another tab in a different browser, this way you can have two logins running at the same time!

Rick's login credentials:

  • Username: rick
  • Password: Demo123!

Chelsea's login credentials:

  • Username: chelsea
  • Password: Demo123!

Sign into the two Book Club accounts with the above credentials.

On Chelsea's login , she still has the notification in the Notifications bell that Rick wants to borrow her book.
Chelsea's notification
Figure 1 - Chelsea's notification

Accepting the Request​

Chelsea would perform the following steps to accept the request.

 1. Type Mastering in the Search field above the list.

2. Select the Mastering TypeScript 3 record in the list.


Search field
Figure 2 - Search field

3. Either click the Edit button in the form app bar or click directly in the Borrowed By field.

4. Click the lookup icon in the Borrowed By field and select Rick West.


Select borrowing member
Figure 3 - Select borrowing member

5. Click the Save button in the form app bar.


Save button
Figure 4 - Save button

Location for Collection Point​

On Rick's login, he will now have a notification accepting his request and informing him of the collection point. Rick would perform the following steps to know his request has been accepted and where the collection point is.

 1. Click the Notifications bell.

2. Click the link in the notification.


Rick's notification
Figure 5 - Rick's notification

A new window will open for Rick with the location of the pickup address in Google Maps.
Parcel locker location
Figure 6 - Parcel locker location

The address for the location came from the values entered on Chelsea's user form.
Chelsea's user form
Figure 7 - Chelsea's user form

If we come back to the Find Books dashboard and make a search for the book, you will see the Request Book button has been removed as Chelsea has accepted Rick's request.
Find Books dashboard
Figure 8 - Find Books dashboard