Hello Jack.

I apologize for the late response.

If I understood you correctly, you managed to add the unique user id, but when you click on "Add new" or "Edit" modal, there are no values displayed one of the drop-downs?

Are you using a foreign key? If that is true, there is a known issue that will be fixed with the next update. You can open the Editor, under Plugins, select wpDataTables from the drop-down in the top right, and select source/class.wpdatacolumn.php file. Please take a look at the attachment, and comment the lines of code like shown in the screenshot. That'll allow the users to view all possible values defined by the foreign key.

We apologize for any inconvenience this may have caused.

If this is not the case, and you created a table like explained in our documentation, then the user id column should be set as AUTO_INCREMENT and be a unique column in PHPMyAdmin, and if it is set like that, it should work correctly.

Please let me know.

Best regards.

Hello again Jack.

You can try creating a query that'll return the data from that external db, which has the Calendar ID, and to join it with the WP table that saved that ID in WP user profile. We didn't have such case so far, but you can try it. Please note that writing queries doesn't fall under support for the plugin, but something like that should work.

As for foreign keys - that is not a bug, because the foreign key column is string by default, which is why it is saved like string in database.

Best regards.

Hi Jack.

I'd like to look at your website, if at all possible?

Can you, 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 Reply so nobody can see them except us.

Best regards.

Hello again Jack.

As you can see, I created a new table to try and get the data you were hoping for. The thing is that - if you want three columns to be pulled using a foreign key, you need two source tables (in your case), that need to have a unique auto_increment integer value assigned.

For example, you'd need to have a Student table, where each row will be a new student, and each student has to have a unique ID; to use "Last Name" and "First Name" columns in a new manual table that has Foreign key relations, there has to be an ID column that matches the unique IDs for each student. Let's say you have a source Student table:

When you create a new manual table, it has to look like this:

So, row for ID: 1 - under Last name - you need to assign a foreign key which will Choose a source wpDataTable from the previous table, Store value will be "Student ID" for (let's say) Jane Doe - 2, and display value will be "Student Last".

Then, row for ID: 1 - under First name - you need to assign a foreign key which will Choose a source wpDataTable from the previous table, Store value will be "Student ID" for (let's say) Jane Doe - 2, and display value will be "Student First".

Same goes for the already existing "Scheduled_apointments" table. But note that "Educator_WP_ID" has to have the same ID as the student in question. So if you have Educator_WP_ID set to 3 and Student ID set to 2, it's not going to work.

Again, they all must have unique auto_increment column.

Also, please avoid using " ` " when generating queries. That may cause an issue with search, generation and filtering of the table. So, for [wpdatatable id=6] query can look like this:

SELECT Appointment_ID,
       Student_Last,
       Student_First,
       Student_Email,
       Student_Time_Zone,
       Student_Label,
       Notes,
       Educator_Full_Name,
       Educator_WP_ID,
       Educator_Appointment_Time,
       Appointment_Type,
       Zoom_Meeting_Room,
       Canceled
FROM   Scheduled_Appointments

May I ask if you followed the tutorial in our documentation. You can recreate the same table shown there, and it may provide a clearer picture of what needs to be done in order for foreign keys to work normally.

Please try this and let me know if it works.

Best regards.