How to set up database relationships | JetEngine from A to Z course

[@qualitytickets3889]

Please add more advanced videos on this topic! Great starter info!

[@Crocoblock]

Got it ;) Thank you!

[@jeremyinglesi8458]

if you struggle with the macros at the end (around the 20 minute mark) you can also try and use the "dynamic tags" function to pull the proper shortcode/macro. it may be something that jet enginge incorporated after this video was created but since i couldn't figure out how to code the macro shortcode, i tried the dynamic tags and it worked for me!

[@cpalma]

Thanks for this comment! The dynamic tag worked perfectly for me. I had been struggling with the macros as well haha

[@juliano877]

Please how do I use dynamic tags for this problem, I've been stock on this for a long time, many thanks in advance

[@PLUS-sj4sf]

Thank you so very much Paul! Yes pls, more and advanced ones would be great :)

[@mygicarskrsk4465]

Thanks for this video! Paul has the best valuepacked crocoblock tutorials all around!

[@nigelhancock3580]

Very timely, thank you Paul. I'm working on a site right now based around "Fishing venues". Each venue can have multiple lakes and each lake multiple species. Additionally, each venue may have a number of accommodations. The relationships have left my head spinning - in my muddled head, the venue is the parent and lakes the child but, looking at your video, if my venue is your property and my lakes are your agents, then I've got that the wrong way around - which probably explains why it's not working as expected! Someone here mentioned that you could do all this without relationships, perhaps using repeater fields to list the agents - that would work BUT you need to consider how the site will be used - for example, you might want to look for agents and which properties they manage - the relationship method makes that straightforward but not so if it were a repeater field. Also, for JetEngine, in this example, if the Agent details needed a repeater field for some reason then JE doesn't support nested repeaters (which ACF does) which is another design factor. Can anyone explain to me in simple terms why, in Paul's example, the agent is the parent and the property the child?

[@Crocoblock]

If I understood you correctly, Venues, Lakes, Species and Accommodations are all CPTs, correct? Or, probably some of those items can be presented as Taxonomies? Look forward to your reply!

[@nigelhancock3580]

@@Crocoblock Not 100% sure yet - I think they will all be CPT's so that they exist in their own right - this may be beneficial when it come to sorting & filtering results so, it maybe that the user's first, most important factor is the accommodation so they can see all accommodations, then filter my lakes & venues or any combination.

[@Crocoblock]

@@nigelhancock3580 I'm so sorry! We missed your reply! If the question is still relevant, I'd offer you to try our Zoom call calendly.com/crocoblock-help/30min?fbclid=IwAR1sW0zAvXen6zLvA4ygvK_m0WlhvmY_g0RVh-_K6xAd2SuHtj7_Qcn88qY and have a live talk with technical support :)

[@maxtermiller5947]

"Can anyone explain to me in simple terms why, in Paul's example, the agent is the parent and the property the child?"

[@arashd1381]

Paul C and Alexandra Payne are the best tutors out there!

[@StevanOvich61]

Nice one yet again Paul. Bought the Crocoblock Dynamic package a couple of weeks ago, and these tuts will surely boost my learning of Jet plugins. More of this kind of stuff please! Thanks again Paul 👍

[@Crocoblock]

It's a pleasure for us to hear that Paul's videos are extremely useful :)

[@prodevsol]

Very useful tutorial, Paul! Please provide more advanced tutorilas on this topic :) Greetings from Austria, Artur

[@PascalParent]

Hi Paul and Crocoblock Team, as usual a great tutorial. And to answer Paul’s question, I would welcome more in-depth tutorials with JetEngine but also JetAppointments and JetBookings.

[@Crocoblock]

Hi Pascal! Thank you for your feedback and suggestion! I'll notify our creative team.

[@AbdulRasheed-fj2ei]

Hey dear, I have a query that If we want to archive template and in that we have a category name and under that we want to show a list of posts related to that specific category. do you make a video that how we can do that?

[@xxoooOFxx]

Hey Paul, another excellent tut! Did you ever create the advanced tut for JE Relationships? Would love to see that, as this is a powerful tool that I'd like to understand in a fuller context.

[@ratfinder7812]

Hi Paul, I love your videos, please make as many relationship videos as you can, I am trying to learn as much as I can about crocoblock Jetengine

[@Crocoblock]

Hi :) If you need any assistance in creating a relationship, please contact us via chat or ticket system ;)

[@jeffreyhenry4615]

Would like to see a video of how you would set up posts relationships for Country | State/Province | City Country to show links to all States/Province posts, States to show links to all City posts.

[@Crocoblock]

Guess, this is what you need: kzbin.info/www/bejne/Z6euXpqheN-Se5Y

[@LMS_Design]

Hi Paul, are you still doing JetEngine tutorials? I would love to learn more about advanced queries and relations. Thank you and keep up the great work!

[@Crocoblock]

it looks like to be an old video 😊 as for right now it seems as Paul temporary doesn't create guides for us by the way, recently we've had a stream with Paul - might be interesting :) kzbin.info2jM926i4RoM?si=idLbeH9gk0-tFH0i as for advanced queries and relations, we have a newly created video about the Query Builder which seems to fit your needs :) have a look at it and let me know it it suits you kzbin.info/www/bejne/qaOUdmV3pbGDn9k How to Switch Queries in the Front-end without Reloading the Page kzbin.info/www/bejne/ooe0lqqXdpl6aa8 Validating Field Values with JetFormBuilder Server side Callback for Single Field and Query Builder kzbin.info/www/bejne/o6i9aaZmZZdjppY Internal notification system (with JetEngine JetFormBuilder and query builder) kzbin.info/www/bejne/d5fZqYiDaMR4d9U if you are interested in sth specific, just let me know

