Is it possible to refresh a specific field in dataset (not entire dataset)?

Ask the community
,
1

Greetings Fellow Wixers

I hope that all is well

I have a webpage on my site that serves as a video-game polling hub. In my ’ createdpolls ’ dataset I have a field that records the totalvotes for each poll. The poll counter is a text element in my repeater connected to my totalvote field. Everything works fine and the votes are displayed however I’m trying to take things to the next level.

Currently if a user vote on a poll, then they must refresh the page in order to see the total vote number change, I am trying to use code to update the total votes for each poll every 10-20 seconds so that it updates automatically. I think it would be cool for users to see polls votes going up in real time. Any idea how to accomplish this? Is it possible to use the refresh method to only pull updates for a single field and not the entire dataset? The code below refreshes the entire dataset which is more then I want.

2268×1185 312 KB

Code:

$w . onReady ( () =>
{
//Showcase Number of Polls Created by Community/When DATASET is Ready
$w ( “#createdPolls” ). onReady ( () =>
{

    //Refresh dataset to show updated vote numbers every 10 seconds 
    setInterval ( function ()  
    { 
        $w ( '#createdPolls' ). refresh (); 
        
    },  10000 ) 

    //Calculates Global Total number of polls created 
    let  count  =  $w ( "#createdPolls" ). getTotalCount (); 
    $w ( "#totalPolls" ). text  =  count . toString (); 

    //Get Global total amount of votes (for all polls) and display it 
    wixData . aggregate ( "createdPolls" ) 
    . sum ( "totalVotes" ,  "SummedVotes" ) 
    . run () 
    . then (( results ) => 
    { 
        let  item  =  results.items ; 
        let  globalVotes  =  item [ 0 ]. SummedVotes ; 
        $w ( "#globalVotes" ). text  =  globalVotes . toString (); 
    })

Thanks for all the help, you guys are the greatest!

aLvin