Hello,

Default values defined in a table are not being displayed using a form and "New". The fields are displayed empty. This is for string, text and integer values!

The default value is not for prefilling the forms.

It acts in model, not in templates.
It is a table field fallback value which is used for every access of the table, wherever in the component. A table security if the null value is not allowed.

If the field is empty on submit, the default value take place.
If the field is not instancied in form, it works.
If you call your model by yourself (custom code), it works too !!!


DEVELOP :
In your view.html.php file, after the getData() call, check if $my_object->id = 0 (NEW) and fill the object with the value of your choice. (2 lines)

But it can be a nice idea, and it have already been asked if I remember.

Took note.

I would find it sooooooooo logical that what i fill in default value gets really as default value in form Could you do that my dear Jocelyn ? Thxxx (i'm so happy today because your cook is sooo great, i really do amazing stuff with it, hope i can show you at joomladays, just to show you how powerful your tool is (i know you know it's powerful))

Ok, Let's see that...

The idea was much more about security 'fallback' value if form value is empty.

Added for you.


There is a checkbox under the default value param.
"Prefills forms" => Use the default value fallback as field initialization.

Thank you sooo much for this looooong awaited feature. This is one of those basic features that one would expect right away from such a tool or any kind of forms generator.

Just wondering? Although I have some skills in database design, I am far away of being a db design expert, but so far I have never seen this distinction between a separate fallback value and a prefill form value. Either a field is empty or it has some initial default value which will pop up in the form. Having an invisible default value in a field is in my opinion not a good practice. But probably there are reasons I do not see.

For example a default string value can be anoying in the form if you have to clear it everytime before writing a value in.

Fallback value is for the physical database parameter of the data field. Written in the SQL structure of your table.
And if for any reason, you want to be able to overrhide this default (for example, depending language, fk, access, or else...),
then you have a last chance to insert a piece of PHP before treating the SQL physical default. (in the check() method in mytable.php)

Well, maybe not so usefull, but it don't require much more source code. Just opening a last php fallback if you want.

That's all.

You are the sunshine of my lifeeeee

Thank you added - but please don't give up your day job LOL. (reference to singing)

Edward

Brilliant! THANKS