Hi,

I'm in the process of building a bilingual CB site (French and English). During registration, users should select their month of birth, so if language is French, I'd like to show "Janvier" instead of January.

I managed to do so by defining a constant in file "language.php".

My question is this: Based on the month of birth, we later want to create lists of people with birthday in a particular month. If I proceed by allowing French and English, the database will show 24 different months, not only 12.

When creating a list, I would like for example that if "January" gets selected, all users with month "Janvier" get selected as well, or vice versa.

I can see two approaches:

1) I could show numbers for the months (01,02 etc.) However, I'd prefer the more elegant way to show "January" and "Janvier", so that's not really an option.

2) When creating lists, I could select "Month = January OR Month = Janvier". However, this calls for errors, so it's also not really an option.

What I'd like to see is this: When a user selects a month, could there be a second field related to it that would be populated depending by the selection?

For example, if MONTH = January is selected, then a hidden field MONTH_NUMERIC would be populated with 1. And also, if MONTH = Janvier is selected, MONTH_NUMERIC would be 1. In the monthly reports for birthdays I could then make reference to MONTH_NUMERIC, and I would be language independent.

Could this be done?

I'm aware that for birthdays this might not be overly important, and I could solve it by only allowing numeric months in English or French. However, I'd like to understand in general if the concept I described could be implemented.

Thanks a lot!

Hi Kyle,

thanks for looking into it. I'm not sure if I quite understand, please help me to clarify it a bit.

All I would need is an additional calculated (hidden) field, where I could define calculation rules like (IF Month = "January" or "Month = "Janvier", THEN "01")

This way, the calculated field would always be "01", no matter if "January" or "Janvier" would be selected.

On a separate note: I'm building a website completely from scratch, CB, CBSubs and an Event Management tool will be core features. I'm building on 1.9, because I need a solid solution up and running within 2 to 4 weeks.

Would you say CB 2 is ready for a production environment? I was hesitating especially because of concerns that plugins might not be compatible for some time.

Thanks again for looking into it.


Gert

Hi Kyle,

thanks a lot for clarifying!

Here's the story behind it: I'm creating that website for a group of people who are not very tech-savvy. Every month they will have to pull a list of members with birthday of that particular month. My concern was that they will always have to think of two parameters for one month (Janvier and January), but I understand now that this is not the case. The filter will be _UE_JANUARY anyway, no matter which language is selected.

That's pretty cool and just answered my question! Thank you very much!!