Help manipulating data inside an array

Im working on a project that sniffs nearby WiFi networks. How do I insert a conditional statement in a nested json array to output approximate distance based on RSSI value. Currently I can print out the RSSI and SSID of nearby networks.

This is what it looks like. I want to get rid of the table on the right side and print it immediately with these conditions

if (RSSI > -40) {
meters = 1;
} else if (RSSI <= -41 & RSSI >= -51) {
meters = 1.5;
} else if (RSSI <= -52 & RSSI >= -62) {
meters = 2;
} else if (RSSI <= -63 & RSSI >= -73) {
meters = 2.5;
} else if (RSSI <= -74 & RSSI >= -84) {
meters = 3;
} else if (RSSI <= -75 & RSSI >= -85) {
meters = 3.5;
} else if (RSSI <= -86 & RSSI >= -100) {
meters = 4;
} else {
meters = 5;
}

[{"id":"f63156ff.1a0148","type":"tab","label":"RSSI","disabled":false,"info":""},{"id":"c8396642.6f7ac8","type":"mqtt in","z":"f63156ff.1a0148","name":"RSSI Sniffer","topic":"rssi/test","qos":"1","datatype":"auto","broker":"295202a1.7626ae","x":350,"y":320,"wires":[["37c1013f.94e86e"]]},{"id":"37c1013f.94e86e","type":"json","z":"f63156ff.1a0148","name":"jsonconversion","property":"payload","action":"obj","pretty":false,"x":660,"y":240,"wires":[["9f9b613e.b58cc"]]},{"id":"5d058e63.9a52e","type":"ui_template","z":"f63156ff.1a0148","group":"38ef9235.21dd1e","name":"","order":1,"width":"8","height":"8","format":"<table class=\"ng-scope\" style=\"color: rgb(17, 17, 17); font-family: -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, Oxygen-Sans, Ubuntu, Cantarell, &quot;Helvetica Neue&quot;, sans-serif; font-size: medium; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; height: 156px; width: 430px;\">\n  <tbody>\n    <tr>\n      <td style=\"width: 64.186%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(128, 128, 128);\">Less than -40</span></h2>\n      </td>\n      <td style=\"width: 35.5814%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(51, 153, 102);\">1m range&nbsp;</span></h2>\n      </td>\n    </tr>\n    <tr>\n      <td style=\"width: 64.186%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(128, 128, 128);\">-40 to -51</span></h2>\n      </td>\n      <td style=\"width: 35.5814%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(153, 204, 0);\">1.5m range</span></h2>\n      </td>\n    </tr>\n    <tr>\n      <td style=\"width: 64.186%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(128, 128, 128);\">-52 to -62</span></h2>\n      </td>\n      <td style=\"width: 35.5814%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(41, 105, 176);\">2m range</span></h2>\n      </td>\n    </tr>\n    <tr>\n      <td style=\"width: 64.186%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(128, 128, 128);\">-63 to -73</span></h2>\n      </td>\n      <td style=\"width: 35.5814%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(255, 255, 0);\">2.5m range</span></h2>\n      </td>\n    </tr>\n    <tr>\n      <td style=\"width: 64.186%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(128, 128, 128);\">-74 to -84</span></h2>\n      </td>\n      <td style=\"width: 35.5814%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(255, 153, 0);\">3m range</span></h2>\n      </td>\n    </tr>\n    <tr>\n      <td style=\"width: 64.186%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(128, 128, 128);\">-75 to -85</span></h2>\n      </td>\n      <td style=\"width: 35.5814%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(255, 102, 0);\">3.5m range</span></h2>\n      </td>\n    </tr>\n    <tr>\n      <td style=\"width: 64.186%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(128, 128, 128);\">&nbsp;-86 and above</span></h2>\n      </td>\n      <td style=\"width: 35.5814%;\">\n        <h2 style=\"margin: 0.3em 0px;\"><span style=\"color: rgb(255, 0, 0);\">4m above</span></h2>\n      </td>\n    </tr>\n  </tbody>\n</table>","storeOutMessages":true,"fwdInMessages":true,"templateScope":"local","x":800,"y":400,"wires":[[]]},{"id":"224cd04a.ca438","type":"ui_template","z":"f63156ff.1a0148","group":"89bcaf75.fdca","name":"","order":0,"width":"8","height":"9","format":"<h1>RSSI Readings</h1>\n<h1><ul>\n    <li ng-repeat=\"x in msg.payload\">\n        <span>{{x.SSID}}: {{x.RSSI}}</span>\n    </li>\n</ul></h1>","storeOutMessages":true,"fwdInMessages":true,"templateScope":"local","x":1020,"y":240,"wires":[[]]},{"id":"c2b9326c.964fc","type":"debug","z":"f63156ff.1a0148","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":990,"y":360,"wires":[]},{"id":"9f9b613e.b58cc","type":"function","z":"f63156ff.1a0148","name":"","func":"msg.payload = msg.payload.Networks.filter(el => el.SSID.includes(\"ARSARO_\"))\nreturn msg","outputs":1,"noerr":0,"x":790,"y":300,"wires":[["c2b9326c.964fc","224cd04a.ca438"]]},{"id":"295202a1.7626ae","type":"mqtt-broker","z":"","name":"","broker":"127.0.0.1","port":"1883","clientid":"","usetls":false,"compatmode":false,"keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closeQos":"0","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"38ef9235.21dd1e","type":"ui_group","z":"","name":"Rssi in Meters","tab":"609e67a4.396668","order":2,"disp":true,"width":"8","collapse":false},{"id":"89bcaf75.fdca","type":"ui_group","z":"","name":"rssi","tab":"609e67a4.396668","order":1,"disp":false,"width":"8","collapse":false},{"id":"609e67a4.396668","type":"ui_tab","z":"","name":"Home","icon":"mic","disabled":false,"hidden":false}]

this is my flow

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.