We are making 1 analyse of fruit (for example Apples):
Unique number for example: “101”
This fruit is checked every month again during storage in the coldstore
During harvest we check in excel sample 101 and to the measurement (firmness/internal…)
these measurements are send by Zapier to Bubble using a web hook based on the unique number (101)
So far all ok.
Every month we check this 101 again and again which will result in overwriting the earlier data in bubble. (15 columns)
I need to calculate the difference between the measurement readings of nov and dec and jan…
or create a charts or calculate averages of variety in Nov and…
My question is:
How to organise this in a database?
making new unique sample numbers like:
101 Basic values (10-20 columns) 15 columns (harvest) 15 columns (January) 15 columns (February) .
102 Basic values (10-20 columns) 15 columns (harvest) 15 columns (January) 15 columns (February) .
or are there better ways?
Your help is much appreciated!!
thanks a lot in advance!