Hiya! 

I am currently working on a project using wpDataTables and essentially I'm going to need 14 tables with all the same column headings and table settings - in terms of design and functionality (sorting, filtering etc.). Each of the 14 tables will be named differently and will hold different information to be entered by different users.

I was just wondering if it's possible to create a template table with all my necessary columns so that I can build my 14 tables from this template allowing each to hold different data. Ideally, as I change the settings on the template table (display/sorting/filtering etc.) the same changes will apply to all 14 tables that use the template.

I believe this is what I'm looking for but I have several questions:

1. Where do I obtain the correct User ID and how does the table auto-populate this field correctly depending on the user? 
2. Instead of User ID as an Integer, can I use the Current_User_Login define to each user e.g. "Australia", "Cuba", "Denmark", "Iceland"?
3. Under each table, I would like to have the same charts, with only the specified user's data being displayed. If I follow the link above, will the charts being displayed also only show the user's data?
4. Am I correct in assuming that using this method I will only need to create one "Master" Table and one version of each chart as opposed to 14 Tables and 14 copies of the same chart?

Hope that all makes sense :)

Thanks in advance!

Hi Aleksandar,

Thanks again for your tremendous help and advice in starting my project. To add some context, I've created one master table, ensuring users can only view the data rows they have added.

As I progress through the development, however, I am sure to have more questions. One pressing issue I have involves the order of options displayed in SelectBoxes.

1. On several of my columns I have chosen to use the SelectBox Input Type, defining the values in a list. After inputting some data I realised I needed to add an option or two. Despite adding the new options in my preferred position in the list, upon saving they get pushed to the end. Is there anyway to maintain the list order?
   E.G. Sort options alphabetically with options "None" and "Other" at the bottom?
2. Another question I have is whether it's possible to have an automated email sent to a specific email address when the Master Table is updated (like a notification email)?

1. If I re-type the list will the options reset in the data I already have? I'm a little worried I'll have edit 100+ lines of records re-selecting the options I'd have to delete and re-enter.

2. Do you know of any workaround? Perhaps something that detects when a new row is added to the table and triggers and email?

Hi Aleksandar

I believe I have set up my project's data tables the best way possible for my needs, however, I'm struggling when it comes to how best create my graphs.

I have 2 tables as follows:
1. Manual Table: With users only seeing and editing their own data.
2. SQL Table: Displaying all records (to be used for the administrator's view).

Currently, when a user logs in they are redirected to the Manual Table to edit and view records. Underneath this table I'd like to have several charts, only factoring in the data that matches their username.

Charts:
1. Bar Chart: (X) Month, (Y) Count of Records
2. Line Chart: (X) Month, (Y) Sum of a Column
3. Pie Chart: Ratios of 3 select options in column
4. Pie Chart: Ratios of 2 select options in column
5. Pie Chart: Ratios of 2 select options in column

I am finding the Chart Wizard to be very confusing when selecting the columns and series options.