Perfect! How can I create a Query Builder that allows me to list posts that contain a meta field of type "date" for the current month? I don't want to list it by the post date, but rather by the date meta field I created.
To compare the value of the date field and current month, an SQL query is needed. Our support team can give you an example to get the result you need. You will be able to customize it according to your use case. crocoblock.com/help-center/
Could you please check this article? jetformbuilder.com/features/jetformbuilder-connecting-wordpress-related-items-with-post-submit-actions/ It's about connecting related items in general which works with CCT items as well. If you have additional questions, contact our support team, please crocoblock.com/help-center/
How can I limit the number of posts I see? I have managed to display the past events but I only would like to see 3 of them. Now all the past events are being shown
How do I display the next event based on the date and time? Ive got multiple events in a day and I want the next to display as soon as the one before it ends. I’ve switched my meta field and query to datetime but it seems to want to display on date ignore the time.
You may check this information here to get more examples about relative formats which work fine with Query builder www.php.net/manual/en/datetime.formats.relative.php If you still have any questions, contact our support team, please crocoblock.com/help-center/
Following your steps, "save as timestamp" will change my date in the front-end to "1689292800". How can I solve this using the timestamp functionality?
That's right, the date is saved in timestamp format. When you create a listing for posts or single post template, use Dynamic field widget with the callback: Format Date: prnt.sc/XKwW-1HDeYLX
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
Perfect! How can I create a Query Builder that allows me to list posts that contain a meta field of type "date" for the current month? I don't want to list it by the post date, but rather by the date meta field I created.
To compare the value of the date field and current month, an SQL query is needed. Our support team can give you an example to get the result you need. You will be able to customize it according to your use case. crocoblock.com/help-center/
can you make a video about CCT relationship via front end form?
Could you please check this article? jetformbuilder.com/features/jetformbuilder-connecting-wordpress-related-items-with-post-submit-actions/
It's about connecting related items in general which works with CCT items as well. If you have additional questions, contact our support team, please crocoblock.com/help-center/
could you please explain how to change the Crocoblock date format (2 Aug)
kindly try this option in the dynamic field settings i.imgur.com/a8AHxeY.png
How can I limit the number of posts I see? I have managed to display the past events but I only would like to see 3 of them. Now all the past events are being shown
you can do it with the query builder
limit posts in general - prnt.sc/Xp-WZP9WZfJD
and per page - prnt.sc/Q1CaXq71l67Q
How do I display the next event based on the date and time? Ive got multiple events in a day and I want the next to display as soon as the one before it ends. I’ve switched my meta field and query to datetime but it seems to want to display on date ignore the time.
Let our support team to check your settings. We need a bit more information about your set up:
crocoblock.com/help-center/
@@Crocoblock my local hosted site time must off but it does work on other sites that are online. Thanks!
Thank you for the input. Is it possible a strgtotime like before 3 or 6 month? Like "first day of 6month midnight"?
You may check this information here to get more examples about relative formats which work fine with Query builder
www.php.net/manual/en/datetime.formats.relative.php
If you still have any questions, contact our support team, please crocoblock.com/help-center/
Guys, I'd like to show my events in the order they will happen (not the order I published). How do I do that?
Hi! 🙂 Here is an example how to order posts (products) by Date meta field saved as a timestamp: prnt.sc/yzVQ20DxpOsK
Oh my God, thank you so much!
How is the pagination working?
Hi! Please, check this tutorial crocoblock.com/knowledge-base/articles/jetengine-how-to-add-pagination-to-the-listing-grid-widget/
Can i ask why Crocoblock delete my comment? Did i write something wrong? I hope u explain it.
Hi! Probably, it was deleted by RUclips. Could you pleas duplicate your comment?
Following your steps, "save as timestamp" will change my date in the front-end to "1689292800". How can I solve this using the timestamp functionality?
That's right, the date is saved in timestamp format. When you create a listing for posts or single post template, use Dynamic field widget with the callback: Format Date: prnt.sc/XKwW-1HDeYLX
@@Crocoblock Thank you! It's working again.