195
Hi this is Bharath, I have 1 option set with q1,q2,q3,q4 options.i have start date and end date fields.i have to populate start date and end date fields based on q1,q2,q3,q4 using javascript.
example q1 starts at 01-06-2018 and ends at 31-08-2018.like this i want to populate date fields.
Thanks,
Bharath.
*This post is locked for comments
There are many different ways to do this, but the following logic works pretty well. Of course you can make it better for your needs:
If you set the values of your option set to 1,2,3,4 corresponding to Q1, Q2, Q3, Q4, you can use the following:
var selectedQuarter = Xrm.Page.getAttribute("new_quartercode").getValue();
var startMonth = selectedQuarter * 3 - 2;
var endMonth = selectedQuarter * 3;
var lastDayOfMonth = 30;
if (selectedQuarter == 1 || selectedQuarter == 4)
lastDayOfMonth = 31;
var startDate = new Date(yearValue, startMonth -1, 1);
var endDate = new Date(yearValue, endMonth -1, lastDayOfMonth);
Xrm.Page.getAttribute("new_startdate").setValue(startDate);
Xrm.Page.getAttribute("new_enddate").setValue(endDate);
Hope this helps.
In addition to that you can set date file using following syntax
Xrm.Page.getAttribute(‘fieldname’).setValue(new Date());
Hi bharath,
You can try something like below code and call function on change of optionset.
Share
Report
All responses (
Answers (
function getOptions() {
var optionset = Xrm.Page.getAttribute("provide fieldSchemaName here");
if (optionset != null) {
//Get OptionSet Text
alert("OptionSet Text :" + optionset.getText());
//Get OptionSet Value
alert("OptionSet Value : " + optionset.getValue());
// Option 1 Switch using optionset value
switch(optionset.getValue()) {
case 10000:
setDate("pass startDate","pass EndDate");
break;
case 10001:
setDate("pass startDate", "pass EndDate");
break;
case 10002:
setDate("pass startDate", "pass EndDate");
break;
case 10003:
setDate("pass startDate", "pass EndDate");
break;
default:
break;
//Option 2 Switch using optionset text
switch(optionset.getText()) {
case Q1:
setDate("pass startDate","pass EndDate");
break;
case Q2:
setDate("pass startDate", "pass EndDate");
break;
case Q3:
setDate("pass startDate", "pass EndDate");
break;
case Q4:
setDate("pass startDate", "pass EndDate");
break;
default:
break;
}
}
}
function setDate(startDate, EndDate){
Xrm.Page.getAttribute("provide fieldSchemaName here").setValue(startDate);
Xrm.Page.getAttribute("provide fieldSchemaName here").setValue(EndDate);
}
Thanks
Justin Jose
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
