Hi,
I have a table that I am listing some events. Sometimes we don't know the starting time so we erase the content of the field and when I save that record the event starting time defaults back to 7:00 PM and I would like to leave that field blank if I don't know at what time the event starts. How do I clear that default or even some times default to a preset time that I assing. But I need to know mostly how to leave it blank for now.
Thanks,
How do I change the default time that appgini assign by default?
-
- Veteran Member
- Posts: 90
- Joined: 2015-11-23 01:02
Re: How do I change the default time that appgini assign by default?
I had a similar problema this is how I do it:
I just update the field with NULL based on a condition.
Something like:
Update tablename set Time = Null where Started <> 'Yes'
I just update the field with NULL based on a condition.
Something like:
Update tablename set Time = Null where Started <> 'Yes'
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper
-
- Veteran Member
- Posts: 90
- Joined: 2015-11-23 01:02
Re: How do I change the default time that appgini assign by default?
SOLVED
An it was way too easy you just change the default format into the default text of the field. In my case was 1:00 Am so I put the default text for that field was: 01:00:00 and that took care of the problem. Hope this answers many people asking for this.
An it was way too easy you just change the default format into the default text of the field. In my case was 1:00 Am so I put the default text for that field was: 01:00:00 and that took care of the problem. Hope this answers many people asking for this.
-
- Veteran Member
- Posts: 47
- Joined: 2016-08-28 10:37
Re: How do I change the default time that appgini assign by default?
nycwebmaster please can you expand a little on this with some code examples as I'm completely stuck! Thanks!
Re: How do I change the default time that appgini assign by default?
Maybe I am not understanding. You can put in a time in that Default box. I just created a new column of type Time and that Default was blank.
~Paul
~Paul
Re: How do I change the default time that appgini assign by default?
Yes, I couldn't believe it was that easy myself.
Just put the default time you want as shown in the image in the Default textbox.
Just put the default time you want as shown in the image in the Default textbox.