Feature Requests

[V.S.]

I have a few feature requests which would be very useful in HanDbase...

1. A Summary or Report field that would display the specified value (average, sum, highest, lowest, etc.) of any Database's selected field.

2. Date criteria for Conditional field. Eg. IF date is less than 30-Jan-2011 the value = x Else value = y OR IF date is in the specified range the value = x Else value = y

3. Field for day of the week like Monday, Tuesday, Wednesday, etc. with default value as current day. Even if there was an option to display the Date with the day of the week it would be very helpful.

4. Filter for Current Week or Current Month. There is a filter for trailing week/month and coming week/month but no filter for current week or month.

[dhaupert]

I have a few feature requests which would be very useful in HanDbase...

1. A Summary or Report field that would display the specified value (average, sum, highest, lowest, etc.) of any Database's selected field.

Thanks for your requests- as you saw in another post, this is done a different way currently in HanDBase. That information is possible, but not to be placed into a value of a field. This is something that I haven't seen requested in a field before, but seems like a useful idea for some instances. I'll consider this for a future major update in the years to come!

2. Date criteria for Conditional field. Eg. IF date is less than 30-Jan-2011 the value = x Else value = y OR IF date is in the specified range the value = x Else value = y

You can already do this, but the value you compare to is entered as a numeric value using this format:
#days since 1/1/1904

To determine this you can make a calculated field having the formula: date field + 0 (outputted to an integer value) and set your date field to the date you're looking for.

3. Field for day of the week like Monday, Tuesday, Wednesday, etc. with default value as current day. Even if there was an option to display the Date with the day of the week it would be very helpful.

This one I've received a few times and hope to implement some day in the future!

4. Filter for Current Week or Current Month. There is a filter for trailing week/month and coming week/month but no filter for current week or month.

[/quote]

These already exist! The option of This Month to date or This week to date are the ones you should be looking for!

[V.S.]

Thankyou for your detailed reply.

The 4th point about the first day of the week or month till date does not give the future days of the week or month in the filter. And if I add the coming week/month to the filter then it gives me 7 futere days or 30 future days. What I would like to have in my filter is the Current week from Monday to Sunday or the current month from the 1st to the 31st of that month only. Is it possible to create this Filter?

[DB100]

If a "Day of the Week" field type were added in the future, it would be nice if it sorted Sun,Mon,Tue,etc, in day order. Currently, I use a text field for "day of the week" which sorts alphabetically. I use a separate integer type Sort field to get the records to sort in the correct order.

[dhaupert]

Thankyou for your detailed reply.

The 4th point about the first day of the week or month till date does not give the future days of the week or month in the filter. And if I add the coming week/month to the filter then it gives me 7 futere days or 30 future days. What I would like to have in my filter is the Current week from Monday to Sunday or the current month from the 1st to the 31st of that month only. Is it possible to create this Filter?

I see your point- sorry. I incorrectly assumed that there weren't records with a date in the rest of the week. I will definitely consider some additional filters for the next time we update the database format of HanDBase (the only time a change like this can be made and reserved for major updates only (eg, 5.0, 6.0, etc).

[patrickwest]

3. Field for day of the week like Monday, Tuesday, Wednesday, etc. with default value as current day. Even if there was an option to display the Date with the day of the week it would be very helpful.

This one I've received a few times and hope to implement some day in the future!

Good to know. I have a database where I still input this manually and I still use spreadsheets as simple flatfile databases in cases where this is important.

Have you looked that the way Excel and Lotus do this?
=CHOOSE(MOD(A2,7)+1,"Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday"," Friday")
or another sheet I use smaller cells so
=CHOOSE(((MOD($P$2,7)+1)-1)+1,"S","Su","M","T","W","Th","F")

I purchased Documents2Go simply to be able to do this with spreadsheets.