Custom Date field that auto-populates

[jeffreyvsmith]

SugarCRM 4.0.0
PHP 5.1.6
MySQL 5.0.27
FC6 2.6.22.4-45.fc6

Wanting to create a custom field for the Cases module that is a date field that has a default value of a week away. For example I want the field's default value to be date --date "`date` 7 days" '+%m/%d/%y'..

Not being a programmer, is this something I can just put in a php file or an html file somewhere?

[kuske]

Hi,
what about creating a custom field with default value in 1 week?

admin - studio - edit a module - cases - edit custom fields - create custom field:

Set
- data type = date
- field name
- field label
- help text
- default value = next week
- audit (to see if anybody changes this field)
...
and save.

edit layout:

add the field to the detail view AND to the edit view (very important because the calculation is done in the edit view).

regards
hk

[jeffreyvsmith]

When you say default value = next week, are you saying to literally type in "next week" or to type the date, e.g. 11/6/2007. I tried entering "next week" in the default value for the field, but when I create a case the box is blank, no default value appears

[kuske]

You must add the field to the Edit View Panel.
Only then it will be set to a date 7 days later (next week).
The Edit View does the real job of initializing.

[jeffreyvsmith]

So, I create the custom field, set the default value equal to "next week". I modify the layout of Cases/Editview. But, when I click to create a case, the value of the field is blank. I can click the calendar icon and choose a date, but I need it to default to a week from the current date when someone clicks new case....Thoughts?

[kuske]

Mmmm, in my installation it populates....
Did you add it to DetailView AND EditView Panel?
The mechanism only works for NEW items, already existing items leave empty.
I do not really know why it should not work in your installation.
Try to create an other new filed of that kind.