I am creating a very big table that contains the Bible in different languages. each language is in a separate column.
I want users to be able to turn on and off the various translations using an options obvious to the eye.
currently the only way to do so is using the button "Columns", which is not obvious enough.
is there an option to show the columns names as checkbox, and users can tick the translations they want?
Alternatively, is there a way to change the word "Columns"? I can change it to "translations" so people can understand that this button shows the translations?
It can be done. You will need to create one more column which contains translation language names in each row, for example ( English, French, German...). You have explanation how it needs to be done in attachment_1. Then hide that column and click on Create from column values option and choose Checkbox as filter type in Optional column setup (attachemnt_2).
Turn on Advanced table filtering and Filter in form options. This will place checkboxes with language names above the table.
You can choose Selectbox filter as well if you find it more suitable. Easiest way to populate column with language names is through Excel like editor because you can just drag "+" sign to populate multiple cells like in Excel.
As i stated, each language is in a separate column.
when I add a new column and fill it with languages, how does the language relate to the columns?
each row contains all the languages.
Or are you saying that I use rows instead of columns?
I am using mysql, but I created an excel mockup to show you how the table is set up.
If I added a new column, and filled the first cell with "English". what does this respond to? since the first row (that has the new cell), has verse 1 in all languages.
Thanks in advance.
EDIT:
I was able to achieve what I think you are saying. But this means that I repeat the verse in multiple rows, each row with a different languages.
But this is a problem because the database rows will blow in numbers, and people will not be able to put the verses opposite to each other in columns.
the "columns" button does exactly what I want, but it is not obvious enough, and I can;'t change its text to say "translations" for example.
if changing this button to a series of checkboxes or changing its name is not available now, can you do paid customization to the plugin?
I can give you some solution which do not require code customization but it can take some time. I tried to configure by myself and here is the example:
You can create table to look like this (attachment 1). In "Translate" column enter the languages you want to have translation of your data. In "Verses in lang" column enter the text you want to display for each chapter, verse but keep in mind that language should be the same as in "Translate" column. Then hide "Translate" column and click on Create from column values option and choose Checkbox as filter type in Optional column setup than your table should look like this (attachment 2)
Now when user select language in checkbox ( for example English , attachment 3) they can see all of the chapters and verses in English language. The thing I am trying to tell you is that you must have in same row language that you want to display and the content, in your example, verses in that language.
The only problem can be that when you open your page every verse of every language will be displayed and that is not possible to hide without code customization.
I believe that the "columns" button does all what I need, as the other methods are not as suitable.
the question I need an answer on is:
Is there a way, even if I paid for customization, to be able to show the options in the "columns" button as a checkbox, and be able to change the word "columns"?
if I achieved this, then all my problems are solved.
Hi,
I am creating a very big table that contains the Bible in different languages. each language is in a separate column.
I want users to be able to turn on and off the various translations using an options obvious to the eye.
currently the only way to do so is using the button "Columns", which is not obvious enough.
is there an option to show the columns names as checkbox, and users can tick the translations they want?
Alternatively, is there a way to change the word "Columns"? I can change it to "translations" so people can understand that this button shows the translations?
thanks a lot.
Atef
Hi atef_wagih,
Thank you for your purchase.
It can be done.
You will need to create one more column which contains translation language names in each row, for example ( English, French, German...). You have explanation how it needs to be done in attachment_1.
Then hide that column and click on Create from column values option and choose Checkbox as filter type in Optional column setup (attachemnt_2).
Turn on Advanced table filtering and Filter in form options. This will place checkboxes with language names above the table.
You can choose Selectbox filter as well if you find it more suitable. Easiest way to populate column with language names is through Excel like editor because you can just drag "+" sign to populate multiple cells like in Excel.
Kind Regards,
Miloš Jovanović
[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 Bogdan,
Thanks a lot for your comprehensive reply.
I am confused about the new column.
As i stated, each language is in a separate column.
when I add a new column and fill it with languages, how does the language relate to the columns?
each row contains all the languages.
Or are you saying that I use rows instead of columns?
I am using mysql, but I created an excel mockup to show you how the table is set up.
If I added a new column, and filled the first cell with "English". what does this respond to? since the first row (that has the new cell), has verse 1 in all languages.
Thanks in advance.
EDIT:
I was able to achieve what I think you are saying. But this means that I repeat the verse in multiple rows, each row with a different languages.
But this is a problem because the database rows will blow in numbers, and people will not be able to put the verses opposite to each other in columns.
the "columns" button does exactly what I want, but it is not obvious enough, and I can;'t change its text to say "translations" for example.
if changing this button to a series of checkboxes or changing its name is not available now, can you do paid customization to the plugin?
thanks
Hi atef_wagih,
I can give you some solution which do not require code customization but it can take some time.
I tried to configure by myself and here is the example:
You can create table to look like this (attachment 1).
In "Translate" column enter the languages you want to have translation of your data.
In "Verses in lang" column enter the text you want to display for each chapter, verse but keep in mind that language should be the same as in "Translate" column.
Then hide "Translate" column and click on Create from column values option and choose Checkbox as filter type in Optional column setup than your table should look like this (attachment 2)
Now when user select language in checkbox ( for example English , attachment 3) they can see all of the chapters and verses in English language.
The thing I am trying to tell you is that you must have in same row language that you want to display and the content, in your example, verses in that language.
The only problem can be that when you open your page every verse of every language will be displayed and that is not possible to hide without code customization.
Kind Regards,
Miloš Jovanović
[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 Bogdan,
Thanks for your patience in this matter.
I believe that the "columns" button does all what I need, as the other methods are not as suitable.
the question I need an answer on is:
Is there a way, even if I paid for customization, to be able to show the options in the "columns" button as a checkbox, and be able to change the word "columns"?
if I achieved this, then all my problems are solved.
thanks
Hi atef_wagih,
Can you please send me some more details and your files on [email protected] so we can take a look and tell you the price of the customization.
Kind Regards,
Miloš Jovanović
[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