Hide options in forms

Welcome, @Travis_Groom.

To achieve this, you’ll want to first make your trainings dates a separate table, rather than an ever-growing single-select field. Create a table called “Training Dates”, or whatever your preference. Have a “Date” field as one of the fields in that table, as well as perhaps a description, and any other information fields you might want that help to describe or identify a Training Date. Depending on your setup, you may be able to copy-paste all of your existing training dates from the single-select field they live in now, into this new table. In the end, what you want is a new record (row) for each training date you create and want to allow people to sign up for.

The next step is to create a view in your new Training Dates table (views can be created in the view menu, top-left side of the table) that filters on the “Date” field to show only records "Where Date > is on or after > one month ago". Name this view something that will make it clear that these are only dates that are a month old or newer.

Now the key step – in your registration base (the one with the form in it for your clients to sign up for dates), we need to replace the “Single-select” field you were using for dates with a “Link to Another Record” field. This field will link to your “Training Dates” table, it will allow only one linked record (“Allow linking to multiple records” is disabled) so that one registration belongs to one Training Date, and it will “Limit record selection to a view” >> choose your view that is filtering to show only Training Dates that are a month old or newer.

Now, whenever users go to select a training date from that field in your form, they will never see training dates that are more than a month old.

You can use this same technique to do other things too… such as limiting registrations for a particular date to a cap. You’d create a number field in your Training Dates table that allows you to define a cap for registrants – let’s say it’s 10. Then, you’d create a “Count” field that counts the number of linked registrations. Adjust your filter to ALSO filter on "Count <= Cap". Now registrants will only see options where the date is no more than a month old, AND the cap has not been reached.

Hope that helps!

Thank you so much! That worked perfectly! Been banging my head on this for the last few weeks.

Very helpful! Thanks! I used this for a Meeting slot/topic request form where we only have 2 slot options for each meeting. The form now only shows the available meeting slots as options to select. Fantastic!

I just want to confirm presentation on the form using your technique. I have a rotating set of options that change annually, so your description would seem to work. I usually only have five or six options and they are displayed in a list format. Will the linked records, limited for a view, appear as a list on the form?

Hi there!

Hannes from the miniExtensions team here! Our form allows you to show select field options conditionally. You can set conditions or groups of conditions for each option, displaying them only when the specified conditions in your form are met.