[@jeremyinglesi8458]

how can i thank you enough for this tutorial

[@nassimabennai2927]

Thanks Paul, the explanations are perfect as usual! I would like to link a post type to a user (managed through "profile builder"). It doesn't seem possible by following the video's steps, any other way to fix it?

[@joseramonruiz4538]

I also need it

[@jalexandreenumo1244]

I also need it, urgently. Please Crocoblock team, help us, this functionally is too much important to develop a lot of business projects.

[@joseramonruiz4538]

@@jalexandreenumo1244 I have achieved it, filtering it by Author. Do not forget to activate the author in the post type to be able to change it as you like.

[@doxaanthony6262]

@@joseramonruiz4538 How do you achieve this?

[@pin-yuanchen131]

my question was how to let the users to establish the relationship it in the fronted by using jet engine form?

[@tizumtizum]

this is exactly the question I would ask, how is the relationship made automatically by the agents registered on the website, performing the new registration through the property registration panel built with the forms and profile builder.

[@Crocoblock]

As for now, the relations can be created only from the backend by site administrator.

[@Crocoblock]

@@tizumtizum currently, there's no opportunity to do that, however, it sounds interesting. Please kindly submit your feature request at github.com/Crocoblock/suggestions ;)

[@eduardemter270]

Thanks a lot for this Tutorial. It just came in the right moment. Couldn't figure out a problem yesterday which I now solved. Please more of this great collaboration!!!

[@Crocoblock]

Happy to hear that is was helpful ;)

[@anttixdj]

Yes please Paul, I would love to see more in-depth content like this...thanks for the great Tut. 😃

[@Crocoblock]

New tuts will be created soon ;)

[@Avisa01]

Great stuff!! Hope to see how to connect jet engine to external database or spreadsheet 🙏🏻🙏🏻🙏🏻 for quick update

[@Crocoblock]

Hi, Roger! Currently, we don't have the mechanism configured to achieve it.

[@AssociationPourledevelopmentde]

Thank you so much for your wonderful tutorials. Please make a comprehensive relationship tutorial: many to many. A Volunteer who sign for specific program or programs and make his/her availability known, someone who need help in that specific program. For example: You have someone who's volunteering (signing up) for tutoring, if a student need a tutor, he/she can just sign-up or sign-in to the site and choose from available tutors, schedule, by chose from his/her choice of tutor and the available time the tutor volunteering to help.

[@Crocoblock]

Hello! Thank you for your feedback! Could you please check these articles which explain how WordPress Relations functionality works? crocoblock.com/blog/wordpress-relationships-explained/ And our articles how to work with this functionality using JetEngine: crocoblock.com/knowledge-base/articles/how-to-choose-the-needed-post-relations-and-set-them-with-jetengine-plugin/ crocoblock.com/knowledge-base/articles/jetengine-how-to-create-relationships-between-posts/ It should help you to get the basic info about this feature.

[@boubaskunk]

Hi! Thanks for this great tutorial !! I have one question : How is it possible to add a relation between to Post programmtically ? Explanation : I've got 2 post types : Posts and Houses A connected user should be able to post via JetForms a Post and link it to a House. I didn't see how to link the post to the house directly from the form. I've created a field "Select" and "Fill Options From:" "Houses" to list the houses but it doesn't create the relationship between to 2 posts. I'm looking for a hook like "save_form" to catch form submit and add this relation parent/child via PHP. Hope it's clear enough. if it's not, tell me :) Thanks

[@boubaskunk]

Ok! Just find a the solution via the Facebook Crocoblock Community Page ! For users here : 1. Create a select/radio/checkbox field in the form. "Fill Options From:" -> "posts", "post type" -> "#your cpt" 2. Set this field in the "insert/update post" to be a "post meta" 3. paste the relations meta key into the empty text box...done! Didn't I can put the relationship meta_key in there!

[@Crocoblock]

