Skip to main content
Question

Restricting choices in a Text - Multiple Choice field

  • Sep 7, 2022 4:14 PM UTC
  • 0 replies
  • 321 views

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
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • Qrew Colonel
  • Sep 7, 2022 4:28 PM UTC
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
------------------------------