áŒáŠ•á‰ŁáŠ•áŒ˛á‰³á‰µâ€”Google Sheets
Feature availability
- Free
- Lite
- Pro
- Lite Pro
- Pro Business
áˆ“á‰ŁáˆŞá‰łá‰ľá¡ áŠ•áˆˆáŠ˜á‰˛ ንáŒáŠ•á‰ŁáŠ•áŒ˛á‰łá‰ľ latitude,longitude ባዕቲ ከ቎ማጠá‹áŠŁ áŠŁáŒˆáˆá‹áˆŽáˆ‰ á‹ŤáŠ•á‹°áˆľ አá‹áˆ°áˆáˆ•ንá¢
á‹á‹˜á‰ľ
Add Data Source áˆ˜áˆŁáˆá‹• áŠáቲ
Data Connectors ከáˆáŠ
áŠ á‰ŁáŠ•áŒ¥:
- Google Sheets
- Zapier (በቅáˆá‰Ą á‹áˆ˜áŒŁ)
- Salesforce (በቅáˆá‰Ą á‹áˆ˜áŒŁ)
- BigQuery (በቅáˆá‰Ą á‹áˆ˜áŒŁ)
- Hubspot (በቅáˆá‰Ą á‹áˆ˜áŒŁ)
- Custom (በቅáˆá‰Ą á‹áˆ˜áŒŁ)
Add Data Source áˆ˜áˆŁáˆá‹• áŠáቲ
- Scribble Maps በዚኛá‹áŠ• áŠáቲ:
https://www.scribblemaps.com/create - በታቲ áˆľáŠáˆŞáŠ• በዲá‹áŠ• footer menu á‹áˆľáŒĽ "Launch Pad" áŠáˆŠáŠ áŠ á‰ĽáˆŽá¢
የLaunch Pad menu áŠáЍáˆáŠ á‰ áˆŽá‰ľ á‰µáˆ¨áŠ˘á¢
- á‰ á‹¨áˆŠáŠ á‰ŁáŠ•á‹˛ menuᣠየáˆá‰ ንባንንቾ á‹áˆ˛á‹ŞáŠ• á‹¨áˆŤáŠŞáŠ•áŠ•á‰ľ Data Connector ንáˆáˆáˆ¨áŒ½ "Connect Live Data" የለዠáˆá‹•áˆľ áˆľáˆŠáˆľ ንá‹áˆ¨á‹Žá¢
Google Sheets áŠ áŒ“áŠ•á‰Ą
- "Add Google Sheet" áŠáˆŠáŠ áŠ á‰ĽáˆŽá¢
- ካቾ á‹ŤáˆŤáŠŞ pop-up menu የá‹áŠ¨á‰˛ áŠ•áˆŤáˆľáŠ áŠ•áˆáˆŞáŒŻáˆ "Choose an account" áŠáˆŠáŠ áŠ á‰ĽáˆŽá¢
-
ናቾ Scribble Maps ናብ Google Account ንንካብ ውá‹áŠ“ የውá‹áˆ "Allow" áŠáˆŠáŠ áŠ á‰ĽáˆŽá¢
áŠ¨áˆľáŠ¨á‰ľ ScribbleMaps áŠ¨áˆ˜áŠ¨á‰ľ ቼáˆáŠŁá‹áˆá¡
- ካቾ እዚን áŠ á‰Žáˆ˜á‰ľ á‹áŒĽáˆ¨áˆ የውá‹áˆ Google Drive á á‹áˆŽá‰ľ ቲዪን ከá‹áˆŤáˆ¨á‹á¤ ከááŒ¨áˆľá¤ áŠ¨á‹á‰ľáŠáˆľ á‹¨á‹Šáˆľ ቼáˆáŠŁá‹áˆá¢
- á‹áˆˆá‹ŽáŠ• Google Sheets spreadsheets በáˆáˆ‰áˆ ቲውá‹áˆ á‹áЍá‹áŠ“áˆá¢
áˆá‰˛á‹ŞáŠ• መááˆá‹ˇ áŠ•áˆˆáŠ“á‰ľ account á‹¨á‹Ťáˆ›áˆľá‹áˆŠ á‹áŠŁáˆŞá‹ŤáŠ• áˆ˜áŠ•áŒˆáˆŁáŠ• áŒáŠ•á‰ŁáŠ•áŒ˛á‰łá‰ľ ቲውá‹áˆ á‹¨áˆ°áˆŤá‹ŞáŠ•á‹ŤáŠ• ባከá‹áŠáˆľ ውንቾ ዌቲዡá¢á‰ ዚንውን Scribble Maps ከá‹áŠ“ Google Sheet á‹á‰˛áˆ˜á‰ľ á‹áЍá‹áˆˆá‹ˇá¢ - ናቾ ካáˆá‰˛á‹Ž ንማዕ áˆŠáŠ•áŠ á‹¨á‹Ťá‹áˆ sheet áˆá‰˛á‹ŞáŠ• áŠáˆŠáŠ áŠ á‰ĽáˆŽá¢
-
"Select" button áŠáˆŠáŠ áŠ á‰ĽáˆŽá¢
የADD DATA CONNECTORS menu á‹áŠŤáˆá‰˛á‹ˇá¢
Data Connectors ከáˆáŠ
- በ"Name" field á‹áˆľáŒĽá£ የውá‹áˆ á‰°áˆŞáˆ á‰ á‹¨áˆ˜á‹ˇáˆ˜á‹ˇá‰ľ የGoogle Sheet áˆľáˆ á‹áŠŤáŠ“á¢ áŠ•áˆáˆŞáŒá‹Ž á‹áˆ¨áŠ¨á‰ˇ áˆľáˆ á‹˛á‹Šáˆ˛ ንá‹áˆľáŒ á‹áŠŤáˆˆá‹¨á‹˛á¢
- በ"Sheet To Use" field á‰°á‰˛áˆŹ የውá‹áˆ Sheet á‰°á‹ˇáˆŞáŒ˝ ከáˆáŠŤáŠ“ áŠ•áˆ˜áˆˆáˆľ በየውá‹áˆ drop-down menu á‰°áˆ°á‰ŁáŠ•á‹Ž Sheet á‹áˆˆáŒĽá¢
- በ"Marker Style" field á‰łá‰˛á£ á‹¨á‹Ťá‹áˆ የmarker style ንáˆáˆáˆ¨áŒ½ á‹áЍáˆá‹ˇ icon áŠáˆŠáŠ áŠ á‰ĽáˆŽ..
- በ"MARKERS/SYMBOLS/TEXTURES" menu á‹áˆľáŒĽá£ ንየውá‹áˆ በSheet á‹áŒˆáŠ áŠ áŠ«á‰Łá‰˛ áˆ˜á‹ˇáˆ°áˆŤ የውá‹áˆ marker áˆáˆ¨áŒ˝á¢
-
ካቾ "ID (Recommended)" field የConnector ID ከá‹áЍá‹áŠ• የSheet field áˆáˆ¨áŒ˝á¢
የID ባንዲ ንየውá‹áˆ áˆ˜á‹ˇáˆ°áˆŤ አንዲ የተለየ ዌ á‹áЍá‹áŠ• á‹áŒˆá‰Ł á‹Śá‰˛á‹ˇá¢ á‹¨ID ባንዲ ዏቲáˆáˆľáˆ¨ overlays á‰ á‰°áŠŁáˆ‹á‹ˇ á‰¦á‰łáŠ¦áˆ áŠ á‹áˆ˜áˆŻáˆˇáŠ•á¢
- ካቾ "Removed Handling" drop-down menu handling type áˆáˆ¨áŒ˝á¢
- Remove Overlays
- Keep Overlays
- Move to Removed Folder
በspreadsheet á‹áЍá‹áŠ áˆ˜á‹ˇáˆ°áˆŤ á‹Źá‹ˇáˆˆá‹á£ በየተለየ ናዠoverlays የንá‹áˆ˜á‹ˇ የውá‹áˆ á‰°áˆŞáˆ áŠ“á‰ľ ካáˆá‰˛ áˆ˜áŒ“á‹˛ á‹Šá‹Ťáˆľ የውá‹áˆ የውá‹áˆ አባá‹áŠ“á¢
-
ንconnector Secure ንáˆá‹ˇáŠ«á‰Ą የውá‹áˆ checkbox áŠáˆŠáŠ áŠ á‰ĽáˆŽá¢
ዏተቾáŠáˆ á‹áŒĽáˆ¨áˆ የተለየ ውá‹áŠ“ የውá‹áˆ ዏቲ á‹Źá‰ľáŒˆá‰Ą data á‹Źá‰ľáŒˆá‰Ą á‹á‰ľáˆŽ ውና connector end point ከáˆáŠ•á‰ľ á‹áŒ á‰ŁáˆŠá‰ľ á‹áˆŤá‰ľá¢
ከáˆáŠ•á‰ľ ናቾ ካáˆá‰˛ ዏá‹áˆ˛á‹áŠ“á‰ľ á‹Źá‰ľáŒˆá‰Ą ውውና data á‰ á‹¨áˆŤá‹ŠáˆŠá‰ľ ዏá‹áŒ‹áˆ á‹ŤáˆŽáˆ á‹áŠ¨áŠ“á¢ - በ"Title Column" áˆá‹•áˆľ á‰łá‰˛á£ áŠ«á‰ľ drop-down menu title column áˆáˆ¨áŒ˝á¢
- በ"Latitude" áˆá‹•áˆľ á‰łá‰˛á£ áŠ«á‰ľ drop-down menu Latitude column áˆáˆ¨áŒ˝á¢
- በ"Longitude" áˆá‹•áˆľ á‰łá‰˛á£ áŠ«á‰ľ drop-down menu Longitude column áˆáˆ¨áŒ˝á¢
-
"CREATE SHEET CONNECTOR" button áŠáˆŠáŠ áŠ á‰ĽáˆŽá¢
በLayers panel የኣንቾ ታቲ ናቾ "LAYERS & DATA" áˆá‹•áˆľ á‰łá‰˛á£ connector á‰°áˆľáˆáˆ“ ከáˆáŠŤáŠ“ á‹¨áˆŤá‹Šá‹Ž á‹Źá‰˛á¢ áŠ“á‰ľ áˆ“áˆŤá‹ˇ ናከá‹áŠ“ points በካáˆá‰˛ áŠ¨áˆŤáŠ¨áˆáˆľ ዏቲá¢
Last updated