How to view cms form data in a table on website

Question:
How can i make the data in a CMS form be shown on website

What I am trying to achieve:
I have a website where you can fill out a form and this form data is stored in a CMS form collection. I wanted there to be a back office where someone with the password is able to go onto and view the data from this form. I created a table which has all the information and is connected properly. When I preview the website from the editor I am able to view the data but once I publish the site and look at the table it is completely empty. How can I solve this I cant seem to find anything.

Make sure that you set the Permissions to View the CMS Data to Anyone. This is because you have mentioned that the page you have created is already password protected. So this will prevent any unauthorised access even after the permissions are set to ‘Anyone’.

Read more about how to change the permissions here:

The collection im trying to display is a wix form collection that is connected to an order form visitors can fill out. I am for some reason not given the option to change the view permissions of the form. Is there any way to change this?

Try this out? Looks like this user faced a similar problem and managed to resolve it.