As shown on the image under, I’m creating a feature where the user could write some personal comments about a specific location called a Spot. For each Spot, you can have different Notes. And he could associate markers and shapes to each note. The Mapbox plugin looked perfect for it.
So for every data type call “Note” you have a list of address. I know I can also create a Data Type “Marker” and link it to an OG-Note but it is far less efficient.
I know I can do that, it’s the easy way. But as I said in the post it will decrease the application performance. Working with list is a great tool to improve the efficiency of our apps so it would be to bad to not use it simply because it’s easier to dev.
That’s why I’m asking if there is a way to do it, it might help others too @ZeroqodeSupport
What makes you believe that having a single list of all addresses is going to be slower? It is the same thing as doing a search for Notes, the only difference being your map will have a search for a data type it can use to populate all of the addresses you want it to.
Only when those lists are less than maybe 20 items or so. I always taught my students and I’ve seen many experienced developers use the same approach, which is, if the list is more than 20 items do not use the list as it is slower. Lists as a field are a bit more performant when the list of items is less than 20 items, but it is less performant when there are more than 20 items. Some developers might disagree with the number of 20, as I’ve seen some say they go up to 50 items but, based on my experience, 20 is the number I use to gauge whether or not to use a list field.
If I had to argue about that : when an app is searching for a data type, it’s loading all the fields of that DT. It looks weird for me to create a DT only to store one field. Because if we compare :
50 Data Types “Marker-Adress” and its few fields (created by, date of creation, date of modification, marker-adress, OG-Note). So 50 DB x 5 fields = 250 hundred items to load
I think you may have missed the point. Don’t use your notes as the data type to load, create the data type for addresses and have a field associated to the notes and spot.
Don’t forget the created by, date of creation, date of modification, marker address and OG-Note for each of the 50 Notes, plus the created by, date of creation, date of modification for the OG-Notes when you are referencing the OG-Notes field from the Notes data type, if you are referencing any values from it, otherwise it is just a unique ID.
Then the list field would be fine
What you likely want to do is save via custom state the step 1 which is the spot (which I assume your data type for Spots has a list of notes as a field which is related to the notes data type), then have a custom state that is a list of addresses that is populated using the selected Spots List of Notes List of Addresses. Then your map uses the custom state list of addresses.
In my case the Data Type “Note” will be loaded anyway so that’s why I did not count the others fields
Yes ! So this is exactly what I have done (I didn’t wanted to explain the custom states in my first screenshots so that’s why I used raw data) . But it doesn’t work :
We’ve reviewed the images and the error message you provided. It seems the issue stems from the “Marker type” field in your action. Currently, you’ve selected ‘geographic address’. To resolve the issue, you need to select a type of marker from your database and use the corresponding fields available there [image].
Please try making this adjustment and let us know how it goes. If you have any more questions, feel free to ask.
Thank you once again, and I look forward to your reply.
Thank you for your message, and I apologize for the delayed response over the weekend.
Regarding the “Geographic Address” field, in your table you must have a field of type geographic address since you are adding a list of Markers, and each marker can have only one address.
Could you please provide more details about your goal with the “list of geographic addresses”? Understanding your use case more clearly will help us provide more accurate and helpful responses.
Thank you again, and I look forward to your reply.
So when the user opens a spot I want to show on a map all these specific places, all the markers link to that spot.
No I made 2 fields on the Data Type “Notes” so that you can see my problems :
I want to keep only one field the address-marker-list. But as you can see on the image under, your plugin doesn’t propose the list of addresses field, only the single address field :
We apologize if our previous answer wasn’t entirely clear. For the “Add list of Markers” action, you’ll need to use a “geographic address” instead of a “list of geographic addresses”. As each map marker, by design, typically represents a single location with one address, and it can’t take a list of addresses for 1 Marker.
We hope this clarifies things. Please let us know if you have any other questions or need further assistance.
Thank you for your message and your understanding.
The “Add list of Markers” action is indeed designed to accept one geographic address per marker. For your use case, you might consider a workaround such as adding separate fields for the ‘note’ and ‘spot,’ which would allow you to filter them as needed.
Additionally, you might find the Cluster Markers functionalities useful. With them, you can use the Cluster as your “Note” and the individual markers within the cluster as your addresses. Clusters also perform faster, ensuring seamless functionality even with large datasets.
Could you please test these functionalities and let us know if they meet your needs?
Thank you once again, and I look forward to your reply.
The error you’re encountering could be related to how the data is parsed in the action. To better understand what might be going wrong in your case, could you please provide more details about your use case?
Specifically, could you share the exact data present in the Note table within your “App Data”? Please ensure there are no empty fields or data mismatches.
Additionally, could you tell us if you’ve implemented any constraints in the source? Sharing screenshots of these constraints would be very helpful.
It would also be greatly beneficial if you could record a step-by-step video starting from when you open the app and proceed through the workflow related to “Add list of Markers.” Please review each action in the workflow and all associated data (image), and also check the browser console for any other error messages.
These details will greatly assist us in understanding what might be causing the issue and in providing a more accurate answer.
Thank you once again, and we look forward to your response.
Thank you for reaching out and providing the details.
It appears the error message you’re encountering is related to the format of the numerical data. Upon reviewing the images you shared, I noticed that all the number data are formatted with commas[image] instead of dots[image]. Bubble DB requires numerical entries to use a dot as the decimal separator.
Could you please check if any scripts or plugins might be altering the number formatting? Additionally, could you verify and make sure that the values in your database use a dot instead of a comma?
Thank you once again for your cooperation, and we look forward to your reply.
