Retrieve data from collection and use it in the code

Ask the community
, ,
1

Hello everybody,
i have created a collection that is storing the personal record in fitness excercise of each user.
I would like to use that data in the code in way of to automaticcaly write the fitness program of the user,
i tryed to use this but show me error in the input box
import wixData from ‘wix-data’ ;

$w.onReady( function () {

 wixData.query( "Members" ) 
 .and( "Snatch" ,$w( '#setvolume' ).value )

});

2

Try this code here and take a look into CONSOLE. You should find some results there.

import wixData from'wix-data';    

var myDATABASE = "Members"
var myField = "Snatch"
var myValue = $w('#setvolume').value 

$w.onReady(function () {
   wixData.query(myDATABASE)      
   .eq(myField, myValue)
   .find()
   .then((results)=>{console.log(results)})
});
3

I tried but no solution…maybe i explained bad…
this is my database;
for the moment there are only user 1 and 2…
what i would like to to is to intersecate the value of the excercise depending on the logged in user.
Then i would like to save the result into a variable

1546×745 62.9 KB