Search the Community

Hi Everyone, I've had a lot of help doing something in the Google Sheets editor and have also posted this in the Google Apps Script forum but so far, no one's been able to help and I'm too clueless to help myself. If someone could point me the right direction or help me in any way, it would be much appreciated. Here's my issue. This is all on a spreadsheet online so the .getRange refers to the columns. The functions work perfectly fine and this whole code works fine as is but the problem is that if I have values returning from function concatCustomer() and concat() but NOT concatOther(), the code stops before concat() can be ran. To reiterate, if A2:A has values and E2:E has values returning while C2:C has no values returning due to input, the function for A2:A will run and the code will stop as C2:C won't return values and thus, E2:E's values will no longer be run. Is there an easy way to solve this? Someone in the Google Apps Script forum said to use {};{};{}; but I'm not sure how to input that. Thanks! Oh and just to add what updateConcatCustomer() is, this function is part of a dropdown menu so that other users can click on the dropdown menu, select the function and be able to update the spreadsheet and have the spreadsheet return the values. Hope that explains it! function updateConcatCustomer () { var ss = SpreadsheetApp.getActiveSpreadsheet(); var values = concatCustomer().map(function (e) {return [e];}); var sheet = ss.getSheetByName("Calc"); sheet.getRange('A2:A').clearContent(); sheet.getRange(2, 1, values.length, 1).setValues(values); var values2 = concatOther().map(function (i) {return [i];}); sheet.getRange('C2:C').clearContent(); sheet.getRange(2, 3, values2.length, 1).setValues(values2); var values3 = concat().map(function (k) {return [k];}); sheet.getRange('E2:E').clearContent(); sheet.getRange(2, 5, values3.length, 1).setValues(values3); }

Sources: Gizmodo Fox 2 Detroit Media: Fox 2 Video Quotes/Excerpts: My Opinions: It used to be that hacking gas pumps and ATMs were mainly just from TV dramas. However it's becoming easier and easier to illegally access those devices by improperly configured devices. Some things should definitely not become IoT and this is just another example.

Hey guys! I've recently bought an ASUS ROG Swift PG279Q monitor and I was looking for a decent desk mount to go along with it. Unfortunately, even though a lot of 100 x 100 VESA mounts are rated to support 8kg or 13kg, many Amazon reviews report that 7kg monitors droop. Some people say they over-torqued the screws trying to tighten them and the monitors still droop. As it happens, the PG279Q weighs ~7kg without the stand. I appreciate that the stand itself is very well built, but it does not suit my needs. Versatility in my setup is important as I intent to adjust the height and position of the monitor fairly frequently, so I was looking for a spring loaded or gas powered solution of at least 500mm of maximum reach. My search has been fruitless so far. I was wondering if perhaps some of you have had similar problems and found solutions. Any suggestions are deeply appreciated. Thanks in advance! Bonus eye-candy:

Welcome to this forums new RC thread! (If this thread already exists then give me a link and il hop on to there!) Here anyone that has an intrest in Radio Contrioled vehicles of any kind can disscus there gear, upcoming events, give advice and sutch! You dont need to own any fancy gear or do pro RC racing to be here just have an intrest in this and your good to go I guess I can start this thread by telling you my history with RC things; when I was around 10 I got my first RC car it was a blue one with sortof a race car boddy with ofroad tires and some really springy independant suspention, I still have it but I havent used it in about 2 years now. After a couple of years my intrest in this hobby grew and I bought a Kyosho EP Fazer, I have used it a bit but its just not that good, I have hightend the suspention a tad and its more of a "rally" car now, later that year my dad got me a Trexxas EREVO VXL(the small 1:16 one) and I have had a bunch of fun with it seing as its water tight you can take it out in any weather and it kicks gravel like an absolute beast, I have slightly warn out the tires now tho so thats something I will be fixing some time in the future. Now a couple of years later I have acuired another car and its a "pice of poop" in quality compard to the other cars i have, but its fun, its a WLtoys Pathfinder and its basicly the RC car I have wanted since I begun the hobby, but it is right now sitting beside me, with a busted gearbox I made a rally cross corse on a gravel field just down the streat and I decided that running the course down some stairs wouldent be to bad, but after the final stair the back end hit the ground and it messed up the gearbox realy bad so now I need spare parts...(pictures of all my current gear can be posted upon request) Well thats my storry, I have always wanted an RC plane so if someone could suggest a maby 4 chanel one that would be something that could be disscused So if your interested in RC just hit the follow button on this thread and post away!