I am building a membership table, where based on number of years they are member the category of membership changes, i.e., if a person is member for less than 5 years then they are bronze category, if they are members for 5-10 years then they are silver category and so on.
How should I create a calculated category field such that it will auto update i.e., if a person has been members for more than 5 years the category field should auto update to Silver.
Thank you
