Do you have an instructions specifically to setup a sheet that has only customer inputs or dropdowns? I've attached the link above to a spreadsheet that acts similarly in logic to what I am trying to achieve.
There are no instructions related to this, but you would be able to define data that's going to be available in a column. In column settings (of string-type columns), you can go to Data tab, and change "Possible values for column" from "Read from table on page load" to "Defined values list", where you would be able to define which values would be available in a "Single-value selectbox" or "Multi-value selectbox" editor type.
The file you shared with me contains multiple tables, which would all have to be created separately in the plugin.
I'm about to ask for a refund. Each time I ask for support it takes a few days and your response is not what I've come to expect from companies looking to hold onto clients. Part of the problem is the complexity of choosing where to start.
I will ask this again as I do not know what else to do. I am creating a soccer player worksheet where they can choose from options in some cells (like "Select Your Position") and enter their own personal results in other cells (like "Grade"). And when they login, they can see only their info and change their info whenever they login.
HOW DO I DO THIS! Please...if you do not have a video, please provide me with step by step instructions. Please begin at the beginning...what type of table to create, etc. Otherwise, I'm ditching this.
If you want users to see and edit only their own data, you need to enable "Users see and edit only own data" feature. That feature is only available in editable tables (manual, imported and SQL query based tables).
If you're creating a new table, my advice would be to create a manual table, where you would have one integer ID column, which will be the ID for the currently-logged-in user. So, when you enable Editing, in the Editing tab above the table, and enable "Users see and edit only own data" feature, you need to select that integer column as the user's ID column.
I'm not sure if I understand your approach correctly, but it sounds like you want to have a table with predefined rows:
And when users sign in - they can enter their grades into "Grade" columns; and have that process repeat automatically for all users?
That can't be done, because you can enter these rows before you enable "Users see and edit only own data" feature, but those would be the only rows you have in the table. So, when you enable "Users see and edit only own data" feature, your users will not be able to see these rows (because they were not entered by them, but by you, so your ID is stored in the ID column, not their ID).
You would need to duplicate these rows, as many times as you have users, like this:
So, if you were to create a table like this, and enable "Users see and edit only own data" feature afterwards, and select the ID column as the User ID column for editing; users with ID 1 would see the first 5 rows; user with ID 2 will see rows 6 - 10; user with ID 3 will see rows 11 - 15; user with ID 4 will see rows 16 - 20, and so on.
If I understood what you want to do, that's the only way you can do it.
All the data below, in the CSV file you sent me needs to be added in new wpDataTables (separate tables), just like what I did with the table above. Data formatted as your CSV file will not be imported into wpDataTables properly, and you won't be able to use it.
Do you have an instructions specifically to setup a sheet that has only customer inputs or dropdowns? I've attached the link above to a spreadsheet that acts similarly in logic to what I am trying to achieve.
Hello DORON
There are no instructions related to this, but you would be able to define data that's going to be available in a column. In column settings (of string-type columns), you can go to Data tab, and change "Possible values for column" from "Read from table on page load" to "Defined values list", where you would be able to define which values would be available in a "Single-value selectbox" or "Multi-value selectbox" editor type.
The file you shared with me contains multiple tables, which would all have to be created separately in the plugin.
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
I'm about to ask for a refund. Each time I ask for support it takes a few days and your response is not what I've come to expect from companies looking to hold onto clients. Part of the problem is the complexity of choosing where to start.
I will ask this again as I do not know what else to do. I am creating a soccer player worksheet where they can choose from options in some cells (like "Select Your Position") and enter their own personal results in other cells (like "Grade"). And when they login, they can see only their info and change their info whenever they login.
HOW DO I DO THIS! Please...if you do not have a video, please provide me with step by step instructions. Please begin at the beginning...what type of table to create, etc. Otherwise, I'm ditching this.
Here's the attached spreadsheet for my previous question.
Hi again Doron
If you want users to see and edit only their own data, you need to enable "Users see and edit only own data" feature. That feature is only available in editable tables (manual, imported and SQL query based tables).
If you're creating a new table, my advice would be to create a manual table, where you would have one integer ID column, which will be the ID for the currently-logged-in user. So, when you enable Editing, in the Editing tab above the table, and enable "Users see and edit only own data" feature, you need to select that integer column as the user's ID column.
I'm not sure if I understand your approach correctly, but it sounds like you want to have a table with predefined rows:
And when users sign in - they can enter their grades into "Grade" columns; and have that process repeat automatically for all users?
That can't be done, because you can enter these rows before you enable "Users see and edit only own data" feature, but those would be the only rows you have in the table. So, when you enable "Users see and edit only own data" feature, your users will not be able to see these rows (because they were not entered by them, but by you, so your ID is stored in the ID column, not their ID).
You would need to duplicate these rows, as many times as you have users, like this:
So, if you were to create a table like this, and enable "Users see and edit only own data" feature afterwards, and select the ID column as the User ID column for editing; users with ID 1 would see the first 5 rows; user with ID 2 will see rows 6 - 10; user with ID 3 will see rows 11 - 15; user with ID 4 will see rows 16 - 20, and so on.
If I understood what you want to do, that's the only way you can do it.
All the data below, in the CSV file you sent me needs to be added in new wpDataTables (separate tables), just like what I did with the table above. Data formatted as your CSV file will not be imported into wpDataTables properly, and you won't be able to use it.
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