Forum Discussion

JeremyCohen2's avatar
JeremyCohen2
Qrew Trainee
6 years ago

Searching for text in field name within formula ie. 2019, 2018, 2017 in field name

I am trying to make a formula that pulls through historical data to find which one to utilize.  Currently I'm using dates but I can see multiple areas where this is very useful.   In excel it would...
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
There is no equivalent function but you can also do something like this,


Case(Year([My Date Field]),

2018, [Rate 2018],

2019, [Rate 2018],

2030, [Rate 2018])


But that is not really a Quick Base way of doing things. There are better ways with having a table and then a look up field. Perhaps if you explain what you were trying to accomplish we can suggest a table structure that would do that more elegantly.