We need a way for the user to only be able to see and edit their own data but the admin needs to be able to see everyone's data entries and to be able to export all of it at the same time. When we tick the box for front end editing with restrictions to the user we aren't able to edit it in the backend with admin privileges.
We are using it to keep track of service hours for students in a dental program and it won't let us use anything other than whole numbers. So we need to be able to have 4.5 hours etc but it doesn't allow us to do that.
We need a way for the user to only be able to see and edit their own data but the admin needs to be able to see everyone's data entries and to be able to export all of it at the same time. When we tick the box for front end editing with restrictions to the user we aren't able to edit it in the backend with admin privileges.
- When you check Users see and edit only their data administrator can't see other users data. In this case we have a workaround. You can create a new MySQL based table that will fetch all data from the first table. So you should create new wpDataTable from query:
SELECT * FROM wp_wpdatatable_{some_number}
You can see at firs wpDataTable what table from database is using that wpDataTable under MySQL table name for editing field and then use that table name in query.
We are using it to keep track of service hours for students in a dental program and it won't let us use anything other than whole numbers. So we need to be able to have 4.5 hours etc but it doesn't allow us to do that.
- Did you set Float in Column Type selectbox for that column? If it is Integer please change it to Float and you'll be able to add decimal numbers.
Thanks so much, everything worked perfectly! We will be using this plugin in the future for many more things. It has made this functionality work like a dream! Great job, much appreciation!!
This was working with float set for the integer but it is not now. When the user tries to enter it in the front end it allows it to be entered and seems like it is saving the data but the actual table does not show the correct number. For instance it allows me to enter 5.25 and apply it and it looks like it's saved but when I click ok the table just shows 5.00.
This is not issue with wpDataTables than in the database for column Hours type is set to int(11) probably. You should go to the table in the database and change the type of this column to float(16,4), After that you'll be able to save this column with decimals.
I updated the plugin and made the change to the database like you said and now the front end will not save the data. What am I doing wrong? Frustrated!
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check PRIVATE so nobody can see it except us.
Also please provide me the ID of that wpDataTable that you are trying to edit from the front-end and please provide me database login credentials.
Can you also please send me the ID of the table and name of the column that you are trying to edit and that is not working. Also can you send me database login credentials so I can take a look at the database structure?
I am glad that you resolved the issue. If you have any other questions don't hesitate to open a new ticket. We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
We need a way for the user to only be able to see and edit their own data but the admin needs to be able to see everyone's data entries and to be able to export all of it at the same time. When we tick the box for front end editing with restrictions to the user we aren't able to edit it in the backend with admin privileges.
We are using it to keep track of service hours for students in a dental program and it won't let us use anything other than whole numbers. So we need to be able to have 4.5 hours etc but it doesn't allow us to do that.
Hi deniselwitt,
Thank you for the purchase.
We need a way for the user to only be able to see and edit their own data but the admin needs to be able to see everyone's data entries and to be able to export all of it at the same time. When we tick the box for front end editing with restrictions to the user we aren't able to edit it in the backend with admin privileges.
- When you check Users see and edit only their data administrator can't see other users data. In this case we have a workaround. You can create a new MySQL based table that will fetch all data from the first table. So you should create new wpDataTable from query:
SELECT * FROM wp_wpdatatable_{some_number}You can see at firs wpDataTable what table from database is using that wpDataTable under MySQL table name for editing field and then use that table name in query.
We are using it to keep track of service hours for students in a dental program and it won't let us use anything other than whole numbers. So we need to be able to have 4.5 hours etc but it doesn't allow us to do that.
- Did you set Float in Column Type selectbox for that column? If it is Integer please change it to Float and you'll be able to add decimal numbers.
Thanks so much, everything worked perfectly! We will be using this plugin in the future for many more things. It has made this functionality work like a dream! Great job, much appreciation!!
Hi deniselwitt,
You are welcome. We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
This was working with float set for the integer but it is not now. When the user tries to enter it in the front end it allows it to be entered and seems like it is saving the data but the actual table does not show the correct number. For instance it allows me to enter 5.25 and apply it and it looks like it's saved but when I click ok the table just shows 5.00.
Hi deniselwitt,
This is not issue with wpDataTables than in the database for column Hours type is set to int(11) probably. You should go to the table in the database and change the type of this column to float(16,4), After that you'll be able to save this column with decimals.
Hope this helps!
Ok great! Thanks for the quick reply!!
I updated the plugin and made the change to the database like you said and now the front end will not save the data. What am I doing wrong? Frustrated!
Hi deniselwitt,
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check PRIVATE so nobody can see it except us.
Also please provide me the ID of that wpDataTable that you are trying to edit from the front-end and please provide me database login credentials.
Hi deniselwitt,
Can you also please send me the ID of the table and name of the column that you are trying to edit and that is not working. Also can you send me database login credentials so I can take a look at the database structure?
Hi deniselwitt,
I am glad that you resolved the issue. If you have any other questions don't hesitate to open a new ticket. We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!