We are very happy to use wpDataTable (foreign key) feature in data settings to get data into columns. But we will need a steep forward in some cases.
For example:
If we select one specific cell from the foreign table, it would be very useful that other columns also get the same data from the same wdt_ID row of the source table and put it into the new one to feed other columns that have to be replicated in the new one.
If it was impossible to import from the foreign table the data row with more than one field/column at once, what about using the duplicate function to get into the destiny table some fields that share the same column name in the foreign one? : -).
Thank you In advance for your great job and customer service. ;-)
We don't work weekends, so it adds a couple more days to the delay.
-
At the moment, something like this use-case is not possible with our foreign key feature,
with the current plugin built-in capabilities, but i like this idea for a future improvement.
-
Right now, as you know, the current logic is,
when we make a foreign key column - we have to initially create it as "integer" , then it creates the integer column in the database table;
after that we switch this column in the plugin's table settings to "string" , so that we can pull any other column as "Display value" , and as the "Store value" is pulling the integer , from the foreign table's unique row ID.
But that integer number can only be used in this particular column/ it can not be pulled for other columns as you described.
I can't say a realistic ETA if or when something like that might be possible, but you can suggest it to our developers.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
If you have coding skills and wish to try to make a custom solution now,
Thank you in advance for your help.
We are very happy to use wpDataTable (foreign key) feature in data settings to get data into columns. But we will need a steep forward in some cases.
For example:
If we select one specific cell from the foreign table, it would be very useful that other columns also get the same data from the same wdt_ID row of the source table and put it into the new one to feed other columns that have to be replicated in the new one.
I hope I have explained well,
Is that possible?
Thank you.
... Another idea related..,
If it was impossible to import from the foreign table the data row with more than one field/column at once, what about using the duplicate function to get into the destiny table some fields that share the same column name in the foreign one? : -).
Thank you In advance for your great job and customer service. ;-)
Pablo.
Hi, Pablo.
Apologies for the waiting time.
We don't work weekends, so it adds a couple more days to the delay.
-
At the moment, something like this use-case is not possible with our foreign key feature,
with the current plugin built-in capabilities, but i like this idea for a future improvement.
-
Right now, as you know, the current logic is,
when we make a foreign key column - we have to initially create it as "integer" , then it creates the integer column in the database table;
after that we switch this column in the plugin's table settings to "string" , so that we can pull any other column as "Display value" , and as the "Store value" is pulling the integer , from the foreign table's unique row ID.
But that integer number can only be used in this particular column/ it can not be pulled for other columns as you described.
I can't say a realistic ETA if or when something like that might be possible, but you can suggest it to our developers.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
If you have coding skills and wish to try to make a custom solution now,
you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.
Please be advised that custom solutions with hooks are not included in our support.
You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.
( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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