For a User table based on user id, can i restrict the number of rows the user can add to their table based on their user level? how is this achievable?
i am sorry to disappoint you on this one, but at the moment we do not have any built-in option or a workaround to achieve limiting how many rows a user could add with our Plugin.
This is an interesting idea for a future option, though, you can add a development suggestion.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
The only custom workaround idea I would have at this time,
if you use our SQL Query based tables,
they are going to follow any restriction you set in your source Database table.
For example, in another case where we wanted to restrict that there are no duplicates in an SQL Table Column;
this can not be done from our Plugin side,
but you can set a UNIQUE CONSTRAINT through your Database Management Tool (such as PHPMyAdmin for example).
I am delighted to hear that this has been resolved. Thank you for letting us know.
Anything else that we could assist with, please don't hesitate to create new tickets.
Have a great day! :)
Hi Syed,
no problem, i am happy to advise.
Anything else that we could assist with, please don't hesitate to create new tickets.
Hello,
For a User table based on user id, can i restrict the number of rows the user can add to their table based on their user level? how is this achievable?
Thanks
Hi Syed,
i am sorry to disappoint you on this one, but at the moment we do not have any built-in option or a workaround to achieve limiting how many rows a user could add with our Plugin.
This is an interesting idea for a future option, though, you can add a development suggestion.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
The only custom workaround idea I would have at this time,
if you use our SQL Query based tables,
they are going to follow any restriction you set in your source Database table.
For example, in another case where we wanted to restrict that there are no duplicates in an SQL Table Column;
this can not be done from our Plugin side,
but you can set a UNIQUE CONSTRAINT through your Database Management Tool (such as PHPMyAdmin for example).
Unique constraint in MySQL serves to avoid duplicate entries in a table.
If you edit a field in the database, adding a unique constraint to it, something like this:
And it will not allow anyone to add the same name if it already exists in the table.
-
So, you can research online on places such as Stack Overflow and similar,
if you can find a function or a way to make this restriction on the Database Table,
then our Plugin should follow it, but I am not sure if something like that is possible at all right now even with custom workarounds, to be honest.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Okay thank you.
I am delighted to hear that this has been resolved. Thank you for letting us know. Anything else that we could assist with, please don't hesitate to create new tickets.
Have a great day! :)
Hi Syed,
no problem, i am happy to advise.
Anything else that we could assist with, please don't hesitate to create new tickets.
Have a great day!
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables