Hello guys today I’ll give you a simple code that’ll format the numbers coming out of dataset/collection using the k format or comma format in a repeater or dynamic page
I’m so sorry for breaking the community guidelines by tagging people but during research I found out that @tiffaney-valenzuela @avalonvehiclesales @gabelec18 @zonaibnajaf needed this code.
things to Know:
$w( “#text1” ).text = where the number should be (don’t connect to dataset)
viewCount = the column Id in the collection
$w( ‘#dynamicDataset’ ) = the current item dataset or the current page dataset
$w( “#repeater1” ) = your repeater
Dynamic pages
k format
This will change numbers like “43233” to “43.2k”
This will change numbers like “3232” to “3.2k”
This will change numbers like “893239230” to “893.2M”
This will change numbers like “89323923030” to “1B+”
function Kformat () {
$w('#dynamicDataset').onReady(() => {
let currentItem = $w('#dynamicDataset').getCurrentItem()
let number = currentItem.viewCount
if(number < 1000 && number > -1) {//0 to 999 will be number + nothing
let x = (number/1) + ""
$w("#text1").text = x;
console.log(number);
}
if(number < 1000000 && number > 999) {//999 to 999,999 will be number + k
let x = (number/1000).toFixed(1) + "k";
$w("#text1").text = x;
console.log(x);
}
if(number < 1000000000 && number > 999999) {//999,999 to 999,999,999 will be number + M
let x = (number/1000000).toFixed(1) + "M";
$w("#text1").text = x;
console.log(x);
}
if(number > 999999999) {//number from 1 billion and above will be 1B +
let x = "1B+";
$w("#text1").text = x;
console.log(x);
}
})
}
//do the function on when the dataset is ready
export function dynamicDataset_ready() {
// This function was added from the Properties & Events panel. To learn more, visit http://wix.to/UcBnC-4
// Add your code for this event here:
kformat()
}
comma format
This will change numbers like “43233” to “43,233”
This will change numbers like “3232” to “3,232”
This will change numbers like “893239230” to “893,239,230”
This will change numbers like “89323923030” to “89,323,923,030”
function commaFormat (x) {
return x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",");
}
export function dynamicDataset_ready() {
let currentItem= $w('#dynamicDataset').getCurrentItem()
let number = currentItem.viewCount;
let x= commaFormat(number);
$w("#text1").text = x;
}
Repeaters
k format
This will change numbers like “43233” to “43.2k”
This will change numbers like “3232” to “3.2k”
This will change numbers like “893239230” to “893.2M”
This will change numbers like “89323923030” to “1B+”
function Kformat () {
$w("#repeater1").forEachItem( ($item, itemData, index) => {
let currentItem = $item('#dynamicDataset').getCurrentItem()
let number = currentItem.viewCount
if(number < 1000 && number > -1) {//0 to 999 will be number + nothing
let x = (number/1) + ""
$item("#text1").text = x;
console.log(number);
}
if(number < 1000000 && number > 999) {//999 to 1 million will be number + k
let x = (number/1000).toFixed(1) + "k";
$item("#text1").text = x;
console.log(x);
}
if(number < 1000000000 && number > 999999) {//999,999 to 999,999,999 will be number + M
let x = (number/1000000).toFixed(1) + "M";
$item("#text1").text = x;
console.log(x);
}
if(number > 999999999) {//number from 1 billion and above will be 1B +
let x = "1B+";
$item("#text1").text = x;
console.log(x);
}
});
}
export function dynamicDataset_ready() {
kformat()
}
comma format
This will change numbers like “43233” to “43,233”
This will change numbers like “3232” to “3,232”
This will change numbers like “893239230” to “893,239,230”
This will change numbers like “89323923030” to “89,323,923,030”
function commaFormat (x) {
return x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",");
}
export function repeater1_itemReady($item, itemData, index) {
// This function was added from the Properties & Events panel. To learn more, visit http://wix.to/UcBnC-4
// Add your code for this event here:
let number= itemData.viewCount;
let x = formatNumber(number);
$item("#text1").text = x;
}
You’re welcome
Please know you can also tweak these to your liking
If you have any bugs or errors or maybe even ideas. Please email me at nzubefootballer@gmail.com or you can create a new forum and tag me
DJ bon26
