I understand how to create users that can edit their own data, by creating an integer column and naming it user_id. But how can i get this column to auto populate from the users login.
It seems i have to enter the user id number myself. Or give the user the option to edit this column which i don't want. If i hide the column from the user, and i am logged in as a user and try to add an entry it leaves the user_id column blank and thus doesn't show me any entries.
Shouldn't this column just auto populate when the user goes to add an entry to their table with the users ID which it knows from the login details?
If you add a user_id column, you also need to enable "Users see and edit only own data" feature, and select that column to be the User ID column in Editing tab above the table.
That way, the user_id column will not be editable, and will be automatically detected for each user.
Thank you. Not sue what i was doing wrong but finally got it to work!
Another question though - I would like a column that uses possible values from another data table, which i have figured out how to do. Except it only gives me a 'single line select-box' option. I need a 'multi-line select-box' option but its greyed out.
I tried creating several columns with the same name in order to select more than one option from the other table, but it makes filtering difficult and messy.
Is it possible to use possible values from another data table but with a multi-line select option for the user and if so how please?
Unfortunately, if you're using the Foreign Key feature the only limitation is that the only possible editor input type for those columns is the single-value selectbox, since the options are limited with respect to what the remote table contains.
You may be able to use SQL Query based tables and create the relation you need, but please note that writing custom queries isn't included in the plugin's support, so I can't help you with that.
I understand how to create users that can edit their own data, by creating an integer column and naming it user_id. But how can i get this column to auto populate from the users login.
It seems i have to enter the user id number myself. Or give the user the option to edit this column which i don't want. If i hide the column from the user, and i am logged in as a user and try to add an entry it leaves the user_id column blank and thus doesn't show me any entries.
Shouldn't this column just auto populate when the user goes to add an entry to their table with the users ID which it knows from the login details?
Please help
Hello Joy
Thank you for your purchase.
If you add a user_id column, you also need to enable "Users see and edit only own data" feature, and select that column to be the User ID column in Editing tab above the table.
That way, the user_id column will not be editable, and will be automatically detected for each user.
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
Thank you. Not sue what i was doing wrong but finally got it to work!
Another question though - I would like a column that uses possible values from another data table, which i have figured out how to do. Except it only gives me a 'single line select-box' option. I need a 'multi-line select-box' option but its greyed out.
I tried creating several columns with the same name in order to select more than one option from the other table, but it makes filtering difficult and messy.
Is it possible to use possible values from another data table but with a multi-line select option for the user and if so how please?
Hi again Joy
Unfortunately, if you're using the Foreign Key feature the only limitation is that the only possible editor input type for those columns is the single-value selectbox, since the options are limited with respect to what the remote table contains.
You may be able to use SQL Query based tables and create the relation you need, but please note that writing custom queries isn't included in the plugin's support, so I can't help you with that.
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