DavidG

DavidG

@GR-8 From my personal experience it’s not worth the 100-200 you think your’e sparing yourself.
An accountant will usually save you much more through teaching you how and what to file.

DavidG

“I had the same issue and this trick I read somewhere online seemed to have fixed it. Point the camera straight down into a vacuum hose (while the vacuum is on) and also turn camera on and off a few times. I suppose there is dirt in the shutter blades that can be sucked out this way.”

a few people claim that it helped them.

DavidG

intresting idea, looks like the signals will interfere with each other, see
https://www.amazon.com/ask/questions/Tx1EQYEOL0A7TTS/ref=ask_dp_dpmw_al_hza
However I was thinking if you could find 2 transmitters that work on different frequencies it might work

DavidG

I wouldn’t put a high V strip on top of my sink

DavidG

wow, I was working so hard and the answer was right here.

DavidG

Proceed with caution

DavidG

Very nice!!

DavidG

Thanks, exactly what I need.

DavidG

check out the first comment on this YouTube video

DavidG

When you are driving a car that your’e not familiar with and don’t know which side is the gas flap,
Instead of opening doors look for a small symbol on your dashboard that you may have overlooked a little arrow or triangle near the gas gauge, the arrow indicates which side of the car the gas tank is on.

57cbbcdcff7878c42854810f0c85170a (1).jpg

DavidG

Does anyone know of a site I can fax several pages to the UK for free?

DavidG

ok now I get
Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "where" "where "" at line 1, column 32. Was expecting one of: "true" ... "false" ... "date" ... "timeofday" ... "datetime" ... "timestamp" ... "min" ... "max" ... "avg" ... "count" ... "sum" ... "no_values" ... "no_format" ... "is" ... "null" ... "year" ... "month" ... "day" ... "hour" ... "minute" ... "second" ... "millisecond" ... "with" ... "contains" ... "starts" ... "ends" ... "matches" ... "like" ... "now" ... "dateDiff" ... "quarter" ... "lower" ... "upper" ... "dayOfWeek" ... "toDate" ... <ID> ... <INTEGER_LITERAL> ... <DECIMAL_LITERAL> ... <STRING_LITERAL> ... <QUOTED_ID> ... "(" ... "-" ... "min" ... "max" ... "count" ... "avg" ... "sum" ... "year" ... "month" ... "day" ... "hour" ... "minute" ... "second" ... "millisecond" ... "now" ... "dateDiff" ... "lower" ... "upper" ... "quarter" ... "dayOfWeek" ... "toDate" ... "(" ... <STRING_LITERAL> ... <DECIMAL_LITERAL> ... <INTEGER_LITERAL> ... "-" ... "true" ... "false" ... "date" ... "timeofday" ... "datetime" ... "timestamp" ... <ID> ... <QUOTED_ID> ... "min" ... "max" ... "avg" ... "count" ... "sum" ... "no_values" ... "no_format" ... "is" ... "null" ... "year" ... "month" ... "day" ... "hour" ... "minute" ... "second" ... "millisecond" ... "with" ... "contains" ... "starts" ... "ends" ... "matches" ... "like" ... "now" ... "dateDiff" ... "quarter" ... "lower" ... "upper" ... "dayOfWeek" ... "toDate" ...

this is my script
=Query(IMPORTRANGE("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx","Main!A:D"),"Select Col1, Col2, Col3, Col4, where Col3='bookkeeping'")

DavidG

you can do it in Outlook

DavidG

@Knaper-Yaden
=Query(IMPORTRANGE("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx","Main!A:A"),"Select Col1, Col2, Col3, Col4 where Col3='bookkeeping'")

DavidG

I get this error
Error
Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col2

DavidG

Not bad, I like the idea that you can fax straight from within your email.

DavidG

Colum A:A are all the vendors so we can have A1 being ‘Graphic designer’ A2 ‘Bookkeeping’ and then A3 goes back to ‘Graphic designer’
so how can I import only the line that cell A of that line is ‘Graphic designer’ ?

DavidG

I have a google sheet with all my business expenses, different vendors and companies, I am looking for a way to create a new sheet for each vendor and somehow pull from the main sheet only the lines that says their name in it.
Any way to do that?

DavidG

Anyone?

DavidG

@efidre said in Doona or Yoyo...?:

Just buy yourself a fake Doona in China of AliExpress like we did for a quarter of the price!

Do you have a link? couldn’t find anything thnx

DavidG

@DavidG

Best posts made by DavidG

Latest posts made by DavidG