Custom Fieds in Meetings Module

[chrislynch8]

Hi,

I've created three custom fields in the Meetings module using the Sugar Studio.

1. fdc_review_c - YES/NO dropdown
2. fdc_reviewdate_c - Date Field
3. fdc_appointment_c - YES/NO dropdown

I then added the fields to the Edit and the Detail views using Studio, I save&deploy as I go.

I schedule a new Meeting and I can fill in the required information into the three new fields also, when I press save the custom fields are not holding the data.

I checked the database and the meetings_cstm has been created and it has the three fields but no data.

I have set the logging to debug and I can;t find any reference to my custom fields if I search for them...

In the log there is no mention of the meetings_cstm table in a query.

Is this a bug??? I have custom fields for my Calls module and when I fill them in they work and the calls_cstm table has an insert statement in the Log file.

I am on Version 5.0.0j

Rgds
Chris

[kuske]

In most cases as yours it is no bug but a problem of rights.
I suppose you have unix system.
SugarCRM must be able to create new directories, esp. /custom/history/... and /custom/modules/...
If not, some problems with custom fields can occure.

[chrislynch8]

Hi,

This is a unix system and because its a dev instance I have all permissions to 777 for both the database and the root folder.

If it was permissions then, it wouldn't have created meetings_cstm nad I would have had an error in the log. The fact that it is not even tryin an Insert statement for the _cstm table make me think its a sugar issue.

Rgds
Chris

[kuske]

Which version do you run? I cannot find any 5.0.0j

[chrislynch8]

Sorry it is 5.0.0i.

[kuske]

It's not SugarCRM causing this issue....
I took a brand new 500i installation and created 3 new fields for meetings as you described (YES/NO Dropdown = checkbox_dom)
And it worked fine.
The creating of the 3 fields generated some files in the new installation which I attach here in a zip-file.

the fields_meta_data tabel looks like this:

 
"id,""name"",""vname"",""comments"",""help"",""custom_module"",""type"",""len"",""required"",""default_value"",""date_modified"",""deleted"",""audited"",""massupdate"",""duplicate_merge"",""reportable"",""ext1"",""ext2"",""ext3"",""ext4"""
"Meetingsfdc_review_c,""fdc_review_c"",""LBL_FDC_REVIEW_C"","""","""",""Meetings"",""enum"",255,0,"""",""2009-10-27 15:31:12"",0,0,0,0,0,""checkbox_dom"","""","""","""""
"Meetingsfdc_reviewdate_c,""fdc_reviewdate_c"",""LBL_FDC_REVIEWDATE_C"","""","""",""Meetings"",""date"",,0,"""",""2009-10-27 15:27:19"",0,0,0,0,0,"""","""","""","""""
"Meetingsfdc_appointment_c,""fdc_appointment_c"",""LBL_FDC_APPOINTMENT_C"","""","""",""Meetings"",""enum"",255,0,"""",""2009-10-27 15:31:41"",0,0,0,0,0,""checkbox_dom"","""","""","""""

[chrislynch8]

Hi Thanks,

I've got this working now. Something was just wrong with this instance, I was unable to even create a custom field for another module, so I recreated the instance and all it OK and working now.

Rgds
Chris