Something wrong with my auto increment ?

[dekleinemedia]

Hi,

I have a problem in my custom created "Accounts" module;
I have created a logic hook for auto increment. When i want to create a new "account" i fill in the "name", and leave the "number" field empty so it automatically SHOULD create "0001". When i do this and i "save" it, it gives me back a blank page with the message "can't show page".

BUT; when it is the first "account" and i fill in the "name" and fill in the "number" with any number it does save this account with number "0001'
This is only with the first account, cause when account "0001' exists, and i create a new "account" where i leave the "number field' empty, it does save as "0002"

How strange is this? And can someone please tell me what the solution is?

Thanks very much!

See screenshot

Ps; Isn't is possible that when i go to "create account" it automatically fill in the "number field" with its (following) number ?

[crmbalah]

HI
remove the number field from this edit view, display only the detail view.

[dekleinemedia]

HI
remove the number field from this edit view, display only the detail view.

Thanks, but i already tried that. When i remove the "number" field of my editview, i can't save the new account because it shows me an blank page with the message "can't show page".
I think it something in my DB ? Can't figure out why...

[dekleinemedia]

Thanks, but i already tried that. When i remove the "number" field of my editview, i can't save the new account because it shows me an blank page with the message "can't show page".
I think it something in my DB ? Can't figure out why...

Okay I figured out what the problem is/was; My custom field "number" wasn't a "required field". I have modified this, and deleted this "number" field from the editview.
Now when i create a new "account" i only have to fill in the name, and after save it automatically gives this account the latest accountnumber.'

If anyone had questions of how to do this auto-increment through logic_hook after save, just post your message here and i will try te help you

Greetzz

[crmbalah]

Hi
inside the logic hook you can write the query
first get the max of count from the account number then increment the account number the update the account filed.

[dayao61]

Okay I figured out what the problem is/was; My custom field "number" wasn't a "required field". I have modified this, and deleted this "number" field from the editview.
Now when i create a new "account" i only have to fill in the name, and after save it automatically gives this account the latest accountnumber.'

If anyone had questions of how to do this auto-increment through logic_hook after save, just post your message here and i will try te help you

Greetzz

Hi,

Can you post an example code as how to do this especially the logic hook part?

Thanks in advance.

[dekleinemedia]

Hi,

Can you post an example code as how to do this especially the logic hook part?

Thanks in advance.

Hi, this code worked for me.