I tried the Foreign Key feature, however, it would only show tables in wpDataTables itself. I need to reference the Lookup primary key from a second database/table as the first column of data in a new wpDataTables table. The other columns will be data entry, an amount US dollars, a date in yyyy-mm-dd format {prefer a datepicker}, a checkbox for cash or check, and a text box for extra remarks or the check number.
It would be better to show the names stored in the extra table as last name, first name, but insert the primary key number in the column field.
What data source is this other table (from a second database)?
Unfortunately, LOOKUP and other Excel functions can't be imported in wpDataTables, but if you can use it and create a table in PHPMyAdmin, you can create a different table using wpDataTables which would display the source table's primary key. Then you can use the Foreign Key feature again.
Other columns are easy enough to create, so we'll get to that later on. Can you explain in as much detail as you can how I can replicate your use case on my end, so I can test it?
It would be better to show the names stored in the extra table as last name, first name, but insert the primary key number in the column field.
You should be able to use the same Foreign Key multiple times, so you can reference the primary key to link the display value as last name, then first name, and in the end ID.
I'm sorry but Skype, TeamViewer, Zoom and all similar forms of communication other than tickets is not possible. Would you be able to record the screen (screencast), and explain there and send it to me?
We need to take input from our users where the a member id must be taken from a table outside of wpDataTables. How can I do that?
Hello James.
Thank you for your purchase.
If you want to use one column from a different table, my suggestion would be to try with the Foreign Key feature.
Please go through the documentation and see if this would be an option for you.
Best regards.
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 tried the Foreign Key feature, however, it would only show tables in wpDataTables itself. I need to reference the Lookup primary key from a second database/table as the first column of data in a new wpDataTables table. The other columns will be data entry, an amount US dollars, a date in yyyy-mm-dd format {prefer a datepicker}, a checkbox for cash or check, and a text box for extra remarks or the check number.
It would be better to show the names stored in the extra table as last name, first name, but insert the primary key number in the column field.
Hi again James.
What data source is this other table (from a second database)?
Unfortunately, LOOKUP and other Excel functions can't be imported in wpDataTables, but if you can use it and create a table in PHPMyAdmin, you can create a different table using wpDataTables which would display the source table's primary key. Then you can use the Foreign Key feature again.
Other columns are easy enough to create, so we'll get to that later on. Can you explain in as much detail as you can how I can replicate your use case on my end, so I can test it?
It would be better to show the names stored in the extra table as last name, first name, but insert the primary key number in the column field.
You should be able to use the same Foreign Key multiple times, so you can reference the primary key to link the display value as last name, then first name, and in the end ID.
Best regards.
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
Hey Jim.
I'm sorry but Skype, TeamViewer, Zoom and all similar forms of communication other than tickets is not possible. Would you be able to record the screen (screencast), and explain there and send it to me?
Best regards.
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