How to do a blocking confirmation message in your JS code

Community Show & Tell
1

This has been asked a few times and the only previous solution was to use a modal.

I just figured out another way that matches (actually it uses) the same confirmation modal already in queries so there is a consistent UI experience.

Here is an example of asking the user if they want to save changes before a modal closes:

First you need to make a simple Query JSON With SQL query. Note it is set to Run Manually:

image

Then set a confirmation message in it:

image
image745×254 13.5 KB

You can then add a blocking confirmation to any JS query:

// First we reset the query do that confirmMessage.data will be null
await confirmMessage.reset()
// do confirmation
await confirmMessage.trigger()
if (confirmMessage.data !== null) {
  // User OK, save the record
  await qryTaskUpdate.trigger()
  if (qryTaskUpdate.data.error) {
    // error in update query
    utils.showNotification({title: 'Error',description: 'There was an error saving the record: ' + qryTaskUpdate.data.error, notificationType: "error"})
    // modal stays open
    return
  }
}
// User clicked cancel - just close modal
modal1.close()
3 Likes
2

hi
I do exactly the same but got strange behaviors.
It always get the right result in data then i to it twice.

Example:
First click on cancel i got data != null
Second click on canncel i got data == null
Then i click ok i got data == null
Second click on ok i got data != null

this happens all the time.

3

Hi @bradlymathews thanks for your share.

But I find In your code, qryTaskUpdate.trigger will always run, either you click yes or no;

I modify you code it work well,

// First we reset the query do that confirmMessage.data will be null
await confirmMessage.reset()
// do confirmation
let resultOfConfirm = await confirmMessage.trigger()

if (typeof resultOfConfirm !== "undefined") {
  // User OK, save the record
  await qryTaskUpdate.trigger()
  if (qryTaskUpdate.data.error) {
    // error in update query
    utils.showNotification({title: 'Error',description: 'There was an error saving the record: ' + qryTaskUpdate.data.error, notificationType: "error"})
    // modal stays open
    return
  }
}
// User clicked cancel - just close modal
modal1.close()
1 Like