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.

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.

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:

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.

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.

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:

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.

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.