I am creating an expense tracker / mileage logger and have one table to define reimbursement rates which change periodically based on fuel price fluctuations. So each new rate is defined in the “rates” table with a fixed start and end date.
Now I need to have the valid rate applied when a user logs a trip based on the date they nominate as the date of travel in the mileage log table.
The periods of validity for each published rate is not set and can vary from a few days to 6 months or even longer.
I am using glide tables only.
Any suggestions or pointers to existing show cases / examples would be appreciated.
Appreciate guidance here.