Sorry to repost but a spirited discussion hijacked my last question, which was:
Is it possible to use Fabrik to:
1. Add another selectable date field (in addition to the Date Created and Date Modified) and a time field to Articles in a specific category.
2. Display those article's titles by the new date and time fields in a list format. i.e.
"Tuesday, August 3rd (This is one value for the new selected date field)
[new_time_field_value] Content Title 1
[new_time_field_value] Content Title 2
[new_time_field_value] Content Title 3
etc
"Wednesday, August 4th (Next value for the new selected date field)
[new_time_field_value] Content Title 4
[new_time_field_value] Content Title 5
[new_time_field_value] Content Title 6
Andre was kind enough to respond. My follow-up questions are in yellow. Thanks!
My biggest question is can someone with basic html and CSS knowledge but no PHP/MySQL learn enough from the subscriber documentation to do this?
---------------------------------------------------------------------------
Hi Jason,
The answer to that is a yes you can use Fabrik to create a new element, however the current latest revision 1.4b rev 122 has a bug in it relating to the store to database function on the form view...
Has this bug been resolved?
You will have to know ahead of time what all the data types for the jos_content table are,
How do I find this out?
and then generate the fabrik table from the Fabrik Table administration by clicking new and selecting the connection and the table. Then you will have to go to the elements view and reset all of the elements to match the Joomla jos_content data types. If you don't get this part right then Joomla will stop working. You would then add a new element to the group, set the type to Date, then go to the Form administration and click store to database.
To restrict your results to specific dates you would use the pre-filters to specify what to show. Alternately you could also use the group by and the prefilters to show a range sorted by date. This would require you to create a custom view in order to show the group by statements correctly since they can't anticipate how a view should look in that circumstance.
Hope that was helpfull,
Andre
Is it possible to use Fabrik to:
1. Add another selectable date field (in addition to the Date Created and Date Modified) and a time field to Articles in a specific category.
2. Display those article's titles by the new date and time fields in a list format. i.e.
"Tuesday, August 3rd (This is one value for the new selected date field)
[new_time_field_value] Content Title 1
[new_time_field_value] Content Title 2
[new_time_field_value] Content Title 3
etc
"Wednesday, August 4th (Next value for the new selected date field)
[new_time_field_value] Content Title 4
[new_time_field_value] Content Title 5
[new_time_field_value] Content Title 6
Andre was kind enough to respond. My follow-up questions are in yellow. Thanks!
My biggest question is can someone with basic html and CSS knowledge but no PHP/MySQL learn enough from the subscriber documentation to do this?
---------------------------------------------------------------------------
Hi Jason,
The answer to that is a yes you can use Fabrik to create a new element, however the current latest revision 1.4b rev 122 has a bug in it relating to the store to database function on the form view...
Has this bug been resolved?
You will have to know ahead of time what all the data types for the jos_content table are,
How do I find this out?
and then generate the fabrik table from the Fabrik Table administration by clicking new and selecting the connection and the table. Then you will have to go to the elements view and reset all of the elements to match the Joomla jos_content data types. If you don't get this part right then Joomla will stop working. You would then add a new element to the group, set the type to Date, then go to the Form administration and click store to database.
To restrict your results to specific dates you would use the pre-filters to specify what to show. Alternately you could also use the group by and the prefilters to show a range sorted by date. This would require you to create a custom view in order to show the group by statements correctly since they can't anticipate how a view should look in that circumstance.
Hope that was helpfull,
Andre