Good afternoon all.
I am very new to Bubble.io and currently loving it. I am in the final strokes of putting together a Fishing League where I can record the Location of the fishing, the fish caught, its weight range i.e. 1>5lb, 5>10lb , who caught it and an image of it.
I have a number of datatypes where data is stored and extracted from, however I am stuck trying to working out the calculations side of things.
When I record a catch I would like to have a points scored retrieved from a googlesheet I have connected to.
This googlesheet has 7 columns, Fish (Name), 1>5lb, 5>10lb, 10>15lb, 15>20lb, 20>30lb and >30lb. each fish has a different points awarded to each weight. I can Add rows to this sheet, but cannot retrieve data.
I have a page with 2 drowpdowns, Type (with a list of fish types) and Weight (with a list of weight ranges). I also have a text input that I would like to display the correct point awarded for this fish from the googlesheet after Type and Weight have been selected but for the life of me I cannot work this out.
Apologies for the verbose explanation.