Restricting choices in a Text - Multiple Choice field

Question

In the app I am working on I have a Text - Multiple Choice filed with years listed on it that a user is to select from when creating a request. My client is asking that I limit that field so that a user can only select the current year or a year in the future. Obviously I can remove the past years as options for now, but short of someone manually going in every year and removing the previous year, the only other way I can think to do this is to create a child table with years as the records and create a report to use in place of the standard record picker that restricts the years listed to the current year or after. Does anyone have another idea?

------------------------------
Chris Swirtz
------------------------------

SSNJeffP · Answer

You can use 'another field' as the source of the list. I believe you can just use a formula text or numeric field to generate the list of valid dates and populate the multiple choice field from that.

------------------------------
Jeff Peterson
------------------------------

Sign up

Login to the community