Compare two date fields and not allow save

[chrislynch8]

Hi,

I want to compare two custom date fields. If date2 is before date1 then alert the user and do not allow the save.

I have tried using the isafter validation in the vardefs.php but that is not working. I can however use the isbefore validation on date1 but then this show date1 as the issue when it is date2 I need to check..

Any other ideas how this can be achieved. I have a custom view.detail.php where I can also check the dates and trigger a JavaScript popup but I cannot see how to then redirect the user back to the edit view after they press OK on the popup..

Rgds
Chris

[mikesolomon]

Hi,

I want to compare two custom date fields. If date2 is before date1 then alert the user and do not allow the save.

I have tried using the isafter validation in the vardefs.php but that is not working. I can however use the isbefore validation on date1 but then this show date1 as the issue when it is date2 I need to check..

Any other ideas how this can be achieved. I have a custom view.detail.php where I can also check the dates and trigger a JavaScript popup but I cannot see how to then redirect the user back to the edit view after they press OK on the popup..

Rgds
Chris

The way I have done it is include a custom js file which has a function check_form that is a copy of the main check form with additions to compare the dates

[chrislynch8]

Where can I find this check form?

Rgds
Chris

[mikesolomon]

Where can I find this check form?

Rgds
Chris

Chris

/include/javascript/sugar_grp1.js

Here is my modified version

As well as doing some other checks it also prevents a problem with IE where if you click save twice you can end up with duplicate records

function check_form(formname) {
	// check time on save
	if (document[formname].check_time_flag == undefined) {
	} else {
		if (check_time('date_start','date_end',formname) == false) return false;
	}	
		
	
	
	if (formname.match(/QuickCreate/)) {
		
		// use original
			if(typeof(siw)!='undefined'&&siw&&typeof(siw.selectingSomething)!='undefined'&&siw.selectingSomething)
		return false;return validate_form(formname,'');

	} else {
	

	if (typeof (siw) != 'undefined' && siw
			&& typeof (siw.selectingSomething) != 'undefined'
			&& siw.selectingSomething)
		return false;
	if (validate_form(formname, '')) {
		if (document.forms.length > 0) {
			for (i = 0; i < document.forms.length; i++) {
				for (j = 0; j < document.forms[i].elements.length; j++) {
					var field = document.forms[i].elements[j];
					if (field.type == "submit") {
						if (field.value == "Save") {
							// field.style.display = "none";
							field.disabled = true
						}
					}
				}
			}
		}
		document[formname].submit()
		// return true;

	} else {
			return false;
	}
	}
	

}

[chrislynch8]

Thanks Mike,

I'm completely lost. If found the file and I found the check_form function in it. In your code where you are checking the time on save. How is it doing that - I could find anything regarding check_time in the file..

Rgds
Chris

[mikesolomon]

Thanks Mike,

I'm completely lost. If found the file and I found the check_form function in it. In your code where you are checking the time on save. How is it doing that - I could find anything regarding check_time in the file..

Rgds
Chris

Sorry to have confused you

The standard sugar function consists of if(typeof(siw)!='undefined'&&siw&&typeof(siw.selec tingSomething)!='undefined'&&siw.selectingSomethin g)
return false;return validate_form(formname,'');

all the rest is mine

the check_time is another custom function

what it does is compare start & end times and if end time is less than start times it returns false and gives an error message

hope that helps

[nileshdave]

Hello Chris,

You can try out LogicHook feature in SuarCRM. You can compare those date fields on "Before Save" event in Logic hook

To know for regarding Logic Hook Please follow this LINK

Hope this helps to you.

Regards,
Nilesh Dave