How to store clicks count in database?

Ask the community
, ,
5

Hello, thank you very much for the help.

I was able to achieve it using this code:

// GET THE CURRENT VALUE OF THE COUNTER FROM THE DATABASE ON PAGE LOAD 🚀
$w.onReady(() => {
      $w("#dynamicDataset").onReady(() => {
          const itemObj = $w("#dynamicDataset").getCurrentItem();
          const clickCount = itemObj.clicks || 0;
          $w("#clickCounter").text = clickCount.toLocaleString();
      });
});

// UPDATE THE COUNTER AND SAVE IT IN THE DATABASE WHEN THE BUTTON IS CLICKED 🖱️
$w("#button1").onClick(() => {
      $w("#dynamicDataset").onReady(() => {
          const itemObj = $w("#dynamicDataset").getCurrentItem();
          const clickCount = itemObj.clicks || 0;
          const newClickCount = clickCount + 1;
          itemObj.clicks = newClickCount;
          $w("#dynamicDataset").setFieldValue("clicks", newClickCount)
          $w("#dynamicDataset").save()
              .then(() => {
                  $w("#clickCounter").text = newClickCount.toLocaleString();
              });
      });
});
1 Like