Hi

Are any plans to have a calendar control field on the database? we would very much like to keep records on dates of birth and have the facility to query this field to establish which team our young members play for...eg  under 11s.....under 13s etc...at the moment i would be asking each subscription to  select from  a drop down box and select group.... and then change it on renewal of subscription.. it would be nice if i could automate this process......

Your thoughts....

Regards

Ian 

 

Ian,

 Definitely, we have a date field type in our plans, it should make it into one of the next few releases.
 

---

Dmitry Buterin, Chief Apricot

Hello:

Analysis has started on this, so we are moving this to the roadmap.

As always, any suggestions that you have for this feature are greatly appreciated. You votes will also help to us prioritize alongside the other suggestions.

 

thanks for this,,,,,will make my life easier.... i like the way you guys listen to your customers...great service!! would still like to see the facility to display a much bigger picture on the database profile this way i do not have to duplicate our playerprofiles.

 

keep up the good work

 

Ian

Yes, larger pictures are absolutely on our list - I will re-check if we have a separate thread on that and create one if not.

---

Dmitry Buterin, Chief Apricot

Add a date field to the in the membership field. This way we could quickly add a date that is uniform (for search criteria)

We have a free membership that people can sugn up too then once they have been on a training course (nothing to do with our site this is an affiliate)  We then then upgraded as part of their package. I would thus like to put the date in one of the fields of when they have been approved for membership. Also would like to put another date in their record, this date reffers to when we invoice the affiliate for payment. 

This thread has been quiet for some time.  Is a date control field still on the list ?

It is still on the list, but we keep postponing it for the sake of other more pressing requests.

Were just reviewing if we could include in 3.3 - and it did not make a cut again, sorry.

---

Dmitry Buterin, Chief Apricot

We have added this feature to our Top 50 for the year. Our goal is to complete this as part of our releases in 2010.

We'll keep you posted on the progress of this feature. As always, you can still leave suggestions and ideas for how you might use this feature.

Not sure if this has already been mentioned, but having a DATE field type in the custom database fields and custom event registrations would be very useful.

I'm not sure if anyone else would be interested in this feature, but would it be possible to add a calendar view pulldown as an option when adding a new Membership Field? You have pre-defined fields for States, Provinces and Countries. How about adding a pre-defined calendar box similar to what is available with the Member Since or Renewal Due On date boxes.

We track other date specific data and having the calendar view to pull from instead of manually typing in the date would make things flow much smoother, and add consistency among everyone that enters the information.

I hope this makes sense and I'd be interested to see if anyone else out there would/could use a function like this.

 Thanks. 

---

Larry

Yes, this makes total sense - what you are talking about is the ability to add custom fields of 'date' type which we do not currently have, though it is in our plans. I will merge this thread into existing one. 

---

Dmitry Buterin, Chief Apricot

Thank you Dmitry. I tried doing a search before I posted this as I figured it had probably been brought up in the past. Apparently I didn't search well enough!

I'll be looking for a future update with this new feature! 

---

Larry

Any progress on this request for a straightforward DATE field? This thread is ageing for 2 years now.

We absolutely need this type of data field for our records, in order to calculate lapsed recurring donors (as there is no recurring donation feature available in Wild Apricot).

Please provide us an update, many thanks!

Allan, so far we have not been able to schedule this one into a release because of the backlog of other things which seem to be more common/have more requests, sorry. 

---

Dmitry Buterin, Chief Apricot

How can we get this onto a schedule? Is there a link to an existing wish list item?

We would like to see a date field also in membership fields so that we can create related reports.

What kind of reports? I would really appreciate examples/samples 

---

Dmitry Buterin, Chief Apricot

I would find a date field type very useful in the custom membership fields area.  Right now, I can only choose a text field when I need the member to enter a date, and the formats they enter are very inconsistent which makes searching nearly impossible.

Another vote for a date field.  we have no way of capturing birth dates which are extremely important for our business.

Our organization has an immediate need for a date field option for member field settings. IRS regulations require us to maintain member military service dates (start of service/end of service) and various other date specific information for reporting under IRC 501(c)(19) [veterans’ organization status] and to maintain eligibility to receive tax-deductible contributions under IRC 170(c)(3).

We have tried to use the available text field; however, even though provided format guidance, members do not enter the dates correctly. Therefore, advanced searches in WA and manipulation of exported spreadsheets are difficult at best.

I believe this has been a topic of discussion in the past, but is still unresolved. I would think other WA customers could benefit for the addition of a dedicated date specific data element (with a popup calendar).

The addition of the date field would make reporting effortless.  Anyone else need this data field?

---

Mike Ranger
USARA

I'm finding myself increasingly frustrated by the small things that you are missing in your system.  Things that, I know as a programmer, would be incredibly simple to do and yet you still don't do them, thereby hampering and harming your system, which overall is very good.

The latest discovery is that you have been talking about adding, for three years... THREE YEARS!!! the most simple of things - a darned date field on the membership database...  I'm sure I'm not the only one sitting here scratching my head in wonder that you cannot manage to get a date field added to the database in three years...

It has so many uses. Date of birth, expiry of insurance certificate, reminder for something... don't you think it's kind of embarrassing to  have to say, after three years, that you still haven't been able to add this?

I'm really sorry for that but it's always a matter of balance - we have a lot of things to do all the time and each time we need to sacrifice one thing to make another. 

---

Evgeny
Product Design Team

I definitely want to add my vote to the requirement for a DATE format on custom fields in the database. I recently implemented Wild Apricot for the Australian Register of Homoeopaths and they are very dependent on certain dates. Their registrants need to have up-to-date insurance and 1st aid certificates to be able to gain rebates for their clients from private health funds. So they need the ability to filter for date ranges so that they can send out timely reminders. This is totally impossible at the moment.

 

As an extension to this requirement, having an 'alarm' facility that functions similar to the membership renewal and could be switched on against selected date fields, with flags that pop up and optional automated (but editable) email messages sent to the member and/or administrator, would be brilliant.

Another issue around date fields at the moment is the format they present in. Having the time stamp as well as the date displayed on fields that have been uploaded from date fields out of Excel is annoying as it clutters up the field and makes it quite unreadable.

 

Also, the upload process of date fields is not very robust. Even when setting the date format in Organisation Details settings, uploaded dates do not behave accordingly. Recently I had to perform three uploads fo the same fields because when uploaded as TEXT fields with slashes (/) the fields in Wild Apricot would reset themselves to dates and change the uploaded values from DD/MM/YYYY to MM/DD/YYYY plus time stamp which is not a used format in Australia. When I tried the format DD-MMM-YY, they reset themselves to YYYY-MM-DD, again with time stamp. Finally I gave up and used DD.MM.YYYY to have a pure text field. However, this format does not suit the purpose very well.

 

 

I am aware that you are very busy but I agree with some comments that DATE fields are something very fundamental and their unavailability takes a way from a great product!

 

Best regards,

 

Vera Externest

Any planned date for this yet?  I'm new to the site and this is an important feature for us.  We need to be able to report on and verify eligibility of our athletes based on birthdate.

---

L Normand
Ottawa Fusion Volleyball Club
Director of Communications