re: What is this checkbox for in the Form settings?
“Whether or not to redirect to a page after a successful submission”.
By default when an entry is submitted by a user the page will display a processing and then a thank you message. If needed you can optionally redirect to another page in your site. To enable the redirect, enable the Redirect option and then choose the page that the user should be redirected to.
YOu can only redirect to a separate page as an option. There is not an option to redirect pack to the user’s entry.
I do understand what you are asking for and have added it to my feature request list.
re: I was able to come up with the MySQL query though as mentioned above.
Well, yeah, with code it is definitely possible. When I said it was not, it was in context that there is no setting or configuration option available.
You could very likely use this:
This function will return the URL of the user’s profile detail page. You possible could use this to redirect using the
wp_safe_redirect( $location, $status ); function to do the redirect … rather than making a SQL query.
Hope this helps!