if you have more than 10 columns or more option responsive: true, doesn´t reach those new columns and filters stay alone (and deactivates responsive) and the rest of the data hides behind green plus button how can i make these new row (filterhead options) to be responsive too? Thanks in advance
@@ConsulthinkProgrammer if you coment /*responsive:true*/ inside function showData and add table-responsive class to div container of that table it shows all columns and their filters, but + green button dessapears and obviosly you have to move inside the table to see the rest of the data, its an awful answer, but it works, hope you can helpme to get back that +green button becose i have 23 columns and its barely readable. Thanks for your videos they helped me a lot.
Thank you for this video I learn lot from your video ..your making more session regarding this. Like auto refresh table and footer grand total and condition formatting
Hi sir CP, is there a way to make the dropdown filter dependent? The position column is dependent on the name column, like if we select Airi Satou when we click on the position there will only be the option of "Accountant"
Thanks, I'm learning this. I have a column of numeric data. and want all values to be sum every time the data is filtered and display the totals in box above the table. Is it possible?
@@miraclewasteco.ltd.5560 a few months ago a client asked me to make it like that, but the filter was about categories, not date ranges. I managed to make it using DataTables. Email me if you are interested :)
In google sheet I have a range that refer to an external data. This external data is refreshed every one minute . So the data is changing every one minute. I need to copy the content of one fix cell in that range into another cell every one minute, each time copy to a different cell. Example: cell A1 has the content that refer to an external data. Cell A1 is updated every one minute. At first A1= 100, I need it to be copied to cell B1 (so B1=100); one minute later, A1=101, I need it to be copied to B2 (so B2=101) and so on how to make this in google sheet??
@@ConsulthinkProgrammer thanks for your reply. I use google sheet as database. Only one item go to sheet. for example , tire, rim, tube these three items i have to received but three items do not go to sheet by one click. for submitting three items need three time form submit. have you any idea to submit these three or more items by one submit?.
Bang tanya kalau sembunyikan filterhead di kolom yang gak urut (misal: kolom 1,2, 5, 8) kok jadi rusak ya tampilannya? Mohon bantuannya. btw makasih konten-kontennya sangat membantu
Kalau dengan fungsi yang sekarang dibuat, memang filternya harus dibuat urut dan akan tidak sesuai isi filternya jika ada 1 atau beberapa kolom yang dilompati. Jika ingin membuat filter tapi tidak berurutan, fungsinya harus dimodifikasi. Mungkin saya akan buatkan videonya di playlist webApp DataTables
Hi, Can I ask how should I adjust the column width? Since my dropdown(filterhead) contains really long string, the filter bar automatically expand to its width and it's quite unreadable. I've tried adding something but it doesn't work
Hello. If you notice, I did this before in Index file (CSS section) th{ white-space: nowrap; } to modify column width based on th, you could doing this: th{ white-space: normal; } or this: th{ width: 20%; }
Ketika proses deploy, set akses untuk 'Siapa saja' atau 'Anyone'. Kemudian sharing versi exec-nya ke orang lain, bukan versi 'dev' nya. Kalau sudah dibagikan versi exec-nya dan belum bisa dibuka, coba user yang bersangkutan logout dulu dari semua akun google di browser-nya, atau buka di tab penyamaran.
@@imammuzaka kalau ada case webApp url yg seperti itu, biasanya akan bisa dibuka secara normal beberapa hari kemudian dari waktu di-deploy pertama kali.
Awesome....master
Makin salut saya
is there any way to make where only the third column have filter range and the rest none?
Yes Sir, please see this one ruclips.net/video/Fd8c1y9dPTc/видео.html
oh I see thank you so mucu sir I appreciate it a lot❤️ Mind if I also ask about its responsiveness sir? thanks!
Hie add multiple select/checkboxes filter per column?
if you have more than 10 columns or more option responsive: true, doesn´t reach those new columns and filters stay alone (and deactivates responsive) and the rest of the data hides behind green plus button how can i make these new row (filterhead options) to be responsive too? Thanks in advance
Good question. Maybe I will try to figure it out :)
@@ConsulthinkProgrammer if you coment /*responsive:true*/ inside function showData and add table-responsive class to div container of that table it shows all columns and their filters, but + green button dessapears and obviosly you have to move inside the table to see the rest of the data, its an awful answer, but it works, hope you can helpme to get back that +green button becose i have 23 columns and its barely readable. Thanks for your videos they helped me a lot.
Thank you for this video I learn lot from your video ..your making more session regarding this. Like auto refresh table and footer grand total and condition formatting
You're welcome. With pleasure. Let's see what else I can share in this dataTables playlist, while developing my other playlists, of course :)
Hi sir CP, is there a way to make the dropdown filter dependent? The position column is dependent on the name column, like if we select Airi Satou when we click on the position there will only be the option of "Accountant"
Hi. I think it's still not possible with my knowledge for now. But maybe out there you can find the answer. I never tried to question that feature
Thanks, I'm learning this. I have a column of numeric data. and want all values to be sum every time the data is filtered and display the totals in box above the table. Is it possible?
Yes. But it will be more complicated. I haven't even tried the idea yet. It will be easier if you use Google Data Studio to do it.
@@ConsulthinkProgrammer Thanks for your answer, I'd like to present it in data tables, but maybe I'll try another way.
@@miraclewasteco.ltd.5560 a few months ago a client asked me to make it like that, but the filter was about categories, not date ranges. I managed to make it using DataTables. Email me if you are interested :)
In google sheet I have a range that refer to an external data. This external data is refreshed every one minute . So the data is changing every one minute. I need to copy the content of one fix cell in that range into another cell every one minute, each time copy to a different cell.
Example: cell A1 has the content that refer to an external data. Cell A1 is updated every one minute. At first A1= 100, I need it to be copied to cell B1 (so B1=100); one minute later, A1=101, I need it to be copied to B2 (so B2=101) and so on
how to make this in google sheet??
Looks like it need some custom touch. You could email me if you need personal assistance or custom request.
hi , great video ty!!, i wanna ask u, if u could found the fix to resolve the responsive issue? (minutes 8:36)
Hi. Could you more detail?
@@ConsulthinkProgrammer plz see since min 8.35 to min 8.59
Solution to responsive filter problem
how to submit multiple? Not single row data.
Could you more specific?
@@ConsulthinkProgrammer thanks for your reply. I use google sheet as database. Only one item go to sheet. for example , tire, rim, tube these three items i have to received but three items do not go to sheet by one click. for submitting three items need three time form submit. have you any idea to submit these three or more items by one submit?.
@Tazul Islam you could take a look in my collection or playlist with keyword 'Userform'
Good job! Please insert a video how to add import csv button :D
Terima kasih
Bang tanya kalau sembunyikan filterhead di kolom yang gak urut (misal: kolom 1,2, 5, 8) kok jadi rusak ya tampilannya? Mohon bantuannya. btw makasih konten-kontennya sangat membantu
Kalau dengan fungsi yang sekarang dibuat, memang filternya harus dibuat urut dan akan tidak sesuai isi filternya jika ada 1 atau beberapa kolom yang dilompati. Jika ingin membuat filter tapi tidak berurutan, fungsinya harus dimodifikasi. Mungkin saya akan buatkan videonya di playlist webApp DataTables
@@ConsulthinkProgrammer hai kak, apakah videonya sudah ada ya?:(
Berikut videonya ruclips.net/video/Fd8c1y9dPTc/видео.html
data dari filternya di saya kok ga muncul ya?
Biasanya ada typo di script-nya Mas, punten bs cek lg ya
Hi, Can I ask how should I adjust the column width?
Since my dropdown(filterhead) contains really long string, the filter bar automatically expand to its width and it's quite unreadable.
I've tried adding something but it doesn't work
Hello. If you notice, I did this before in Index file (CSS section)
th{
white-space: nowrap;
}
to modify column width based on th, you could doing this:
th{
white-space: normal;
}
or this:
th{
width: 20%;
}
Makasih banyak!!
This will be very nice if we uploaded CSV to add new bulk rows
Saat mau di oubikasi kok gk bisa dibuka diperangkat lain ya
Ketika proses deploy, set akses untuk 'Siapa saja' atau 'Anyone'. Kemudian sharing versi exec-nya ke orang lain, bukan versi 'dev' nya. Kalau sudah dibagikan versi exec-nya dan belum bisa dibuka, coba user yang bersangkutan logout dulu dari semua akun google di browser-nya, atau buka di tab penyamaran.
@@ConsulthinkProgrammer agar bisa dibuka tanpa pake tab penyamaran gimana ya?
@@imammuzaka kalau ada case webApp url yg seperti itu, biasanya akan bisa dibuka secara normal beberapa hari kemudian dari waktu di-deploy pertama kali.
@@ConsulthinkProgrammer terima kasih atas pencerahannya kak 😊🙏
Suskes dan sehat selalu 😊
@@imammuzaka aamiin. Sama-sama🙏
Very Very Useful, I need sum total , anyway to do that
I think yes. But I haven't tried it yet.
Can you share Source code
You can see the reference of the source code in the part 1
Source code
You can follow this series from the Part 1 to see the source code until this video