How can I check each object in an array for duplicate values and return how many times the value was repeated?

Ask the community
,
1

How can I count how many times a value exist in an array? I need to check each object individually and when there are duplicates return the number. For example: On Cabin A, G2 Name is duplicated, so count how many times it occurs and then run again to check obj Camp B. I created a CSS Grid to use instead of the standard Wix Table for more formatting options and to include a drag and swap feature
(picture below). My database data is structured similar to the array below, fields correspond to dates and show guest who reserved the site for that date. The end goal is to be able to rearrange/reassign guest to other sites by dragging their name from original site to new site. Right now it’s only moving a cell at a time
instead of the 2 cells that contain “G2 Name”.
I am stuck trying to figure out how to check for each object for each key that has a value, if there are consecutive duplicates, how many? Any help would be greatly appreciated, my head is spinning just trying to articulate what i’m trying to do much less to figure out where to even start.

var myData = [
{
“Site”:“Cabin A”,
“Sep 01”:“”,
“Sep 02”:“”,
“Sep 03”:“G1 Name”,
“Sep 04”:“”,
“Sep 05”:“”,
“Sep 06”:“G2 Name”,
“Sep 07”:“G2 Name”
},
{
“Site”:“Camp B”,
“Sep 01”:“G3 Name”,
“Sep 02”:“G3 Name”,
“Sep 03”:“G3 Name”,
“Sep 04”:“”,
“Sep 05”:“”,
“Sep 06”:“G4 Name”,
“Sep 07”:“G4 Name”
},
{
“Site”:“RV Site A”,
“Sep 01”:“”,
“Sep 02”:“G5 Name”,
“Sep 03”:“”,
“Sep 04”:“”,
“Sep 05”:“”,
“Sep 06”:“G6 Name”,
“Sep 07”:“G6 Name”
}
]

907×212 4.2 KB

2
  1. Create a for or an each-loop
  2. to enter an item inside an array → myArray[0], myArray[1], myArray[3]
  3. to enter an Object inside an Array…
let myArray = [{name: object0}, {name: object1}, {...}, {...}, ........]

let mySearchedValue = myArray[1] ---> RESULT = ??? --> {whole Object}
let mySearchedValue = myArray[1].name ---> RESULT = ??? --> "object1"

So now create a function, which will scann all the OBJECTS inside your ARRAY, for a specific ITEM, or VALUE (PARAMETER).