Creating a One-to-Many Relationship - Child Forms and Child Reports in Caspio

[@taylorsnook7933]

Great video, thanks for posting! @CaspioInc My question is are you embedding the datapages on a Caspio HTML (DataPage Type) or are you embedding them in a site hosted outside of Caspio (ie. on your server or CMS)? Thanks again, Taylor

[@CaspioInc]

Hi, Taylor - thanks for the feedback! Regarding your question, the web pages are hosted internally on our server but you can host them with any provider of your choice (ie. wordpress, 1and1, godaddy, etc.). You can also embed our DataPages with any CMS provider you're comfortable with. For example, in this video we used Yola to embed Caspio's DataPages: kzbin.info/www/bejne/rnawqGaNhNyiiqM Good luck and let us know if we can be of further help!

[@kiaf9539]

Seems the diagram of your details.html page is upside down. Your submission form is actually on top while the search and results in under. Hopefully this wasn't too confusing for newer users. Otherwise great video.

[@CaspioInc]

Thanks for pointing that out, Kiamarz. Glad you enjoyed the video. Let us know if you have any ideas for any future videos.

[@kiaf9539]

CaspioInc No worries: Another video on one-to-many relations regarding how to effectively delete the "many" when the user wants to remove the "one". This would be amazing. We have no solution for this, currently we make these changes manually which is time consuming and bothersome for our customers to have to ask. Additionally, when deleting we would rather not "delete" the record, but move it out of the users account so it can be restored later if necessary. Thanks!

[@ParabellumHistory]

Nice tutorial, very useful, but I have a question: In the comments, how does the comments table know which contact you are commenting?

[@CaspioInc]

Thanks for asking! Comments and contacts are linked by a "Contact ID" field that’s passed over via a query parameter. Learn more about passing parameters here: howto.caspio.com/parameters/

[@leefretter6597]

When i click the details href i then have three login pages for the details, comments form and comments section. How do i prevent this ? if i turn off the auth for those pages will it still record who submitted the note ?

[@CaspioInc]

Hi, Lee - you might benefit from the following tutorial: howto.caspio.com/authentications-and-connections/authentication/create-a-standalone-login-screen-2/ if you wish to have a login screen that first redirects the user to the proper page. Then, upon logout, users will always be redirected back to the login screen rather than seeing those 3 login boxes. Also, be sure to configure the authentication "advanced" options to include the logout URL AND automatic redirect URL upon logout. We don't normally provide troubleshooting answers via YT so please, if you're still unsure of how to do this, connect with our support team directly. Thank you and best of luck.