Hello! We have a guide on how to achieve it: We can create a form for child posts and display it on Single template for the parent posts and it will have relation if we insert the relation key in the right field of the form. Please, follow this little tutorial: For ex. I have two CPTs - Producers and Events. I created a test form in JetEngine to add a new post from the front end prnt.sc/skbgv8 here, in the form, insert the relation prnt.sc/skbhax Here is the relation itself between CPT`s (One to many) prnt.sc/skbhpi Then we go to the producer's page prnt.sc/skbigo, Single template for the producer (if it is not exist, then create it either in the Elementor theme builder or in the Crocoblock theme builder) prnt.sc/skbiuu Display the form that was created prnt.sc/skbjr5 On the front end, fill in the form prnt.sc/skbkkr Check the result from the back end prnt.sc/skbl78 The key action is to set the One to Many relation here prnt.sc/skbmhb In case if further assistance is needed, please contact out Support team at crocoblock.com/help-center/

[@boubaskunk]

@@Crocoblock Thanks for this quick tutorial !! ;) That's work great if you don't want the user to choose the data. Which can be very useful.

[@Crocoblock]

@@boubaskunk That sounds like a good idea ;) Could you please submit a feature request on github.com/Crocoblock/suggestions and our devs will check it.

[@adambermingham7661]

In this example, can "Agent" be a user? So using Profile Builder the agent could upload their own properties etc.

[@joseramonruiz4538]

I'm trying exactly that but I can't relate to it :(

[@adambermingham7661]

@@joseramonruiz4538 More like a multi-vender E-Commerce platform, just without sales.

[@HiLectric]

For some reason the post thumbnail image doesn't come up when I pull in the dynamic image widget at the 13:04 mark.

[@Crocoblock]

Hi! Please, contact our support on this issue - crocoblock.com/help-center/ 🙂

[@digiperth1689]

Simple but it is really userful. Thanks Paul and Crocoblock for such a great tutorial.

[@Crocoblock]

Thanks ;) Happy that you found it useful :)

[@arhamjaved8990]

I've created a relationship between Post types (CPT) A and B. However, how can I show parent post information on the child post detail page? Please respond to my questions as soon as you can!

[@PK-is3di]

Hello Paul, is there a way to input relationship in ACF front end form !! I am not able do it so far ..

[@andrewblevins4591]

This is perfect. Would love to see more examples and also how to setup (if any from the parent listing grid) so it can list all the child listing grids on the same page.

[@Crocoblock]

Could you please clarify your question a bit? ;)

[@andrewblevins4591]

@@Crocoblock Sure, in the example of this video, could we get a parent listing page or video on showing Agent's "Page" and few different ways to show all the properties that were his children of listing items.

[@Crocoblock]

@@andrewblevins4591 I'm sorry, I still can't understand the question. Please kindly take a look at our textual tutorial: crocoblock.com/knowledge-base/articles/jetengine-post-relations-how-to-display-the-related-parent-posts-in-the-listing-grid/. Also, if you need assistance with a certain issue on your site, please kindly contact us via chat or ticket system: crocoblock.com/help-center/

[@williamamoako-nimako9440]

Excellent. Pls share more advanced videos. Thanks Paul.

[@lisam.bender5515]

Yes, more please Paul, you are amazingly helpful!

[@Crocoblock]

Happy to hear that you loved this video :)

[@DianneVolek]

I'm trying to use Post Categories across multiple content types. I want to use the same categories throughout (I would love to use JetEngine taxonomies or Glossary, but the required Theme Colibri Pro, is neither Elementor or Gutenberg. And it will ONLY show Post categories. It's been very easy on Jet-Engine created customer post types, but I have to link ProfileGrid plugin to these categories also. Is creating a "relationship" a potential solution?

[@Crocoblock]

Hi Dianne, Crocoblock is not compatible with Theme Colibri Pro and the ProfileGrid plugin. You cannot use the same category across multiple CPTs or CCTs; it must be unique to avoid conflicts. If you use JetEngine, you can link categories through relationships, but this works only with compatible themes and without ProfileGrid.

[@RomanAftantilidis1989]

Very useful tutorial, Paul! I wonder if there is an option to pull value from related post type (i.e. agent mobile) without using a listing grid.

[@Crocoblock]

Hello! You should use the Context option to display the value of a meta field on a listing or on a single page of the related item. prnt.sc/exwBVEuGxSKK - here is the example how to display a meta field from taxonomy Directions on a listing item for CPT Tours using Context.

[@LaurentVanDessel]

How are you able to define an extra field to a many-to-many relationship? Before I used Toolset Types for this where we can do this. I would need a relationship between two custom post Types: "Yachts" and "Destinations". But the destinations that are attached to a yacht are different per season so I would need a custom field to this relationship "Season". Is there a way to achieve such a thing in JetEngine? Thanks

[@Crocoblock]

Hello! Sorry, but there's no such opportunity with JetEngine relations.

[@Hussain110]

Thanks for this video, have a question when an agent adds new property from the frontend, the property does not select the agent, what is the solution.

[@Crocoblock]

Hi! Could you please provide the issue in more detail and provide some screenshots? Do you want to display the name of the user in the post with the property prnt.sc/1czzstv ?

[@septabeat-5508]

Please create all these videos for Divi too, your vids are amazing but sadly I cant use as I'm a Divi guy! thanks

[@michellegoodale4206]

I would love to see more complicated relationships, also how to work pulling in information from other posts in the post type.

[@Crocoblock]

Hi! Could you please describe in more detail what kind of relationships you would like to create? Also, could you please specify, do you want to transfer the content from default WP posts to the custom posts created with JetEngine?

[@Fabio330ci]

Thanks you Paul, does its possible to create relationship between registered user and custom post type? in simple work to "bind" the post to a specific user. Thanks

[@Crocoblock]

Hi! Right at the moment, this option isn't available. Please, feel free to submit a feature request to Git repository github.com/CrocoBlock/suggestions and our team will explore if it's possible to implement.

[@Fabio330ci]

@@Crocoblock wake up, its almost 2022!

[@reillonmochi]

Thank you Paul, how would you do this in JetEngine's form? Like if the agent publishes a property in the front-end using the form, how would you set the relationship there when you submit the "Add Property" form?

[@Crocoblock]

Hi! Could you please specify, do you want to add a relationship between CPT and users?

[@MrAyyubpatel]

excellent, and Paul yo have very nice and soothing voice as well, great presentation man.

[@alarsefilm]

Hello, could the relationships be designated form the profile builder so that the client has everything from there?

[@Crocoblock]

Hi! Could you please describe the issue in more detail or provide me with an example of what you would like to achieve?

[@unboxcreativedesignstudio896]

Hi Paul, Im building listing website and Im using the jetEngine. I am wondering if I can create a claim listing functionality using jetEngine Relation?

[@Crocoblock]

Hello! Could you be so kind to tell us in more detail what needs to be done? Please feel free to contact our Support team at crocoblock.com/help-center/ and we'll gladly answer your questions :)

[@calmfamily]

Do you have videos regarding how a custom post type that is effectively a person type can be linked to the user account? I want my consultants (agents) post type to be created by the user account info in the front end, and then linked to posts and events etc?

[@Crocoblock]

Hello! We don't have videos on such topics, but you can add relations between CPT and the CPT created by user.

[@calmfamily]

@@Crocoblock What I want to understand, is how to link the "user" to the CPT so that it automatically links events and posts. Currently, BuddyBoss/wprdpress creates the user, I need a dynamic page listing for them as Consultants, and they can create posts. (as an author) and events (as an organiser). I want to display their listing and it link to their events and posts. Ideally I could do this on the BUddyBoss profile but I think that is asking too much.

[@Crocoblock]

@@calmfamily We need to check your case individually. Please submit a ticket at support.crocoblock.com/support/tickets and the Support team will be glad to assist. Thank you!

[@PaulHerzlich-xo8ox]

I'm not sure anyone could use JetEngine without your helpful videos. So many parameters on the Jet elements (like the Listing Grid) are unexplained. Like under the heading Posts Query there is a repeater asking for Items, but no place in which to specify a value that you might query. What are these items trying to do? It's a mystery. That's just an example. Keep going.

[@Crocoblock]

Hi! Actually, we've got lots of textual tutorials, where we described the settings and provided the guides on how to work with them ;) crocoblock.com/knowledge-base/article-category/jet-engine/ As for the Posts Query question you addressed, if you meant this prntscr.com/tzfxaz - please kindly take a look at video by Paul kzbin.info/www/bejne/aYnOaI1pr5WHpKc ;)

[@PaulHerzlich-xo8ox]

@@Crocoblock That's exactly the area I meant, thank you. And the additional video link (Paul's video) and closer inspection of the BaliRento demo helped. I appreciate the pointer to the Jet Engine knowledgebase category of articles. But let's take this example: I wanted to know about the queries (Post Query, Term Query, etc.) on the Listings Grid element. So I went to the JetEngine document 'Listing Grid Widget Overview'. It links me to another set of documents called 'JetEngine Posts Relations'. The documentation never says it, but the query parameters are irrelevant because I was just trying to create an archive without including or excluding anything. (A great feature if I need it one day, but I don't today.) It was a lot of jumping around to discover I could ignore those parameters. I understand that Jet is a vast product to document, but as the documentation now stands, I find it hard to navigate.

[@Crocoblock]

@@PaulHerzlich-xo8ox Wanted to share with you our experimental support option - Zoom calls- calendly.com/crocoblock-help/30min?fbclid=IwAR1sW0zAvXen6zLvA4ygvK_m0WlhvmY_g0RVh-_K6xAd2SuHtj7_Qcn88qY - if you want to have a live session with technical support agent, please feel free to schedule a call ;)

[@PaulHerzlich-xo8ox]

@@Crocoblock Thanks, but 3 weeks is a long time. I've moved on. I'll try this when I have my next query.

[@johngiftakis9878]

You delivered again Paul! I would like more advanced on this. Especially how we connect User Registration with Agency CPT for example. Cause now we have Agency but we created it for them. How we could have them creating themselves and then be connected with Properties?

[@Crocoblock]

Hi, John! Could you please specify in more detail how the structure is performed on your end? Thank you!

[@hosseinkhanmohammadi4770]

Hi. Thank you. I'm always wondering why they didn't do "Setting Up Custom Query Parameters" smarter and dynamic ?!! At leas as an option.

[@Crocoblock]

Hello Hossein! I'm sorry, could you please clarify your question in more detail?

[@ravitokas84]

Nice tutorial Paul C, Hi can we make a family tree page with crocoblock. If yes can you please make video on it. Thanks

[@Crocoblock]

Hi! Thank you for your feedback :) Could you please provide me with an example of what you would like to achieve?

[@MoxetKhan]

Hey Paul, If i use a smartfilter to show all properties added by an agency located in London, how can i do such kinda filtration. The filtration is possible only in the parent/child terms. A parent terms can't show a child associated.

[@Crocoblock]

Hello! Could you please contact our Support team, so they could check your case in details, see the structure you have and recommend the best way of creating a filter ;) support.crocoblock.com/support/home/

[@developernerds]

I love your videos! So informative! Thanks!

[@grafickyservis8875]

I understand everything, but how do I assign a specific agent's contribution to a specific property? Can agent selection be set by metabox?

[@Crocoblock]

Hi! Please, contact our support on this issue - crocoblock.com/help-center/

[@daveryanmedia]

This is really helpful. One question I have; Is there a way to show %related_parents_from|post-type-slug% without having to use the Listings Grid module? For example to use the website in the video, if I wanted to show the name and a link to the agent from within a listing grid of the property itself, which would be used in the search results or 'related property'? Or would I need to have nested Listing Grids within one another just for a simple link to a parent or child?

[@Crocoblock]

Hi! Right at the moment, this option isn't available. Please, feel free to submit a feature request to Git repository github.com/CrocoBlock/suggestions and our team will explore if it's possible to implement.

[@sadarahurh8794]

Great videos ! Yes definitely more contant about data tables and advanced relationships. I would like to see some example of Master/Details page (i.e. Invoice, Order etc...). I am about to buy Crockoblock subscription and this is a crucial features that I need. I need to know what is avaiable and how quick I can build those forms and data table grids...

[@Crocoblock]

Hi! You can use a ready-made template. Please, check this one bit.ly/3xevM1q 🙂

[@hosnialqaramani4457]

Hi Paul Please make a detailed one for all the relationship types. Thank you for your support

[@Crocoblock]

Hi! Thank you for your suggestion! Right at the moment, you can check how to create different relations in the Knowledge Base - bit.ly/3ugKnIm

[@hosnialqaramani4457]

@@Crocoblock that is right but when you make a video for it is totally different as you give me enough time and explanation to understand it perfectly.

[@Crocoblock]

@@hosnialqaramani4457 sure, I understand 🙂 Probably, we'll add it in the future.

[@hosnialqaramani4457]

@@Crocoblock BTW can you advise if we make relation between 2 custom posts should we have the same metadata fields on both custom posts.

[@Crocoblock]

@@hosnialqaramani4457 no, it's not necessary.

[@ianforestdj]

Is it possible to add an admin column based on data from another related post type?

[@Crocoblock]

Hello! No, unfortunately, there's no such functionality. Please feel free to submit your feature request at github.com/Crocoblock/suggestions and it will be implemented if possible. Thank you :)

[@maliktanveerdhool]

hi crocoblock team, different agents are assigned to one property, how can I display all the agents in a single template?

[@Crocoblock]

Hello! You need to have the Single Property template created, and display the Agents via Listing Grid using appropriate macro, depending on whether they are parents or children crocoblock.com/knowledge-base/articles/how-to-choose-the-needed-post-relations-and-set-them-with-jetengine-plugin/#title3

[@andre_lug]

This tutorial is perfect! Thank you. Really helped me!

[@Crocoblock]

Hi! Thank you so much for your feedback!

[@erickstevi7327]

Hi Paul. How to make the user profile as parent and post as the child?

[@Crocoblock]

Hi! Unfortunately, there's no such opportunity. You can add relations only between posts.

[@romulogonzalez739]

Hi, I would like to add posts relations to a form, this way the registered user would be able to submit several post types and relate them, I dont know if that is possible. Other way would be adding a listing grid in a single page and in post query options , post and author parameters include %current_author%, I DONT KNOW IF I COULD DO IT, PLEASE HELP ME.

[@Crocoblock]

Hello Romulo! Please kindly contact our Support team at crocoblock.com/help-center/ and we'll gladly assist you with your request ;)

[@ratfinder7812]

Is it possible to set it up, so a person never has to see the backend of Wordpress to input new information, a front end input form and then a search to render the information on the same page... service information table, billing information table, maybe a multi technician schedule calendar and so forth,

[@Crocoblock]

I apologize for the late reply! You can set different roles to your users so that only the site administrator could have access to the backend. As for the search, you can use either Ajax Search or Search widget from JetSmartFilters.

[@graceresourcecentre1200]

Hello will this product help me get my project done? i will be using [woocommerce ,woocommerce-vendor , crocoblock] --- project goal is create backend access for vendor ability to upload products monitor orders sales etc create bookable product with ad-ons . like pickup time, delivery location, membership-additional meta fields and use relationship etc the industry will be using this is mostly travel vacations.

[@Crocoblock]

Hello! Yes, with Crocoblock dynamic plugins you can create the booking system, plus the WooCommerce integration is included. For example, with the Dynamic Templates (crocoblock.com/dynamic-templates/) you can install a ready-made site and customize it according to your needs :)

[@shaolin60]

I trying to relate original greek text to several translations and then compare translations and may change translation on-fly. In left column original ancient text and in the right column translated text with opportuniny to change different translator. Any advices?

[@shaolin60]

wht is the example for many to many?

[@Crocoblock]

Hi, Алексей! Looks like your case needs to be checked individually. Could you be so kind to submit a ticket at support.crocoblock.com/support/home/ ? We'll investigate your case and try to offer the best suiting option :)

[@shaolin60]

@@Crocoblock Thanks, I will!

[@claudiushelmschrodt6228]

Definitely interested in more advanced relationships!

[@Crocoblock]

In case if you need any assistance with the relations, please feel free to contact our Support :) crocoblock.com/help-center/

[@AttyKev]

Thank You Paul C! RDBMS made easy

[@alexandresaldanha4626]

Where can i learn how to make a single post with custom tabs getting information from different post types? Thanks anyway :D

[@Crocoblock]

Hello! Single Post template pulls info from one CPT only. If you use one-to-one post relations, here's a tutorial crocoblock.com/knowledge-base/articles/how-to-establish-posts-relations-with-jetengine-creating-one-to-one-posts-relation/

[@massibob2004]

Thanks for this video. I don't know when i have to use Taxonomies or new post types. For example, i have MyUsers, and their companies. Should i create 2 differents post types with a relation "one to many" or a taxonomy called "company", inside the MyUsers post type ?

[@Crocoblock]

Hi! Could you please describe in more detail what you would like to achieve?

[@massibob2004]

@@Crocoblock I have custom posts : job and worker I create a relationship: job to worker (one to many) Inside the worker page, i would like to display the name, description, etc. of the job of the worker

[@massibob2004]

Actually i use the listing with a post query. How can we use a dynamic field and display the related field ?

[@Crocoblock]

@@massibob2004 thank you for your explanation! Let's go step by step. 1. Firstly, you need to create 2 CPTs (job and workers); 2. Then, you need to create a relation one to many; 3. The next step is to add the needed posts to your CPT; 4. Go to the “parent” posts menu tab, open every parent post and assign “child” posts to it. This can be done in the Related Posts section of the right-side menu; 5. Then, you need to create a listing for your parent post and display data with the help of the Dynamic widgets; 6. Open the single template and add the Listing Grid and choose the listing you've created before; 7. Open the Post Query section in the Listing Grid and choose Post&Author parameters and paste the macro prnt.sc/1qji6ep %related_parents_from|job%. Please note, that instead of the "job" you need to paste your parent post type slug that you can find here prnt.sc/1qji9kd . After that, the needed post will display in the listing for parent posts. Please, check and let me know if it helped.

[@massibob2004]

@@Crocoblock nice. Thank you. 1- Is there another way to access in child/parent post field directly without a listing ? 2- if 'category' is a taxonomy of 'job', and i want to display it in a worker page, do i use a listing too ?

[@marcusburnett890]

Your videos are so straight forward and great, thanks for what you do. I’m building a home building website and can’t determine if their communities should be a taxonomy, or a custom post type? I have a CPT set up for “home plans” but each community has its own landing page with its own dynamic content. I don’t know whether the community should be a CPT and “parent” of home plans, or if it should instead be a taxonomy? Any advice on this and could it be either or? Based on this video it seems the relationship angle would be the harder approach.

[@Crocoblock]

Hi Marcus! I'd offer you to contact our Support team to discuss your case and to explore it in more details: support.crocoblock.com/support/home/ I believe if we take a closer look at the issue we'd offer you some solution :)

[@ManuelGraphFilms]

If I am creating a websites for series. Do I select one to many? or many to many? Perhaps one to one? Im confused

[@ManuelGraphFilms]

I figured it out yesterday. Relationship should be One to Many

[@Crocoblock]

@@ManuelGraphFilms Hi! Sorry for the delay with an answer! Please, also check this tutorial - crocoblock.com/knowledge-base/articles/how-to-choose-the-needed-post-relations-and-set-them-with-jetengine-plugin/

[@willqu8932]

Very useful video! Thank you for the info. For a current "pool" website I am working on, I'd like to have a gallery section. Ideally, at upload you can pick the colour (32 colours) and type of pool (18 pool types). Each pool photo uploaded to that gallery section would be displayed on a single gallery page with filters to sort through pool types and colours. The same photos would also need to be shown on the specific colour pages, and pool type pages. I can see how I would accomplish this by creating 576 (32x18) gallery posts for each combination of colour and pool type, setting up relationships between the Parent gallery and Child colour/pool types. But would there be a more simple way?

[@Crocoblock]

Hi! Thank you for your feedback! Unfortunately, this is the only opportunity to achieve this.

[@willqu8932]

@@Crocoblock no worries, keep it up with the great videos!

[@rocster01]

this is SUCH good timing :-)

[@Crocoblock]

@Jack Saat Couldn't agree more :)

[@bompard07]

Thank you very very much for this brilliant video. I'm also really interested in little more specific video. I'm struggling with 2 many to many relationships that I can't achieve gd day Christophe

[@Crocoblock]

Glad that you loved Paul's video ;) If you need our assistance with your questions, please kindly contact us via tickets system, messenger, live chat, or even via Zoom caal: support.crocoblock.com/support/home/ ;)

[@onlinelocalmarketing7356]

Can relationships be defined through custom forms? So, if a frontend form let agents create listings, can the relationship from the video be created?

[@Crocoblock]

Hi! Could you please describe in more detail what you would like to create? How the form should work?

[@onlinelocalmarketing7356]

@@Crocoblock A frontend form creates a child item (listing) and creates the relationship with its relatives, at least the parent (agent). I don't see how to create the relationship by form action.

[@Crocoblock]

@@onlinelocalmarketing7356 please, check this tutorial bit.ly/3rAjsq4

[@darylmeese9621]

@@Crocoblock Thank you. But I need to make the relationship when the child object is being created on a frontend form. Is that possible?

[@Crocoblock]

@@darylmeese9621 Hi! There's no such opportunity with JetEngine, but you can achieve this with the JetFormBuilder. Please, contact our support crocoblock.com/help-center/

[@onlinelocalmarketing7356]

Is it possible to create relationships between CCT or between CPT and CCT yet?

[@Crocoblock]

Hi! Right at the moment, there's no such opportunity. You can set relations between CTPs.

[@onlinelocalmarketing7356]

@@Crocoblock Is this something that might be doable with Query Builder if I add particular fields myself? BTW, this is a significant limitation to my use cases so, if there's a place to add it to a feature request, please do.

[@Crocoblock]

@@onlinelocalmarketing7356 Unfortunately, this can't be done in that way. Please, feel free to submit a feature request to Git repository github.com/CrocoBlock/suggestions and our team will explore if it's possible to implement.

[@HassanAleem]

wouldn't it be better to use the profile builder in jetengine for the agency with sub-users as agents? I know the tutorial is about relationships :) just asking

[@Crocoblock]

Hi Hassan ;) Your comment makes sense :) But in this video we wanted to highlight the relations aspect.

[@calmfamily]

@@Crocoblock How would you create a relationship with a user in this scenario?

[@ramelolozada2048]

Hello to integrate google sheet to post into my property listing using jetengine?

[@Crocoblock]

Hi! As for now, there's no such opportunity.

[@ramelolozada2048]

@@Crocoblock How about using integration with a zapier or pabbly?

[@roshedulalamraju7936]

I need the agent to be clickable and open a dynamic template with all property list available in the template and the template should be only one for all agents to change all informations in a single template dynamically. Thanks in advance

[@Crocoblock]

Please submit a ticket at support.crocoblock.com/support/tickets and describe the case in more details, and our Support team will gladly assist ;)

[@roshedulalamraju7936]

@@Crocoblock it says sorry the portal is not available in your location

[@Crocoblock]

@@roshedulalamraju7936 You can try our chat crocoblock.com/help-center/ ;)

[@PswACC]

Does JetEngine work with Oxygen? Can you display relationships in Oxygen templates with JetEngine?

[@DMLeBeau]

Hi Paul. Great video. I think you forgot to show us how to display all properties related to the same agent since the relationship established was One to Many. It could be a button (i.e View other agency or agent managed properties) that links to Thanks

[@Crocoblock]

Hello! On a Single Agent post type (a Parent one), you need to drop a Listing Grid and set the Query settings to show its children. Here's a tutorial: crocoblock.com/knowledge-base/articles/jetengine-post-relations-how-to-display-the-related-child-posts-in-the-listing-grid/

[@DMLeBeau]

@@Crocoblock WOnderful Paul, it works now. Thank you for helping and guiding me

[@herbertwaa]

Cool video. can we have a video for user or author relationship to custom post. that way a user is assign to the end of the custom post after they register and make a post?

[@Crocoblock]

Hello! Could you be so kind to provide me more details about this issue?

[@herbertwaa]

@@Crocoblock I wanted the register users information, name, Email and phone number used for registration to show when they post a listing automatically on the single page view with the post.

[@Crocoblock]

@@herbertwaa Please take a look at the Profile Builder, where users have the opportunity to submit posts from the frontend, from their personal accounts: crocoblock.com/knowledge-base/articles/jetengine-user-profile-builder-overview/

[@herbertwaa]

@@Crocoblock i have see the video but it doesn't answer my question. you see in craiglist when you register, phone number and email is taken from you. now, that information is show on the single page view of your listing, so that the user can contact you the author, everytime you post a new listing, your contact details are added. what i want to know is how jetengine can do that i.e jetengine and elementor?

[@Crocoblock]

@@herbertwaa Could you please create a ticket at support.crocoblock.com/support/home/ and describe your case in details. If you have any reference sites where you saw similar functionaluity, that woukd be great. Our techs will check your issue and offer you our solutions. Thank you!

[@miguelhuerta00]

Does this works with wordpress posts? I tried to place the slug but it doesn´t shows anything *I´m using a relation for wordpress posts and woocommerce products

[@Crocoblock]

Hi Miguel! Yes, it should work. Please, submit a ticket support.crocoblock.com describe your issue in details and provide your Dashboard credentials. Our tech support will gladly help you :)

[@kankadev]

Is it still the way how to get data from a relationship with macros etc.? The video is 3 years old. I have a listing inside a listing. Parent CCT is Company, child CCT is employee... In the listing of companies I show all companies. Inside each company I want to show employees. There is a relationship one to many but in the employee listing I see ALL employee. I want to see only employee belong to the company, not all CCTs at once.

[@Crocoblock]

Hi! Could you please check this tutorial? kzbin.info/www/bejne/aouxd5J4iaeEbq8 It displays the workflow for new Relations.

[@RubabORSalma]

can we filter them ?

[@Crocoblock]

Hi! Could you please check this guide? crocoblock.com/knowledge-base/jetengine/jetengine-how-to-filter-related-post-items/ If you still have any questions, contact our support team, please crocoblock.com/help-center/

[@ResonanceEvents]

I could swear that Paul did a video explaining hierarchical post type relationships (not filters - but how one goes about creating a hierarchy of post types and why). Crocoblock has a video but it moves too quickly and assumes the viewer understands things that they don't. Again, I swear there was a really great video on this but I neglected to bookmark it. Can anyone help me find it?

[@Crocoblock]

Hello :) Did you mean this one? kzbin.info/www/bejne/iYKlnmqjf7FmmNE :)

[@malaga16]

Dear Criciblock team! Please help me! I makeing an event, with speakers. This video is good for me, but please help me, how can i list only the speaker's (agency in your video) name, without any other data and image?

[@Crocoblock]

Hi :) When you create the layout of your Listing item you can organize it as you wish by means of the Dynamic widgets. You can simply not use the image :) crocoblock.com/knowledge-base/articles/jetengine-listing-functionality-how-to-create-a-new-listing-to-apply-for-the-certain-post-type/

[@bx7956]

how can use this with profile builder users form? i can do it??

[@Crocoblock]

No, sorry, but it won't work for the Profile Builder.

[@roshedulalamraju7936]

Please create video on " Front end register for agency" " frontend add new property " for agencies.

[@Crocoblock]

Hello! Please kindly check the following video dedicated to the frontend posting kzbin.info/www/bejne/h2LPh5iVoNWHhZI :)

[@atefehgholamin]

Thank you so much

[@bitiplus7564]

I still don't get it and it's not working for me. I have two CPTs: 1. Users 2. Events I have Relations: 1. events -> users | One to many Users === Child and Events === Parents. I have listings: Events Card List (events posts) I want to view my events in profile page: So I have created a new listings grid with this query %related_parents_from|events% I have tried so many ways and it's not working

[@Crocoblock]

Hello! Sorry, but you can't establish relations between Users. Only CPTs.

[@orelhassid5812]

@@Crocoblock Ya, this is why I have created Users CPTs. When a new user is register a new User Post is also created with a custom field of user_id. So I linked between users auth to users CPT. So I create a relations between Users CPT to Events CPT (this is what I meant in the comment above) (I was inspired by I how usually develop the database in Firebase where you create Users collection for extra fields) The only problem now is to make the query. I want to get all events where the custom field user_id is in the list. For example: Event: Crocoblock meeting Users(attendees): Orel, Mike Every Users CPT has a custom field called user_id that is equals to Users auth user_id Is all clear now?

[@Crocoblock]

@@orelhassid5812 Thank you for clarification! Could you please submit a ticket at support.crocoblock.com/support/tickets so we could check your case individually. Thank you!

[@압둘라-j6i]

I copied your video clip. The relationship between agency and Property is linked on the page screen. %related_parent_from|agent% does not connect I'm wordpress 5.9 JetEngine. I am using 2.11.4, for your information, I am a Korean. I want another mothod ^^

[@Crocoblock]

Hi! Please, contact our support on this issue - crocoblock.com/help-center/

[@sergiogz47]

Ola, eu preciso construir no wordpress um controle de orçaento familiar ( receitas, despesas e fluxo de caixa) e preciso sabre se com o Jet Engine consigo criar uma tabela onde cada colunas seria um mes do ano e cada linha seria um tipo de receita ou despesa e cada celular seria a soma dessas receitas ou despesas de cada mês.

[@Crocoblock]

if I get you right, then you need to register the family budget on your website additionally, you need to generate the page with the jetengine where each column would be a month of the year and each line would be a type of income or expense and then some calculated operations if so, then you can achieve it with organizing the structure with the relations or repeaters crocoblock.com/blog/wordpress-relations-use-cases/ How to create a dynamic repeater kzbin.info/www/bejne/maW4pGCYgbqUgbcsi=mwT8KK6ZgWyBRZI3 and all calculation operations can be achieved with the calculated field in the form - jetformbuilder.com/features/calculated-field/

[@sergiogz47]

@@Crocoblock Tanks very much, i'll try the links and give a feedback.

[@alihmd1628]

Everything worked perfectly except when adding the macros, the data did not show up

[@Crocoblock]

Hi! Please, contact our support on this issue - crocoblock.com/help-center/

[@KokiFilip]

Thanks :)

[@madhukarchopra5496]

It states "NOTE! Parent and child post type can’t be the same type of the post." How can you add relationship within same post types. Say post type is family members. The parent is a family member and child is member. The siblings are also members. So how to create relationship within same post type in jet engine.

[@Crocoblock]

Hello! As stated, parent and child posts should refer to different Post type: crocoblock.com/knowledge-base/articles/how-to-choose-the-needed-post-relations-and-set-them-with-jetengine-plugin/

[@madhukarchopra5496]

@@Crocoblock I get that. I want to know that is there a way to create bidirectional relationship within same post type. As if we have a members post type for family members and all the members are related to each other. They are children, parents, grandparents, siblings, spouse etc. How to show their relationship. I am currently working with pods and looking for similar software which can give similar results.The site created using pods is: choprafamily.madhukarchopra.in There's a bidirectional relationship which works within same post type.

[@Crocoblock]

@@madhukarchopra5496 Thank you for the clarifications! Unfortunately, there's no way to establish similar relations with JetEngine. We've got the Grandparent/Grandchild Relations, however, they refer to different post types (crocoblock.com/knowledge-base/articles/jetengine-hierarchical-posts-relations-how-to-build-a-grandparent-grandchild-relations/).

[@madhukarchopra5496]

@@Crocoblock Thanks for quick reply. You can have meta field post type. Can you get related info from connected post from dynamic field widget like title image or meta field of that connected post.

[@learnwp6155]

Why is this relationship even necessary? Isn't it possible to insert the agency already in the properties?

[@Crocoblock]

Relationships allow to pull the agency dynamically. For, example, if there are a large number of properties, it's not handy to assign the agent to each item manually.

[@shaolin60]

If you going to create several agents, why ONE to many?

[@Crocoblock]

For this particular video Paul decided to demonstrate how relations work based ion this type :)

[@Swisrx]

Awesome

[@kurniadinata9136]

Nice

[@ahunter6756]

nice

[@AniketNBorhade]

Please create advance videos

[@מרדכישלמהארז-ז3נ]

it is possible to build question answers? with vote up/down?

[@Crocoblock]

Please, contact our support team for clarification of your question- crocoblock.com/help-center/.