Date Field in custom module

[kingjatin]

Hi All,

I have a custom module, I have 2 date fields into that module.
the name of the first date field is " case start date" and the name of the second date field is " Case end date"

Now I want to implement that the date that the user has selected for the Case end date should NOT be prior to the case start date...

Please help me in this regard as I want to implement this functionality asap and I know it is a bit tricky functionality but I know nothing is impossible for the Sugar heros....

Thanks guys

[davidboris]

Hi,

Extend the vardefs.php of you custom module and add following code for the field "case start date"

 'validation' => array('type' => 'isbefore', 'compareto' => 'CASE_END_DATE', 'blank' => true), 
  

[kingjatin]

Hi,

I have tried it but it is not showing any response once I save the record.

Pls Help.

Thanks

[davidboris]

Hi,

After changing the vardefs(extended), you need to repair extensions and quick repair and rebuild cache to take effect of your extension.

[kingjatin]

Thanks a lot man !! it was awesome, it worked u r the Champ...



Now can you please help me that I have a custom module and once I create a new Resource I need to auto populate some fields based on some pre entrered records that I have in the database and then will fill the rest of the form..

Please help.

Thank again Man ....Cheers for the good work !!

[davidboris]

Hi,

I dint understand your requirement much.
But, to pre-fill some data from other module(parent module) you need to do some custom code.
Write conditions in view.edit.php and assign those values to the fields you want to show in edit view of child module.

If, there is no specific conditions to satisfy, you can create a non-db(extend vardefs again) field which gets the value of a "related" module.

[kingjatin]

Hi,

To give you my requirement more clearly...actually there are two modules that I have made in Sugar CRM.

1) Employee Database
2) Resource Management

And there is NO relationship between these two modules...these two custom modules are independent but share the same sugarcrm database with different tables.

Now there are few team assistants of each team who fill all the required data in the Employee Database say for eg. the Emp ID, First Name, Last Name, Email ID, Phone Number, Region Assigned to etc etc..

Now I want that whenever anyone who is creating up the data in the edit view in the Resource modules and needs to fill the data for lets say Joy, then once he has typed Joy then all the fields that are related to the Joy in the Employee Database tool should get populated in the resource edit view with some extra fields that would be filled by the person and then can save the record in the resource module.

To be short we can put a default value against the array fields in the resource module according to the name or the ID entered and then we can fill the rest of the details and can save the records.

The reason why I am asking for this functionality is that the user does not need to enter the same information everytime when we already have most of the details entered in the database via other module...

Please help and let me know if you need more clarity over the same. But I am pretty sure this is achievable in php and mysql but I am not sure about SugarCRM.

Thank you

[kingjatin]

Hi David,

Please let me know of your opinion on the same.

Will really appreciate your advise.

Thank you

[kingjatin]

Hi,

To give you my requirement more clearly...actually there are two modules that I have made in Sugar CRM.

1) Employee Database
2) Resource Management

And there is NO relationship between these two modules...these two custom modules are independent but share the same sugarcrm database with different tables.

Now there are few team assistants of each team who fill all the required data in the Employee Database say for eg. the Emp ID, First Name, Last Name, Email ID, Phone Number, Region Assigned to etc etc..

Now I want that whenever anyone who is creating up the data in the edit view in the Resource modules and needs to fill the data for lets say Joy, then once he has typed Joy then all the fields that are related to the Joy in the Employee Database tool should get populated in the resource edit view with some extra fields that would be filled by the person and then can save the record in the resource module.

To be short we can put a default value against the array fields in the resource module according to the name or the ID entered and then we can fill the rest of the details and can save the records.

The reason why I am asking for this functionality is that the user does not need to enter the same information everytime when we already have most of the details entered in the database via other module...

Please help and let me know if you need more clarity over the same. But I am pretty sure this is achievable in php and mysql but I am not sure about SugarCRM.

Thank you

Any suggestion for the same....at least let me know if this is achievable or not? I think we can have a healthy discussion over this topic...

Where are the Sugar heros?

Thanks

[kingjatin]

??? Any Help Please...............