Help with Editor Date Spinlist

[[email protected]]

Hi,

I'm trying to get the Editor Date Spinlist control to work. So far, not having much success.

I have a List control with a Formview control. One of the fields in the formview is called "rego_expiry". This is from a table in MySQL and is defined as a date field (standard date formats in MySQL are yyyy-MM-dd).

I have setup the date format in the properties tab in Alpha as dd/MM/yyyy. In the formview control, I have configured a display format for the rego_expiry field using date string with server-side format as input and dd/MM/yyyy as output. This displays the date in the format I want. I have also configured the editor for this field to use the Editor Date spinlist.

Now the problem is when ever I click on this field in the formview, nothing happens. When I do an Inspect in the browser, I can see the following error:

TypeError: es.editors[editor] is undefined
a5-43464889.js: if(typeof settings.autoCommit=='undefined')settings.autoCommit=es.autoCommit;es._s=settings;$(this.dialogId+'.'+editorSet+'.'+editor).style.display='';es.editors[editor].edit.call(this,settings.state.value,settings);es.show.call(this,settings.state.value,settings);if(typeof es.editors[editor].show!='undefined'){es.editors[editor].show.call(this,settings.state.value,settings);}},editorSetFromEditor:function(editorName){var edObj=this._EDITOR_EDITORSET[editorName];var es='';if(typeof edObj!='undefined')es=edObj.editorSet;if(typeof es=='undefined')es='';return es;},editorFromControl:function(editorSet,editor,control){editor=editor.toUpperCase();var settings=typeof arguments[3]!='undefined'?arguments[3]:{};if(control.constructor==Array){var value=[];for(var i=0;i<control.length;i++)value.push(this.getValue(control[i]));}else{var value=this.getValue(control);}

The error is pointing to column 152 in the above line, which seems to be the part: es.editors[editor].edit.call(this,settings.state.value,settings).

Originally I was thinking that it was some kind of type mismatch with the date formats. However, I am now thinking the editor has not been properly defined based on the above.

This is how I have setup the editors:
Editor Date Spin issue.PNG


As you can see, I am using two other editors (text and list) which are both working fine.

Help much appreciated.

Cheers,
Greg

[Davidk]

Re: Help with Editor Date Spinlist

What build of Alpha are you using... both 4 digit numbers.

What Format, specifically, do you have in the Server-side "Display Format" property of your Date field? And... in MySQL... is it specifically Date... not DateTime... right?

I don't think you need to use the List, Fields, Server-side Display Format. In fact, in the Display Format dialog, Alpha recommends that you don't use it. I rarely use it because it changes the way the date is delivered to the component. I prefer the date coming through in it's natural format and then using the List, Fields, Client-side Date/time display format to change how it's displayed.

I've been working with the FormView Date, Date/Time, and Time editors a lot. I'm not seeing any errors. Is it possible that you created these editors in the past, but have updated your build of Alpha?

Copy the Date Editor to the clipboard - should be 13 controls - and paste them into a new UX... and then post that UX here. I'll compare the code to what I have.

It's possible there was an issue and it was corrected... but... the code generate for the Editors doesn't get re-generated. I'm not sure if there is a way to re-gen that code. You'd have to delete the Editor and then add it back in again.

[[email protected]]

Re: Help with Editor Date Spinlist

Hi David,

Its Version 12.4.4.4, build 4346 with system addins Build 4889.

In the server side date format I have the following selected for the rego_expiry filed:
Display Format
Display format type Date
Date format
Input type String
Date input format Server-side Date Format
Date output format dd/MM/yyyy

Confirming the filed is setup as "date" type in MySQL (not datetime). Also I'm not using the Client side transform data type configuration in the List - it is blank. (should I be setting it to "ToDate and specify a format ??).

I've got 11 controls in the Date Editor control set, 13 if you include the opening and closing Editor Set tags. Is this correct ? I've attached the UX to this reply (I've also included the text and list editors which are part of my editor set).

The only other thing I can think of - when I initially added the date editor to the set, I accepted the default name which included ....Editor_3. However, I deleted it and readded it with the name ......Editor_Date. Not sure if that is significant ?

Cheers,
Greg

[[email protected]]

Re: Help with Editor Date Spinlist

Hi David,

Its Version 12.4.4.4, build 4346 with system addins Build 4889.

In the server side date format I have the following selected for the rego_expiry filed:
Display Format
Display format type Date
Date format
Input type String
Date input format Server-side Date Format
Date output format dd/MM/yyyy

Confirming the filed is setup as "date" type in MySQL (not datetime). Also I'm not using the Client side transform data type configuration in the List - it is blank. (should I be setting it to "ToDate and specify a format ??).

I've got 11 controls in the Date Editor control set, 13 if you include the opening and closing Editor Set tags. Is this correct ? I've attached the UX to this reply (I've also included the text and list editors which are part of my editor set).

The only other thing I can think of - when I initially added the date editor to the set, I accepted the default name which included ....Editor_3. However, I deleted it and re-added it with the name ......Editor_Date. Not sure if that is significant ?

Cheers,
Greg

[[email protected]]

Re: Help with Editor Date Spinlist

Here it is with just the date editor included.

[[email protected]]

Re: Help with Editor Date Spinlist

Here is the other information:

Its Version 12.4.4.4, build 4346 with system addins Build 4889.

In the server side date format I have the following selected for the rego_expiry filed:
Display Format
Display format type Date
Date format
Input type String
Date input format Server-side Date Format
Date output format dd/MM/yyyy

Confirming the field is setup as "date" type in MySQL (not datetime). Also I'm not using the Client side transform data type configuration in the List - it is blank. (should I be setting it to "ToDate and specify a format ??).

I've got 11 controls in the Date Editor control set, 13 if you include the opening and closing Editor Set tags. Is this correct ? I've attached the UX to this reply (I've also included the text and list editors which are part of my editor set).

The only other thing I can think of - when I initially added the date editor to the set, I accepted the default name which included ....Editor_3. However, I deleted it and readded it with the name ......Editor_Date. Not sure if that is significant ?

Cheers,
Greg

[Davidk]

Re: Help with Editor Date Spinlist

Try this. Get into your FormView, Fields tab... to your date field. Open the "Editor configuration genie"... and then close it. See if that clears the error.

What's throwing me off is your use of the term "Server-side". You write...

In the server side date format I have the following selected for the rego_expiry filed:

But the area you're working in is FormView, Fields. It's not "Server-side". There is a "Server-side" section in the List control, Fields area... which shouldn't be set for Display format.

The only other thing I can think of - when I initially added the date editor to the set, I accepted the default name which included ....Editor_3. However, I deleted it and readded it with the name ......Editor_Date. Not sure if that is significant ?

I believe the only time this will cause you trouble is if you don't update the Editor in the FormView, Fields tab.

In the FormView, Fields tab, in the Display Format dialog, you can enter "clientsidedateformat" (no quotes) for "Date output format". This will then use the date format setting set up for the UX. Have a read of the on-screen dialog note for this property.

[[email protected]]

Re: Help with Editor Date Spinlist

"in the server side date format I have the following selected for the rego_expiry filed:"
-> sorry, my typo, I should have said display format. This is in the formview control in the fields tab.

So basically I have removed all the display format and date format config. Dates seem to be displayed in both the list control and formview control based on the date format setup in the UX Properties screen.

Also I have found a work around to the problem by placing the 11 date list spin controls in a separate editor set. (EDITORSET_2). Seems to be working ok, only issue is the date spin list is transposing the month and date when I hit save. (instead of dd/MM/yyyy which is being displayed in the field, I'm getting MM/dd/yyyy when I hit save from the spin list. Still need to figure out how to solve this ?

Thanks a lot for your help.

Cheers,
greg

[Davidk]

Re: Help with Editor Date Spinlist

Did you open the "Editor configuration genie"... and then click "OK"? The FormView Display Format settings do work... here are my settings...

FVDate.PNG

[[email protected]]

Re: Help with Editor Date Spinlist

Did you open the "Editor configuration genie"... and then click "OK"?
-> I don't get a configuration genie for the Date Editor? (it is not configured by default). Have you added a custom genie ?

I just can't seem to get the right combination of display and date format settings. I get get the dates to display ok (dd/MM/yyyy) and the date spinlist reads then ok when opened, but when I save them back, the day and month are always swapped. Any ideas ?

Greg

[Davidk]

Re: Help with Editor Date Spinlist

Ok... sorry... the Editor configuration genie stuff is in a later pre-release. Doesn't matter though. Using 4346 it doesn't apply.

I just created a new UX, dropped in a List, FormView, and Editor... and I changed my system date format to dd/MM/yyyy. This causes an issue with the date Editor. Your version of the Date Editor "Get value from editor" code return is this...

return sMonth.value+'/'+sDate.value+'/'+sYear.value;

You can see the issue. However, changes have been made in the pre-release code in this area... and I've made a few more changes. This code allows for the default UX date format to be what you want it to be.

var sDate = {dialog.object}.getControl("EDITOR_3_S_DAY");
var sMonth = {dialog.object}.getControl("EDITOR_3_S_MONTH");
var sYear = {dialog.object}.getControl("EDITOR_3_S_YEAR");

var val = sMonth.value+'/'+sDate.value+'/'+sYear.value;

//get the date format of the data in the form (must be the format in which the data is stored - not displayed)
var dfmt = A5.serverSideDateFormat;

if(val == '0/0/0'){
	val = '';
}else{
	var _d = new Date();
	_d.fromFormat(val,"MM/dd/yyyy");
	val = _d.toFormat(dfmt);
}

return val;

1. This code gets the date values from the SpinList controls and puts them together in "MM/dd/yyyy" format... as a string.
2. Then we get the default UX date format... using A5.serverSideDateFormat... in this case "dd/MM/yyyy"
3. Then we convert the our new string into a date object using .fromFormat... and supplying the format as "MM/dd/yyyy" which is what the string from #1 is.
4. Then we convert our date object back into a string again... but this time we're using the default UX date format of "dd/MM/yyyy" which we got from #2.
5. Then we return that string.

[[email protected]]

Re: Help with Editor Date Spinlist

David,

That did it !! (with a couple of minor corrections). Can't thank you enough.


var sDate = {dialog.object}.getControl("EDITOR_DATE_S_DAY");
var sMonth = {dialog.object}.getControl("EDITOR_DATE_S_MONTH");
var sYear = {dialog.object}.getControl("EDITOR_DATE_S_YEAR");

var val =

sMonth.value

+'/'+

sDate.value

+'/'+sYear.value;

//get the date format of the data in the form (must be the format in which the data is stored - not displayed)
var dfmt = A5.serverSideDateFormat;

if(val == '0/0/0'){
val = '';
}else{
var _d = new Date();
_d.fromFormat(val,"MM/dd/yyyy");
val = _d.toFormat(dfmt);
}

return val;

[Davidk]

Re: Help with Editor Date Spinlist

Sorry... never post code... then change it... just doesn't work out... I always mess it up. Thanks... I've re-posted my running code... your corrections are right on. Glad it worked out.

[invictamarine]

Re: Help with Editor Date Spinlist

I had similar problems with both date and time editors. I removed the "Display Format" in the respective fields in the Form View builder and both now work fine (dd/MM/yyyy) even though the Editor property shows MM/dd/yyyy.