Add a button to your layout that uses Go To Layout to take the user back to the desired layout. This does not have anything to do with the database's URL.
Thank you for your response. What would be the best way to use a single layout new
For example I have a script on the Submit button that does the following once all the data is entered:
Open URL "mysite.com";
with the intent that it will commit the record. open the new URL(in a new tab) and close the window to the signup sheet for the user...but it doesnt work...When I hit submit it doesnt open the new url until I hit the link a second time and it closes the application but the window goes to the database homepage which I would not like them to see.
Do not use Open URL. Use Go To Layout just like you would if you had not published to the web.
Go to Layout ["new" (table occurrence name goes here)]
I don't see why you'd need Close Application.