Hello Bubble Community,
I’m working on a project involving agricultural commodities and their seasonality data (i.e., the percentage of annual harvest per month for each commodity). I’m seeking advice on the best approach to implement the following features in Bubble.io:
- Data Structure: How should I store the seasonality data? I’m contemplating whether to use a list of numbers (but I’m concerned about maintaining the chronological order of months), or to create a new Data Type specifically for this purpose. Alternatively, should I incorporate fields for each month within the existing commodity Data Type?
- Data Input: For collecting the percentage of harvested volume per month, would it be better to use a repeating group or set up 12 individual input fields? Any suggestions on efficient and user-friendly data entry methods would be appreciated.
- Charting: Once the data is collected, I would like to plot it on a line chart. Could anyone share insights or resources on how to dynamically generate a line chart based on the entered seasonality data?
- Data Validation: I aim to ensure that the total percentage of harvested volume across all months adds up to 100%. What are the best practices in Bubble.io to implement such validation constraints?
Thank you in advance for your guidance and expertise!