Guriddo » Topic: Changing Format before save

Changing Format before save

Guriddo
Changing Format before save

This topic has 11 replies, 2 voices, and was last updated 16 years, 2 months ago by tony.

Creator

Topic
August 6, 2009 at 10:51 am #73849

Romyn
Participant

Hi,

I had a search and looked through the new wiki – I take it it's new anyway – very nice! – but am a bit confused to what I should being doing to perform the following.

I have a number of columns/cells whose value is held in seconds but displayed as either HH:MM:SS or MM:SS. This works fine on the display side using a couple of custom formatters but the problem comes when I try and add/edit (both inline and via dialog form).

I don't know how to take the input which is a string and convert that into an integer. I have the functions to do the conversions but I don't know where/how to apply them. How/where do I grab the value and change it in the celledit, addnew and edit forms.

I'm sure this is pretty strightforward but would really appreciate some pointers.

Thanks and regards

Romyn
Creator

Topic

Viewing 11 replies - 1 through 11 (of 11 total)

Author

Replies
August 6, 2009 at 10:57 am #87985

tony
Keymaster

http://www.trirand.com/jqgridwiki/doku.php?id=wiki:custom_formatter#unformatting

August 6, 2009 at 11:08 am #87990

Romyn
Participant

Thanks Tony,

That looks to be just the job. I tried it quickly but couldn't get it to work – what version to I need to be running for this?

Cheers

Romyn

August 6, 2009 at 11:18 am #87992

tony
Keymaster

Hello,

Could you post the code for the format and unformat functions – or better post all again with grid configuration.

August 6, 2009 at 11:41 am #87994

Romyn
Participant

Hi,

The relevant bits are:-

The col model:

{name:'sdelay', index:'sdelay', width:60, align:'center',editable:true, editoptions:{dataInit:function(el){$(el).mask(”99:99:99″);}, defaultValue:'00:00:00'}, formatter: fmt_HMS, unformat: unfmt_HMS},

The format function:

var fmt_HMS = function(cellval,options,rowdata) {

August 6, 2009 at 12:04 pm #87996

tony
Keymaster

Hello Romyn,

Thanks – it is a bug in formedit module. Fixed. Will publish a bug fix release at end of this week.

Regards

Tony

August 6, 2009 at 12:06 pm #87997

Romyn
Participant

I've just downloaded the latest pack again (not the GitHub one) and it is different so I'm not completely up-to-date on that by the looks of things.

However using the latest a TreeGrid I have gets stuck on “Loading” so something has changed in that that I need to fix first – new syntax or something?

I'll try and do that and then see if the unformat function gets called. (Can't get to it until I fix the TreeGrid as that is the launch point for the other grids with the meat in them)

Regards

Romyn

edit – just seen your other reply. Thx – I'll download again in a few days.

August 6, 2009 at 12:19 pm #87998

tony
Keymaster

Hello again,

Tottaly confused. It is a my fault at all. All will be fixed in the 3.5.1 and documented

August 6, 2009 at 12:30 pm #87999

tony
Keymaster

Hello,

Here is the problem: (instead I found another in formedit regrading this)

You define the

August 7, 2009 at 12:09 am #88013

tony
Keymaster

Hello,

I made the needed fixes in the GitHub. Also fixed some other bugs related for datetype as function

Regards

Tony

August 7, 2009 at 1:14 pm #88037

Romyn
Participant

I'll admit to being pretty confused myself now.

I've downloaded the latest GitHub files and made the changes to how the functions are defined – (don't know where the var versions came from – must have been done that way in the examples I used).

Anyway with those changes made I'm still having some trouble. The ideal scenario I want to get to is to store as Seconds, display as HH:MM:SS and edit using a Mask in the for __:__:__

To that end I've put together a simple page with a grid that has various differently configured columns – and celleditting enabled so just clicking in and out of the cell should show the effects.

http://www.thekmz.co.uk/GEPlugin/wip/test/gridtest4/gridtest4.htm

Simple – no formatting at all

fmt – just the formatter

fmt/unfmt – formatter and unformatter

fmt/mask – formatter and mask

fmt/unfmt/mask – formatter, unformatter and mask

The fmt/unfmt column works as designed (except when the value is 0 which I can't suss out?) – but I want to then add the mask to that but that doesn't seem to work. I also appreciate that some of the columns shouldn't work correctly but they are there just to show how I build up through adding the various options)

(also tried the var myval = $(cellval).html(); thing you mentioned but that didn't work for me at all so I went back to the old style).

Sorry this is so confused but it reflects the state of my little brain…

(I might be better off going back to storing the value as a HH:MM:SS string but I want to avoid that if I can)

Regards

Romyn

August 10, 2009 at 5:32 am #88056

tony
Keymaster

Hello,

This example is very helpfull.

OK – the problem – Which is the first chicken or the egg.

In order to understand what is happen:

1. You format the hour (represented as number) and this work ok.

2. You try to edit the formated data, but before to display it you make a unformat. (When we edit the data the first what we do is to unformat it).

3. You have the unformated data.

4. After unformat we applay all the events – including dataInit where you apply the mask plugin, but this data is alredy number and it can not be used correctly in the plugin.

5. The result – inconsitent display.

I think that in this case you should not the unformat, but rather use some events in cellEditing to post the number and then this number will be correcly converted from format function.

If you have difficulties please let me know.

Regards

Tony
Author

Replies