I'm currently designing a form that includes services offered at various times of the year, sometimes overlapping. For instance, we offer a Full Calcium service from April to May, followed by Specialized Services from May to August. I'm using radio buttons to display these options, and I'm wondering if there's a way to hide the Specialized Services option until it becomes available based on the selected timeframe.
Question
Question
Replies
Hi Kyle, I assuming you want to hide the Radio button (Full Calcium service), not a selectable value within the radio button, or a section on the form.
Create a Number fields on your form that has this formula =MONTH(NOW()) (you can choose to hide this.) THis will populate with the current month in number form when the form opens. Jan = 1, feb = 2, etc.
In your rule to hide your radio button, you could try one of these below
Show (Full Calcium service radio button or Section) "When all" Month is greater than 3, Month is less than 6
Show (Full Calcium service radio button or Section) When any Month = 4, Month = 5
Hope this helps
Thank you for your input, Steve! I appreciate the suggestion—it's quite clever. However, my current focus is on concealing specific choices within a radio button group. In past years, I used to dynamically adjust choices based on seasonal availability. Unfortunately, this caused issues in reporting as selected values occasionally appeared as blanks. I'm exploring a new approach to dynamically hide choices while avoiding the reporting inconsistencies we encountered before.