Search – set a requirement for number of characters in search
You can set this requiremeand you could also set a custom message if requirement is not valid by user.
Shortcode
[csvtohtml_create
source_type="guess"
path="large"
source_files="*.csv"
search_functionality="yes
searchbutton_text="Search now!"
resetbutton_text="Start all over!"
include_rows="1-30" //Just include the first 30 rows for demo
search_requiredchars="2"
search_requiredchars_message = "You have not entered 2 characters. Try again!"
| measure | quantile | time | sex | age | ethnic | value |
|---|---|---|---|---|---|---|
| lx | 2.50% | 2017-19 | Female | 0 years | Total | 100000 |
| lx | 2.50% | 2017-19 | Female | 1 years | Total | 99543 |
| lx | 2.50% | 2017-19 | Female | 2 years | Total | 99512 |
| lx | 2.50% | 2017-19 | Female | 3 years | Total | 99490 |
| lx | 2.50% | 2017-19 | Female | 4 years | Total | 99474 |
| lx | 2.50% | 2017-19 | Female | 5 years | Total | 99462 |
| lx | 2.50% | 2017-19 | Female | 6 years | Total | 99452 |
| lx | 2.50% | 2017-19 | Female | 7 years | Total | 99443 |
| lx | 2.50% | 2017-19 | Female | 8 years | Total | 99435 |
| lx | 2.50% | 2017-19 | Female | 9 years | Total | 99427 |
| lx | 2.50% | 2017-19 | Female | 10 years | Total | 99419 |
| lx | 2.50% | 2017-19 | Female | 11 years | Total | 99410 |
| lx | 2.50% | 2017-19 | Female | 12 years | Total | 99399 |
| lx | 2.50% | 2017-19 | Female | 13 years | Total | 99387 |
| lx | 2.50% | 2017-19 | Female | 14 years | Total | 99372 |
| lx | 2.50% | 2017-19 | Female | 15 years | Total | 99354 |
| lx | 2.50% | 2017-19 | Female | 16 years | Total | 99332 |
| lx | 2.50% | 2017-19 | Female | 17 years | Total | 99306 |
| lx | 2.50% | 2017-19 | Female | 18 years | Total | 99276 |
| lx | 2.50% | 2017-19 | Female | 19 years | Total | 99243 |
| lx | 2.50% | 2017-19 | Female | 20 years | Total | 99207 |
| lx | 2.50% | 2017-19 | Female | 21 years | Total | 99169 |
| lx | 2.50% | 2017-19 | Female | 22 years | Total | 99129 |
| lx | 2.50% | 2017-19 | Female | 23 years | Total | 99089 |
| lx | 2.50% | 2017-19 | Female | 24 years | Total | 99049 |
| lx | 2.50% | 2017-19 | Female | 25 years | Total | 99009 |
| lx | 2.50% | 2017-19 | Female | 26 years | Total | 98970 |
| lx | 2.50% | 2017-19 | Female | 27 years | Total | 98931 |
| lx | 2.50% | 2017-19 | Female | 28 years | Total | 98893 |
| lx | 2.50% | 2017-19 | Female | 29 years | Total | 98854 |
Search – when results not found
It’s possible to add a custom message when a searchstring is not found: (If this attribute is not added whole table will show up). Search for something you know does not exist in table and this custom message will show up. For example search for dfsdfwerowieuroiwu for this table below.
Shortcode
[csvtohtml_create
source_type="guess"
path="large"
source_files="*.csv"
search_functionality="yes
searchbutton_text="Search now!"
resetbutton_text="Start all over!"
include_rows="1-30" //Just include the first 30 rows for demo
notfound_message = "We are sorry. The thing you searched for does not exist."
| measure | quantile | time | sex | age | ethnic | value |
|---|---|---|---|---|---|---|
| lx | 2.50% | 2017-19 | Female | 0 years | Total | 100000 |
| lx | 2.50% | 2017-19 | Female | 1 years | Total | 99543 |
| lx | 2.50% | 2017-19 | Female | 2 years | Total | 99512 |
| lx | 2.50% | 2017-19 | Female | 3 years | Total | 99490 |
| lx | 2.50% | 2017-19 | Female | 4 years | Total | 99474 |
| lx | 2.50% | 2017-19 | Female | 5 years | Total | 99462 |
| lx | 2.50% | 2017-19 | Female | 6 years | Total | 99452 |
| lx | 2.50% | 2017-19 | Female | 7 years | Total | 99443 |
| lx | 2.50% | 2017-19 | Female | 8 years | Total | 99435 |
| lx | 2.50% | 2017-19 | Female | 9 years | Total | 99427 |
| lx | 2.50% | 2017-19 | Female | 10 years | Total | 99419 |
| lx | 2.50% | 2017-19 | Female | 11 years | Total | 99410 |
| lx | 2.50% | 2017-19 | Female | 12 years | Total | 99399 |
| lx | 2.50% | 2017-19 | Female | 13 years | Total | 99387 |
| lx | 2.50% | 2017-19 | Female | 14 years | Total | 99372 |
| lx | 2.50% | 2017-19 | Female | 15 years | Total | 99354 |
| lx | 2.50% | 2017-19 | Female | 16 years | Total | 99332 |
| lx | 2.50% | 2017-19 | Female | 17 years | Total | 99306 |
| lx | 2.50% | 2017-19 | Female | 18 years | Total | 99276 |
| lx | 2.50% | 2017-19 | Female | 19 years | Total | 99243 |
| lx | 2.50% | 2017-19 | Female | 20 years | Total | 99207 |
| lx | 2.50% | 2017-19 | Female | 21 years | Total | 99169 |
| lx | 2.50% | 2017-19 | Female | 22 years | Total | 99129 |
| lx | 2.50% | 2017-19 | Female | 23 years | Total | 99089 |
| lx | 2.50% | 2017-19 | Female | 24 years | Total | 99049 |
| lx | 2.50% | 2017-19 | Female | 25 years | Total | 99009 |
| lx | 2.50% | 2017-19 | Female | 26 years | Total | 98970 |
| lx | 2.50% | 2017-19 | Female | 27 years | Total | 98931 |
| lx | 2.50% | 2017-19 | Female | 28 years | Total | 98893 |
| lx | 2.50% | 2017-19 | Female | 29 years | Total | 98854 |
Search – placeholder
It’s possible to add a placeholder to the searchinput field very easily. (Placeholder = text that shows as a description in the inputfield but disappears when user starts to enter)
Shortcode
[csvtohtml_create
source_type="guess"
path="large"
source_files="*.csv"
search_functionality="yes
searchbutton_text="Search now!"
resetbutton_text="Start all over!"
include_rows="1-30" //Just include the first 30 rows for demo
notfound_message = "We are sorry. The thing you searched for does not exist."
searchinput_placeholder="Do your search!"
| measure | quantile | time | sex | age | ethnic | value |
|---|---|---|---|---|---|---|
| lx | 2.50% | 2017-19 | Female | 0 years | Total | 100000 |
| lx | 2.50% | 2017-19 | Female | 1 years | Total | 99543 |
| lx | 2.50% | 2017-19 | Female | 2 years | Total | 99512 |
| lx | 2.50% | 2017-19 | Female | 3 years | Total | 99490 |
| lx | 2.50% | 2017-19 | Female | 4 years | Total | 99474 |
| lx | 2.50% | 2017-19 | Female | 5 years | Total | 99462 |
| lx | 2.50% | 2017-19 | Female | 6 years | Total | 99452 |
| lx | 2.50% | 2017-19 | Female | 7 years | Total | 99443 |
| lx | 2.50% | 2017-19 | Female | 8 years | Total | 99435 |
| lx | 2.50% | 2017-19 | Female | 9 years | Total | 99427 |
| lx | 2.50% | 2017-19 | Female | 10 years | Total | 99419 |
| lx | 2.50% | 2017-19 | Female | 11 years | Total | 99410 |
| lx | 2.50% | 2017-19 | Female | 12 years | Total | 99399 |
| lx | 2.50% | 2017-19 | Female | 13 years | Total | 99387 |
| lx | 2.50% | 2017-19 | Female | 14 years | Total | 99372 |
| lx | 2.50% | 2017-19 | Female | 15 years | Total | 99354 |
| lx | 2.50% | 2017-19 | Female | 16 years | Total | 99332 |
| lx | 2.50% | 2017-19 | Female | 17 years | Total | 99306 |
| lx | 2.50% | 2017-19 | Female | 18 years | Total | 99276 |
| lx | 2.50% | 2017-19 | Female | 19 years | Total | 99243 |
| lx | 2.50% | 2017-19 | Female | 20 years | Total | 99207 |
| lx | 2.50% | 2017-19 | Female | 21 years | Total | 99169 |
| lx | 2.50% | 2017-19 | Female | 22 years | Total | 99129 |
| lx | 2.50% | 2017-19 | Female | 23 years | Total | 99089 |
| lx | 2.50% | 2017-19 | Female | 24 years | Total | 99049 |
| lx | 2.50% | 2017-19 | Female | 25 years | Total | 99009 |
| lx | 2.50% | 2017-19 | Female | 26 years | Total | 98970 |
| lx | 2.50% | 2017-19 | Female | 27 years | Total | 98931 |
| lx | 2.50% | 2017-19 | Female | 28 years | Total | 98893 |
| lx | 2.50% | 2017-19 | Female | 29 years | Total | 98854 |
Search – hide table at load
If you want to hide your table when your page loads you could add attribute hidetable_load.
Shortcode
[csvtohtml_create
source_type="guess"
path="large"
source_files="*.csv"
search_functionality="yes
searchbutton_text="Search now!"
resetbutton_text="Start all over!"
include_rows="1-30" //Just include the first 30 rows for demo
notfound_message = "We are sorry. The thing you searched for does not exist."
searchinput_placeholder="Do your search!"
hidetable_load="yes"
| measure | quantile | time | sex | age | ethnic | value |
|---|---|---|---|---|---|---|
| lx | 2.50% | 2017-19 | Female | 0 years | Total | 100000 |
| lx | 2.50% | 2017-19 | Female | 1 years | Total | 99543 |
| lx | 2.50% | 2017-19 | Female | 2 years | Total | 99512 |
| lx | 2.50% | 2017-19 | Female | 3 years | Total | 99490 |
| lx | 2.50% | 2017-19 | Female | 4 years | Total | 99474 |
| lx | 2.50% | 2017-19 | Female | 5 years | Total | 99462 |
| lx | 2.50% | 2017-19 | Female | 6 years | Total | 99452 |
| lx | 2.50% | 2017-19 | Female | 7 years | Total | 99443 |
| lx | 2.50% | 2017-19 | Female | 8 years | Total | 99435 |
| lx | 2.50% | 2017-19 | Female | 9 years | Total | 99427 |
| lx | 2.50% | 2017-19 | Female | 10 years | Total | 99419 |
| lx | 2.50% | 2017-19 | Female | 11 years | Total | 99410 |
| lx | 2.50% | 2017-19 | Female | 12 years | Total | 99399 |
| lx | 2.50% | 2017-19 | Female | 13 years | Total | 99387 |
| lx | 2.50% | 2017-19 | Female | 14 years | Total | 99372 |
| lx | 2.50% | 2017-19 | Female | 15 years | Total | 99354 |
| lx | 2.50% | 2017-19 | Female | 16 years | Total | 99332 |
| lx | 2.50% | 2017-19 | Female | 17 years | Total | 99306 |
| lx | 2.50% | 2017-19 | Female | 18 years | Total | 99276 |
| lx | 2.50% | 2017-19 | Female | 19 years | Total | 99243 |
| lx | 2.50% | 2017-19 | Female | 20 years | Total | 99207 |
| lx | 2.50% | 2017-19 | Female | 21 years | Total | 99169 |
| lx | 2.50% | 2017-19 | Female | 22 years | Total | 99129 |
| lx | 2.50% | 2017-19 | Female | 23 years | Total | 99089 |
| lx | 2.50% | 2017-19 | Female | 24 years | Total | 99049 |
| lx | 2.50% | 2017-19 | Female | 25 years | Total | 99009 |
| lx | 2.50% | 2017-19 | Female | 26 years | Total | 98970 |
| lx | 2.50% | 2017-19 | Female | 27 years | Total | 98931 |
| lx | 2.50% | 2017-19 | Female | 28 years | Total | 98893 |
| lx | 2.50% | 2017-19 | Female | 29 years | Total | 98854 |
Search – hide table at reset
When you click on resetbutton the table goes back to it’s original state. If you have attribute hidetable_load set to yes it still shows the table when clicking on the resetbutton. If you want to hide table when doing a reset you could add attribute hidetable_reset
Shortcode
[csvtohtml_create
source_type="guess"
path="large"
source_files="*.csv"
search_functionality="yes
searchbutton_text="Search now!"
resetbutton_text="Start all over!"
include_rows="1-30" //Just include the first 30 rows for demo
notfound_message = "We are sorry. The thing you searched for does not exist."
searchinput_placeholder="Do your search!"
hidetable_load="yes"
hidetable_reset="yes"
| measure | quantile | time | sex | age | ethnic | value |
|---|---|---|---|---|---|---|
| lx | 2.50% | 2017-19 | Female | 0 years | Total | 100000 |
| lx | 2.50% | 2017-19 | Female | 1 years | Total | 99543 |
| lx | 2.50% | 2017-19 | Female | 2 years | Total | 99512 |
| lx | 2.50% | 2017-19 | Female | 3 years | Total | 99490 |
| lx | 2.50% | 2017-19 | Female | 4 years | Total | 99474 |
| lx | 2.50% | 2017-19 | Female | 5 years | Total | 99462 |
| lx | 2.50% | 2017-19 | Female | 6 years | Total | 99452 |
| lx | 2.50% | 2017-19 | Female | 7 years | Total | 99443 |
| lx | 2.50% | 2017-19 | Female | 8 years | Total | 99435 |
| lx | 2.50% | 2017-19 | Female | 9 years | Total | 99427 |
| lx | 2.50% | 2017-19 | Female | 10 years | Total | 99419 |
| lx | 2.50% | 2017-19 | Female | 11 years | Total | 99410 |
| lx | 2.50% | 2017-19 | Female | 12 years | Total | 99399 |
| lx | 2.50% | 2017-19 | Female | 13 years | Total | 99387 |
| lx | 2.50% | 2017-19 | Female | 14 years | Total | 99372 |
| lx | 2.50% | 2017-19 | Female | 15 years | Total | 99354 |
| lx | 2.50% | 2017-19 | Female | 16 years | Total | 99332 |
| lx | 2.50% | 2017-19 | Female | 17 years | Total | 99306 |
| lx | 2.50% | 2017-19 | Female | 18 years | Total | 99276 |
| lx | 2.50% | 2017-19 | Female | 19 years | Total | 99243 |
| lx | 2.50% | 2017-19 | Female | 20 years | Total | 99207 |
| lx | 2.50% | 2017-19 | Female | 21 years | Total | 99169 |
| lx | 2.50% | 2017-19 | Female | 22 years | Total | 99129 |
| lx | 2.50% | 2017-19 | Female | 23 years | Total | 99089 |
| lx | 2.50% | 2017-19 | Female | 24 years | Total | 99049 |
| lx | 2.50% | 2017-19 | Female | 25 years | Total | 99009 |
| lx | 2.50% | 2017-19 | Female | 26 years | Total | 98970 |
| lx | 2.50% | 2017-19 | Female | 27 years | Total | 98931 |
| lx | 2.50% | 2017-19 | Female | 28 years | Total | 98893 |
| lx | 2.50% | 2017-19 | Female | 29 years | Total | 98854 |
Search – realtimesearch
Sometimes you want to search when user starts to type. The attribute search_realtime makes this easy to implement. After user has stopped typing,, the plugin does a search in about a second.
Shortcode
[csvtohtml_create
source_type="guess"
path="large"
source_files="*.csv"
search_functionality="yes
searchbutton_text="Search now!"
resetbutton_text="Start all over!"
include_rows="1-30" //Just include the first 30 rows for demo
notfound_message = "We are sorry. The thing you searched for does not exist."
searchinput_placeholder="Do your search!"
hidetable_load="yes"
hidetable_reset="yes"
search_realtime="yes"
| measure | quantile | time | sex | age | ethnic | value |
|---|---|---|---|---|---|---|
| lx | 2.50% | 2017-19 | Female | 0 years | Total | 100000 |
| lx | 2.50% | 2017-19 | Female | 1 years | Total | 99543 |
| lx | 2.50% | 2017-19 | Female | 2 years | Total | 99512 |
| lx | 2.50% | 2017-19 | Female | 3 years | Total | 99490 |
| lx | 2.50% | 2017-19 | Female | 4 years | Total | 99474 |
| lx | 2.50% | 2017-19 | Female | 5 years | Total | 99462 |
| lx | 2.50% | 2017-19 | Female | 6 years | Total | 99452 |
| lx | 2.50% | 2017-19 | Female | 7 years | Total | 99443 |
| lx | 2.50% | 2017-19 | Female | 8 years | Total | 99435 |
| lx | 2.50% | 2017-19 | Female | 9 years | Total | 99427 |
| lx | 2.50% | 2017-19 | Female | 10 years | Total | 99419 |
| lx | 2.50% | 2017-19 | Female | 11 years | Total | 99410 |
| lx | 2.50% | 2017-19 | Female | 12 years | Total | 99399 |
| lx | 2.50% | 2017-19 | Female | 13 years | Total | 99387 |
| lx | 2.50% | 2017-19 | Female | 14 years | Total | 99372 |
| lx | 2.50% | 2017-19 | Female | 15 years | Total | 99354 |
| lx | 2.50% | 2017-19 | Female | 16 years | Total | 99332 |
| lx | 2.50% | 2017-19 | Female | 17 years | Total | 99306 |
| lx | 2.50% | 2017-19 | Female | 18 years | Total | 99276 |
| lx | 2.50% | 2017-19 | Female | 19 years | Total | 99243 |
| lx | 2.50% | 2017-19 | Female | 20 years | Total | 99207 |
| lx | 2.50% | 2017-19 | Female | 21 years | Total | 99169 |
| lx | 2.50% | 2017-19 | Female | 22 years | Total | 99129 |
| lx | 2.50% | 2017-19 | Female | 23 years | Total | 99089 |
| lx | 2.50% | 2017-19 | Female | 24 years | Total | 99049 |
| lx | 2.50% | 2017-19 | Female | 25 years | Total | 99009 |
| lx | 2.50% | 2017-19 | Female | 26 years | Total | 98970 |
| lx | 2.50% | 2017-19 | Female | 27 years | Total | 98931 |
| lx | 2.50% | 2017-19 | Female | 28 years | Total | 98893 |
| lx | 2.50% | 2017-19 | Female | 29 years | Total | 98854 |