1

The first thing that you should have in mind is that Google terms of services doesn't allow to do automated search queries. If you really need to do automated searches, then you should use another service, specially if you are looking to this for a long time and "hassle" free. The above because despite if the user repeatedly do searches ...


1

See sheet 'INVOICE' in File. Since cells B:D are merged, there are 2 formulas in B15 and E15 that return Product name and quantity with price for customer specified in cell B10. =Query( {Arrayformula( Transpose( Split( Rept( Concatenate('Order Data'!$C$3:$C$9&","),5),","))), {'Order Data'!$D$3:$H$9; 'Order Data'!$I$3:$M$9; ...


1

Thanks for you code @Deanospomony. It didn't work for me as nothing happened, but I just replaced the debugging code at the end with: else { Kasa.turnOn.skip() } since my action is Kasa.TurnOn (I also deleted the Android message part) So this is the code I use the only thing to adapt to each case is the very last line Kasa.turnOn.skip() (I guess now ...


Only top voted, non community-wiki answers of a minimum length are eligible