I have 2 manual tables created, but I'd like for the 2nd table to lookup value in the first. for example
Description is a column heading in Table1 and Table2,
Table1 is editable so that managers can add products/decriptions but I want Table2's description to be a selectbox from Table1s entries then based on users selection pull across different data depending on the choice, similar to a vlookup in excel/googlesheets
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
You can connect the two columns using Foreign Key feature, but that's it. All other columns would have to be manually added. We have plans for this in the future, but I can't say when it will be added to the plugin.
Hi,
I have 2 manual tables created, but I'd like for the 2nd table to lookup value in the first. for example
Description is a column heading in Table1 and Table2,
Table1 is editable so that managers can add products/decriptions but I want Table2's description to be a selectbox from Table1s entries then based on users selection pull across different data depending on the choice, similar to a vlookup in excel/googlesheets
Hello Dan
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
You can connect the two columns using Foreign Key feature, but that's it. All other columns would have to be manually added. We have plans for this in the future, but I can't say when it will be added to 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