Printable View
I installed calendarfield extension and I would like to store the calendarfield form data in a sql table. I believe I need to create a SQL table for my form where the data is stored and then create fields to correspond to each of the form data fields. What are the field names and types that I need to create in order to store calendarfield data?
I have tried a few versions, but so far have not been successful.
Thank you,
Tonu
Looks like I figured it out. The SQL field name needs to match the field name for the front end form field name (naturally). The field type is text. When I selected the field type to be date, it did not save the data. Please correct me if I am wrong.
In your database use int(10).
Contao stores dates as Unix timestamps, and formats them according to the date and time settings you choose in Settings.
In the Form Generator the field type to choose is "calendarfield" which lets you choose a date format (eg: Y-m-d) and date direction (eg: only future dates), but it still stores everything as a 10 digit timestamp.