Greasy Fork is available in English.

Munzee Garden Pin Checker

Verify Munzee Garden Pins!

Autor
Technical-13
Denne inštalácií
0
Celkový počet inštalácií
139
Hodnotenie
0 0 0
Verzia
2020.04.13.1012ß
Vytvorené
22.10.2018
Aktualizované
13.04.2020
Licencia
neuvedené
Spustiť na

Quick and easy way to check if garden pins are the right type and in the right place!

Put this code in the top "Checker Link" cell (default: J2) of your sheet and drag copy to the last row. :)


=IF(AND($H2<>"",$I2<>""),HYPERLINK("https://www.munzee.com/m/"&$H2&"/"&$I2&"/map/?lat="&$D2&"&lon="&$E2&"&type="&$F2&"&name="&SUBSTITUTE($A2,"#","%23"),$H2&"/"&$I2),IF($H2<>"",IF(REGEXMATCH($H2,"50( ?['fF]([oO]{2})?[tT]?)?( ?[eE][rR]{2}[oO][rR])?"),HYPERLINK("https://www.munzee.com/map/?sandbox=1&lat="&$D2&"&lon="&$E2&"&name="&SUBSTITUTE($A2,"#","%23"),"SANDBOX"),HYPERLINK("https://www.munzee.com/m/"&$H2&"/",$H2)),""))