Unfortunately, we don't have such a option with built in features of plugin. But you can take a look on this ticket how some of our customers make it happened.
Hi Milan, thanks for getting back to me, a little disappointing but ill hope for an update or new release that might fix it for us.
Can i ask another question, i am using data from one table to populate a column drop down list in another table, specifically a name, but i also need their email address as well. is it possible that if i choose say John from the drop down list in column A, the table can automatically update column B with Johns email address which is stored in the same table that has his name in it and the foreign key?
If i understand what are you trying to achieve, you only have to make one more column in new table that is also foreign key for email in first table. When you make that and select John from dropdown , in column b where are emails will be filtered his email.
Hi Thanks Milan, yes that is what i want to happen but it is not i'm afraid. i have set the tables up so table one has the following columns PickerName & PickerEmail
PickerName is a string with its data values supplied by another table Picker_name it allows me to select the name of the picker and the id of that picker is inserted in the table but his name is displayed which is correct. however i have also created column 2 as pickeremail that is setup the same way. this does not auto populate or change dependent on the value of the picker 1 id. is there an example or step by step guide you have that can help with this please? or am i missing something in the setup of my tables? i have attached screenshots of the tables in question.
Unfortunately that is not possible with built in features of plugin. You can't update email column by picking the name from dropdawn. You have to add email also in edit modal.
Hi Milan, re my question below is dynamic updating of one column based on a choice of another possible with some custom coding/development? and if so how much would this cost and would you be willing to do it?
the function is achievable in MySQL so i'm assuming should be relatively easy in the tables?
also is it possible for you to tell me how the individual views based on logged in users only being able to see their own data is worked? i need to have this feature but i also want an admin to see all data but also joined with data from another table, but as soon as i write the custom SQL for this all the admin sees is any data he has input, not everyone else as well.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
For your request need some code customization. We have our paid service, but we are now busy with implementation of new features for next update so we do not have free developers to implement this feature for you for now. We can recommend this service for customizations: https://wpkraken.io/?tms-plugins (by this link they would know you come from us) - they do develop such custom solutions, could you please send your inquiry to them?
You can take a look in our documentation how it works feature Users can see and edit own data on this link.
If you want to see all data from all users you have to make new table, using that table in query.(SELECT * FROM first_table.) You can find that table name in option MySQL table name for editing on EDITING tab of table settings.
Hello, I need to automatically add the date when a user enters a new row of data so i can see when that row was added. how can i do this please?
Hi Kevin,
Thank you for your purchase.
Unfortunately, we don't have such a option with built in features of plugin. But you can take a look on this ticket how some of our customers make it happened.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan, thanks for getting back to me, a little disappointing but ill hope for an update or new release that might fix it for us.
Can i ask another question, i am using data from one table to populate a column drop down list in another table, specifically a name, but i also need their email address as well. is it possible that if i choose say John from the drop down list in column A, the table can automatically update column B with Johns email address which is stored in the same table that has his name in it and the foreign key?
cheers kevin
Hi Kevin,
If i understand what are you trying to achieve, you only have to make one more column in new table that is also foreign key for email in first table. When you make that and select John from dropdown , in column b where are emails will be filtered his email.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Thanks Milan, yes that is what i want to happen but it is not i'm afraid. i have set the tables up so table one has the following columns PickerName & PickerEmail
PickerName is a string with its data values supplied by another table Picker_name it allows me to select the name of the picker and the id of that picker is inserted in the table but his name is displayed which is correct. however i have also created column 2 as pickeremail that is setup the same way. this does not auto populate or change dependent on the value of the picker 1 id. is there an example or step by step guide you have that can help with this please? or am i missing something in the setup of my tables? i have attached screenshots of the tables in question.
Thanks kevin
Hi Kevin,
Unfortunately that is not possible with built in features of plugin. You can't update email column by picking the name from dropdawn. You have to add email also in edit modal.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan, re my question below is dynamic updating of one column based on a choice of another possible with some custom coding/development? and if so how much would this cost and would you be willing to do it?
the function is achievable in MySQL so i'm assuming should be relatively easy in the tables?
also is it possible for you to tell me how the individual views based on logged in users only being able to see their own data is worked? i need to have this feature but i also want an admin to see all data but also joined with data from another table, but as soon as i write the custom SQL for this all the admin sees is any data he has input, not everyone else as well.
cheers Kevin
Hi Kevin,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
For your request need some code customization. We have our paid service, but we are now busy with implementation of new features for next update so we do not have free developers to implement this feature for you for now.
We can recommend this service for customizations: https://wpkraken.io/?tms-plugins (by this link they would know you come from us) - they do develop such custom solutions, could you please send your inquiry to them?
You can take a look in our documentation how it works feature Users can see and edit own data on this link.
If you want to see all data from all users you have to make new table, using that table in query.(SELECT * FROM first_table.) You can find that table name in option MySQL table name for editing on EDITING tab of table settings.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables