Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Could I import a list of name and ID details with Excel or CSV to filter the list?
Hello Lucas
Thank you for your interest in wpDataTables.
Sure, you can either create tables linked to a CSV or linked to an Excel file, in which case the tables can not be editable.
Or, you can create tables by importing those files, in which case the plugin will use the data from the file to create a table, and that table will be editable, and save as a manual table which will no longer be connected to the original file. Meaning, if you edit one the other won't be updated.
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
Hi Aleksandar, many thanks for the reply.
Would like to confirm on the approach again.
(a) What I am looking for is the ability to upload an excel sheet or CSV of name and ID, and that these name and ID could be identified and filtered in the already created tables of the wpDataTables or tables linked to the CSV/Excel file. In other words, i could extract the corresponding details to these name and ID by a form of uploading an excel sheet or CSV instead of manually keying in details/filtering it. But, if there is an alternative way that I could filter the list easily, example, copy and paste the name or ID to a text box, i think that works well too.
(b) After the above, we still retain the ability of sorting and filtering.
Many thanks
Hi again Lucas
If you upload an Excel or a CSV file, and use it as a linked file the table will automatically be updated after the file is updated in ../wp-content/uploads. You wouldn't be able to update the table by re-uploading the source file.
So, when you update the source, the table will be updated - no need to manually enter anything in the table. That is - you wouldn't be able to anyway, since linked tables aren't editable.
Filters can be used on all our tables, sure.
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
Many thanks Aleksandar. Sounds like it does not have a function that I am looking for. But, i would like to confirm again. In other words, if I have uploaded "Spreadsheet A" to create a table, will I be able to upload "Spreadsheet B" that does a vlookup or filter like function, extracting details from "Spreadsheet A" itself?
Sorry to disappoint you, Lucas, but unfortunately no.
Formulas in wpDataTables can only work for the table they are in.
You can take a look at our Foreign Key feature, but I don't believe this is what you're looking for.
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