@russian-dima YOU ROCK!!!!!!! IT FINALLY WORKS!!!!!!

But I dont kwon how to show the count results! This is what It shows the console: _id: "CIMITARRA SANTANDER" count: 6 ciudad: "CIMITARRA SANTANDER" I need to show in one column the count

YOU ARE A GENIUS. Thats the problem. Is there anyway to show the results maybe in a table?

Yes but the results of the aggregate are 52! I just show you the first one. What I mean is: ¿Is there any way to show all of the results in the repeater? This is the console Thanks for your patience!

Thanks again So what I did was: let xxxx =[ {"_id": "001", "firstName": "John"}, {"_id": "002", "firstName": "Rebecca"}, {"_id": "003", "firstName": "Silvio"}, {"_id": "004", "firstName": "Sindy"}, {"_id": "005", "firstName": "Antonio"}, {"_id": "006", "firstName": "Stefano"}, ] $w.onReady(async function() { $w('#button15').onClick(()=>{ start_myFunction(); }) $w("#repeater2").data = xxxx; $w("#repeater2").onItemReady(($item, itemData, index) => { $item("#id").text = itemData._id; $item("#ciudad").text = itemData.firstName; }); }); function start_myFunction() { wixData.aggregate("HistoriaClinica") .group("ciudad") .count() .run() .then((results) => { let items = results.items; console.log(items) $w("#repeater2").data = items; } ); } It works showing the xxxx values but it doesn't show the values of the aggregate results when I click the button15 😫

@russian-dima CLOSE! I just have this error: Wix code SDK error: Each item in the items array must have a member named `_id` which contains a unique value identifying the item.

Hi! Thanks for your quick answer. This is what I get in the console: 0: {...} jsonTablaCopy JSON _id: "ATLANTICO" count: 1 ciudad: "ATLANTICO" I just need to put than on a repeater

@Kristof Thanks again my friend. Can you help me, creating a blank site and try the code? I did it and it doesnt work either

Thanks for taking the time to help me! Still doesnt work. This is the change I made: export function createBUTTON_click(event) { $w.onReady( () => { $w("#dbWrite").onReady( () => { $w("#dbWrite").setFieldValues( { "aprobacion": "PENDIENTE", "atendido": "PENDIENTE" } ); $w("#dbWrite").save(); } ); } ); I dont know if because the button is connected to the dataset and performing the save action, there is a conflict. But remember!... I´ve been using these code 6 months from now and always worked! three days ago stop working Other fact: I have 3 different sites and all of them have the same code. They used to work, until now. The SetFieldValue its not working on them either LAST FACT!: I just created a blank site to test the code. Definetly SetFieldValue doesnt work. If you guys wanna give it i try. Create your own blank site and try it. You´ll see there is something wrong with Velo

Thanks for taking the time to help me! Still doesnt work. This is the change I made: export function createBUTTON_click(event) { $w.onReady( () => { $w("#dbWrite").onReady( () => { $w("#dbWrite").setFieldValues( { "aprobacion": "PENDIENTE", "atendido": "PENDIENTE" } ); $w("#dbWrite").save(); } ); } ); I dont know if because the button is connected to the dataset and performing the save action, there is a conflict. But remember!... I´ve been using these code 6 months from now and always worked! three days ago stop working Other fact: I have 3 different sites and all of them have the same code. They used to work, until now. The SetFieldValue its not working on them either LAST FACT!: I just created a blank site to test the code. Definetly SetFieldValue doesnt work. If you guys wanna give it i try. Create your own blank site and try it. You´ll see there is something wrong with Velo

@Kristof Can you give me a quick example?

@russian-dima Thanks again! still not working 😫 TRY ONE: export function createBUTTON_click(event) { $w("#dbWrite").onBeforeSave( () => { $w("#dbWrite").setFieldValue("aprobacion", "PENDIENTE") $w("#dbWrite").setFieldValue("atendido", "PENDIENTE") $w("#dbWrite").setFieldValue("estado", "PENDIENTE") } ); } TRY TWO: export function createBUTTON_click(event) { $w("#dbWrite").onBeforeSave( () => { $w("#dbWrite").setFieldValue("aprobacion", "PENDIENTE") $w("#dbWrite").setFieldValue("atendido", "PENDIENTE") $w("#dbWrite").setFieldValue("estado", "PENDIENTE") $w("#dbWrite").save; } ); } Also I forgot to tell you that createBUTTON, is connected to the dataset: THANKS AGAIN GUYS

Thanks! Still not working. It very strange! Sometimes it works, sometimes doesnt Somebody help!

YES! Thanks for reading sensei

🤓 THANKS!!!

amazing teacher

Its not about the name! It has transformed my business in so radical way. Call it Velo, Corvid, Aids or Cancer. Its the best plataform ever

@russian-dima Thanks for your help

@russian-dima Hi Dima! YES! That way it saves "5" into the database! This it what the console log shows: 1 number 2 number string number Start-Saving-Process string

YES! That way it saves "5" into the database! This it what the console log shows: 1 number 2 number string number Start-Saving-Process string