Hello If anyone could help me it would be much appreciated. I have bubble.io calculate the distance between two locations in miles, I created API using sheety to call my google sheets list of milages in ranges (101 to 200) (201 to 300) , then a following column in Cent per miles which increases as the milage ranges grow larger.
My question is how would I use the miles value to search the google sheet api to find the correct range column, in order to X by the correct Cent per miles for that trip miles?
