Keep it up! Yours is the first video to cover app script classes other than the main root ones in detail like this, thanks!
@AryanIrani123
3 жыл бұрын
Glad it was helpful! More Videos to come :) Don't forget to like the video and subscribe to the channel. ;)
@zeeshanabbas9049
Жыл бұрын
Aryan, love and respect from Pakistan. Thank you for your informative video
@AryanIrani123
Жыл бұрын
Thank you! Glad you like the videos!!
@ederpaulo
3 жыл бұрын
Hi, tks for you videos...you have one more follower....
@AryanIrani123
3 жыл бұрын
Thanks for the sub! :)
@AliHussain-gq2om
2 жыл бұрын
thanks alot dear Aryan. It helped us a lot!
@AryanIrani123
2 жыл бұрын
Most welcome!
@attilavass6935
2 жыл бұрын
Great video, thank you ! :) Why the sheet header (1st row) is copied using your code? How can we remove from filtered range?
@niketanpatel8710
Жыл бұрын
Amazing video ......great work.....🤩
@AryanIrani123
Жыл бұрын
Thank you so much 😀
@SumanMondal-bg4fs
2 жыл бұрын
Can you please inform the process of filtering the date
@cristiansaezflorez4748
2 жыл бұрын
Hi, great video! Can you please show how to create the array and the loop you mention at the end of the video? Thanks!
@imranahmed9538
Жыл бұрын
Hi, copyTo only works within the same spreadsheet how can I copy the filter data to another spreadsheet, please help!!!
@samcorpwong1528
2 жыл бұрын
Great Video! l'm new to Google Script. Is there any ways to create a filter on a pivot table / specific column and save it as a PDF by each of the values of that specific column?
@anhnhatnguyet4628
2 жыл бұрын
if you don't enter the filter condition directly into the app Script like this video, but create a filter condition range from columns G to H (G:H). The filter results are always displayed at Filter_Sheet starting from A20, how to edit the app script? Can you please make a video on how to do this, thanks
@mayadharmoharana6911
9 ай бұрын
i tried to take filtered data to an array but failed. can u please help
@niketanpatel8710
Жыл бұрын
Already subscribed and waiting for new videos
@AryanIrani123
Жыл бұрын
Great!! New videos will be coming soon!
@deepakrudramoorthy2819
2 жыл бұрын
Hi thank you for the amazing Video. I have tried your code and it works BUT if I have to update new data into the sheet with this filter it is asking me to have a fresh sheet name as the name already exists. Please help to filter on existing sheet to update my data. Thank You
@haiduongtb
Жыл бұрын
Hi, my google sheet error: "TypeError: Cannot read properties of null (reading 'getRange')" Pls, can you help me fix this
@udhayakumarethirajulu348
Жыл бұрын
Thanks for your app script. Small help, instead of creating new sheet , is it possible to copy and paste in existing sheet the filter data. .
@AryanIrani123
Жыл бұрын
Yes, sure, remove the new sheet function and run the code, it should work!
@coinatlas5953
3 жыл бұрын
Great video! Could I ask your help with something? I have a column of data with 'strings' that represent the symbols of stocks. For example FB = facebook. This column is filled with strings 'FB', 'FB', 'MRNA', 'MRNA', 'FB', etc. Is there a 'general way' to filter based on the stock, if you don't know beforehand what text the stock would contain? Goal would be to filter based on the rows 'FB', 'FB', 'FB' and 'MRNA', 'MRNA" in this example.
@AryanIrani123
3 жыл бұрын
If you dont want to use Google Apps Script, you can create Filters manually and specify the column for filtering the data
@kuldeepvagadiya744
2 жыл бұрын
thats ok but i need transfer this filter data in to completely new sheet , it is possible or not ?
@AryanIrani123
2 жыл бұрын
Yes it is possible !
@badmabadma1725
3 жыл бұрын
There is no - Script editor - in Tools menu of my Google sheet - how to Enable it? how to get it?
@AryanIrani123
3 жыл бұрын
If you're using an organization's GSuite account, the GSuite admins may have access to Google Scripts.
@koungsareth8623
3 жыл бұрын
Appscript from beginner to advance.
@AryanIrani123
3 жыл бұрын
Yes, you are right
@RakeshKumarMonga
Жыл бұрын
Hi i am tyring to create filter but its giving me error 2:11:12 PM Error Exception: You can't create a filter in a sheet that already has a filter. create_Filter @ Code.gs:7 code function create_Filter(){ var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet1 = ss.getSheetByName("Visual Team Shoot data (2)"); var range = sheet1.getRange("A:I") // Adding the Filter var filter = range.createFilter(); var Filter_Criteria1 = SpreadsheetApp.newFilterCriteria().whenTextEqualTo("KZitem"); var add_filter1 = filter.setColumnFilterCriteria(3,Filter_Criteria1); var range1 = sheet1.getDataRange(); var new_sheet = ss.insertSheet(); new_sheet.setName("KZitem Data"); range1.copyTo(new_sheet.getRange(1,1)); filter.remove(); }
Пікірлер: 34