Online (Google Spreadsheet), you can use other online databases like mySQL, Airtable, etc.
Spreadsheet
A. Data Process
1. Offline
a. File checking procedure
If the file is not in the kodular assets folder, it will be automatically copied to the assets folder. If the file already exists, it will automatically read the csv file.
b. File copy procedure
I’m using FileTools by @vknow360 to copy and use the File component of kodular to read data (text).
In this example the original source file is in
/storage/emulated/0/bluetooth/Testspread1.csv
(adjust this address to your file), then copy it to the kodular assets folder
After getting the data from the file, the global data is added to the data_csv variable, then each item is added to the list. In this data there are four lists (no, lng, lat, name). Looping data to display markers on the map.
note : number of lists divided by two to get the value used as index to select latitude and longitude to get camera position (optional)
2. Online
a. Retrieving data from google spreadsheet
Edit the spreadsheet url https://docs.google.com/spreadsheets/d/1hFa6HKKEJqTlOphf18JLIbb-wFgHd2M46PFvmFidkzE/edit#gid=0
to https://docs.google.com/spreadsheets/d/1hFa6HKKEJqTlOfhf18JLIbb-wFgHd2M46PFvmFidkzE/export?format=csv
Make sure the sheet is given access permission to view.
b. Data processing procedure
After getting the data from the file, the global data is added to the data_csv variable, then each item is added to the list. In this data there are four lists (no, lng, lat, name). Looping data to display markers on the map.
After clicking on the marker, we get the latitude and longitude information and the name of the place, from this information we add it to the data_place variable to display the details (here we use the bottom sheet and the web viewer)
C. Block additional Procedure
Detail
JSONstring
To simplify writing JSON text format when creating markers
The locations of the application users
are longitude and latitude.
When I have time, I start building it, but I saw your work and liked it, and it helped me a lot as well.
Thank you