[SOLVED] Integer Type Field: Calculate Maximum Value Allowed Based on Calendar Year

Dear support team,

I'd like to be able to set up a field for members to enter the year they enter the profession between 1945 and the current year. For administrative purposes, I would like to calculate the maximum value allowed based on the current calendar year so that I would not have to update the maximum value each year.

This would be similar to the Excel function of year(today()).

I have tried searching the forum and the web but couldn't find any relevant info. Your guidance would be greatly appreciated.

Best regards.

The validation parameters can't do any of that. They're just static checks. Best I can suggest for now is CB Query Field and its Query Validation then use a custom database query to validate its range. It's not ideal, but it should work. Once CB Code Field is developed you'd be able to have custom PHP validation, but that won't be for awhile.

The date fields have calculated range validation, but they'd be forced to supply a day and month as well, but you could hide those inputs using CSS as they'll auto-fill when selecting the year. So that could be a decent alternative.

krileon wrote: The date fields have calculated range validation, but they'd be forced to supply a day and month as well, but you could hide those inputs using CSS as they'll auto-fill when selecting the year. So that could be a decent alternative.

Hi, Krileon,

Do you mean I may by-pass input of day and month using CSS? If so, how can I go about doing that?

In terms of auto-fill, will the system use current day and month or could we default that to a certain date (e.g. Jan 1)?

Thanks again!

Do you mean I may by-pass input of day and month using CSS? If so, how can I go about doing that?

You can hide the month and day dropdowns with the below CSS.


The main issue is the dividers between the dropdowns will still show up. It maybe possible to hide those by changing the font color to same as background color. For example the following.


Another option is to just move the year input after hiding the others.

In terms of auto-fill, will the system use current day and month or could we default that to a certain date (e.g. Jan 1)?

It'll always be January 1st for the month and day.

Perfect! I'll give that a try.

Many thanks!

Hi, Kyle,

I just had to modify the codes a bit to make that work. Below, for your reference, are the final codes -

#cbfv_ID .combodate {
position: relative;
}
#cbfv_ID .combodate .month {
display: none;
}
#cbfv_ID .combodate .day {
display: none;
}
#cbfv_ID .combodate .year {
position: absolute;
min-width: 80px;
left: 0;
}
#cbfv_ID .fa-calendar {
position: absolute;
top: 50%;
left: 100px;
}
#cbfv_ID .fa-eye {
position: absolute;
top: 50%;
left: 120px;
}

For the digits for Year to show up on the Profile, I had to force a minimum width.

Since neither the icon for Calendar nor Eye (visibility) is aligned automatically relative to the drop-down box for Year, I also had to enforce absolute values for both their vertical and horizontal positions.

Hope this helps others who may be looking to make similar modifications.

Thanks!