For future reference, please use English, as it is the only official support language, and we don't like using Google Translate since a lot can be lost in translation.
I believe you're already on the Mon Compte page in the screenshot, correct?
If that is true, you have a table there, and it is editable:
You simply need to click on NEW above the table (to the right), and you'll be able to add a new row.
No need to apologize for your English, it's quite good.
I don't know if that page will have a different URL for every user, or will it be a new page for every user. You can use the "Users see and edit only own data" feature if you have a manual, or an SQL query based table. You will need to add an integer column, which will store user's User ID, and it will be used to display the data only to the currently logged-in user. This way you can have one big table with all users' data, and when they visit their page (when logged in), they will only be able to see the rows where User ID column contains their user ID.
You can have one table for your users, and another one for your administrator. That is - have one database table for both, but two wpDataTables. Let me explain:
Create one table for the Administrators with all possible columns in it + user ID column. Then create a new SQL Query based table for the users, like this:
SELECT user_id,
pseudo_boat,
real_name_boat,
boat_type,
boat_width,
boat_length,
boat_draught,
sail_number,
classe
FROM original_table
WHERE user_id = %CURRENT_USER_ID%
That will display only the selected columns from the original table, and it will also limit the view for logged-in users, so they can only see their entries.
Uploading the certificate can be done by choosing the editor input type for that column to be "Attachment", and calculation (formula) column can be added at the end, and it will calculate what you define in the formula editor. You can read more about this in our documentation.
If you enabled "Users see and edit only own data", and that User ID field is the "User ID" column, it cannot be changed, because it is automatically entered by the plugin. If you were to log in with a different account, you wouldn't be able to see the entries made with the admin account, and you would see the ID of that other account.
I'm sorry, but I don't see any attachments. Could you please send them again.
Also, since you purchased the plugin, can you please open the ticket in wpDataTables category, because pre-purchase tickets are only for questions made before the purchase.
That's how the feature works. The ID of whoever edits the row will replace the original ID.
If you, as an administrator, want to edit rows for your users, you need to create a new SQL Query based table, where you will query the original table, but without the "Users see and edit only own data" feature, like this:
SELECT * FROM jc_wpdatatable_1
That table can be used for your administrators to modify everything except for the User ID column. Since you don't have the "Users see and edit only own data" feature enabled, that column won't be affected by edits.
Bonjour,
Je souhaiterai savoir si il est possible de créer un tableau modifiable dans " mon compte" grâce à votre extension ?
Je voudrai tableau personnalisable par compte ( utilisateur ).
Un exemple en pièce jointe.
Merci d'avance pour votre réponse.
En vous souhaitant une excellente journée !
Hello Clément
Thank you for your purchase.
For future reference, please use English, as it is the only official support language, and we don't like using Google Translate since a lot can be lost in translation.
I believe you're already on the Mon Compte page in the screenshot, correct?
If that is true, you have a table there, and it is editable:
You simply need to click on NEW above the table (to the right), and you'll be able to add a new row.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Sorry for my english. The screenshot is a fake that I made with photoshop, It was to explain you what I want to do.
I want that each users has his personnal CRUD table in his private space.
Is it possible ?
Regards
I see Clément.
No need to apologize for your English, it's quite good.
I don't know if that page will have a different URL for every user, or will it be a new page for every user. You can use the "Users see and edit only own data" feature if you have a manual, or an SQL query based table. You will need to add an integer column, which will store user's User ID, and it will be used to display the data only to the currently logged-in user. This way you can have one big table with all users' data, and when they visit their page (when logged in), they will only be able to see the rows where User ID column contains their user ID.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hello,
Here is a picture of what I would like to do.
Is it possible ?
Thank you for your reply
Hello again Clément.
You can have one table for your users, and another one for your administrator. That is - have one database table for both, but two wpDataTables. Let me explain:
Create one table for the Administrators with all possible columns in it + user ID column. Then create a new SQL Query based table for the users, like this:
That will display only the selected columns from the original table, and it will also limit the view for logged-in users, so they can only see their entries.
Uploading the certificate can be done by choosing the editor input type for that column to be "Attachment", and calculation (formula) column can be added at the end, and it will calculate what you define in the formula editor. You can read more about this in our documentation.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hello,
Thank you for your reply !
So I bought a license.
But I have a new problem when I modify a line on the backoffice side the "user id" of the user is replaced by that of the admin account.
I cannot block this change.
Another problem, I cannot load an attached file in the front office.
Thank you in advance for your reply
Hi again Clément
Thank you for your purchase.
If you enabled "Users see and edit only own data", and that User ID field is the "User ID" column, it cannot be changed, because it is automatically entered by the plugin. If you were to log in with a different account, you wouldn't be able to see the entries made with the admin account, and you would see the ID of that other account.
I'm sorry, but I don't see any attachments. Could you please send them again.
Also, since you purchased the plugin, can you please open the ticket in wpDataTables category, because pre-purchase tickets are only for questions made before the purchase.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hello !
Users see and edit only own data is actived
here are the attachments !
1 - adding a line by a user
2 - line overview in the backoffice
3 - modification of the line in the backoffice
4 - the user id is changed to that of the admin
5 - the line no longer appears for the user
Hi again Clément
That's how the feature works. The ID of whoever edits the row will replace the original ID.
If you, as an administrator, want to edit rows for your users, you need to create a new SQL Query based table, where you will query the original table, but without the "Users see and edit only own data" feature, like this:
That table can be used for your administrators to modify everything except for the User ID column. Since you don't have the "Users see and edit only own data" feature enabled, that column won't be affected by edits.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Thx you !!
You're welcome, Clément
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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