Announcements
I'm working with annual reports, so I have multiple tables where one of the fields needs to say for what year this report is for. I'm not sure what data type is best for this.
How would you handle this?
Hi @ingovals ,
Most of the time I have done this I end up utilizing 1 of 2 options:
I do see that someone created a web resource to remove the comma as well on the UI if you do utilize a number field.
https://vjcity.blogspot.com/2020/10/remove-comma-from-number-fields-in.html
Reading through your post, I feel that there is a limited amount of reporting years to choose from, and you know which years you want your users to input. Therefore, I would use a choice column and put only valid reporting years into the choice box.
I put a screenshot below of a relatable experience. It shows how I used a choice column to control the record of Employee's start times. Employees are only allowed to record time in 15 min increments, and I've input all the allowable start times. Employees get to select from a dropdown box their start time.
I hope that helps.
Best of luck,
Joe
In the past have used a Lookup. And on the list of values had a Text (name field) value and Number field, the number is there just in case you decide you want to add or subtract a year from the current value it can then be done without having to covert the text to a number to do the maths.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 519 Most Valuable Professional
11manish 489
Haque 327
