Forum Discussion

SergioSergio's avatar
SergioSergio
Qrew Cadet
8 years ago

pull information from a field in another table from the respective field based on the month of the year

I have two tables. "Processing" and "Monthly Interest Rate". I have a field in the processing table that is called [interest rate] I have fields in the "interest rate table" called [JAN 2018], [FE...
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
You can set the Key field of your interest rate table to be a date field of the first of the month. Then in your detail table make a formula field of

FirstDayOfMonth ([My date field])

Them use that to make a relationship to the interest rate table and the lookup the interest rate.