https://www.timeatlas.com/find-invalid-emails/

@Yitz said in Windows tricks you might not know:

Window key + .
Will open the emoji selector

BTW useful to know, in the Emoji Selector you can type a word (or start typing) to find the relevant emoji.

(Also, I find it easier to press Enter twice and then backspace instead of pressing Enter and Esc to close the Emoji panel.)

@TechWiz said in Windows tricks you might not know:

Just saw last week Ctrl+C and Ctrl+V is finally working in CMD, I guess it took Microsoft SO long to figure out how difficult it was without.

I guess it took you SO long to upgrade to Windows 10 … It’s been in Windows 10 since the beginning (that’s like 5 years.)

In their new Windows Terminal (which is still in Preview, supports all type of terminals including CMD and Powershell) they just added a (Control+F like) Find (by pressing Control+Shift+F.)

https://www.google.com/amp/s/www.howtogeek.com/253922/how-to-get-a-taskbar-notification-when-caps-lock-or-num-lock-are-enabled/amp/

Isn’t Liquid Layouts what you should really be looking to use? See a nice and detailed explainer here https://www.laralee.design/indesign-liquid-layouts/

The straight answer (but the incorrect way to use…) for your question might’ve been Cross-references like mentioned here https://indesignsecrets.com/synchronize-text-in-more-than-one-place-in-an-indesign-document.php

@Manual said in Running out of space in Gmail?:

No, I didn’t start yet
I usually get stuck with those stuff so I wanted to see how to do it before I start
but if you say that it will tell me what to do then I should manage
Thanks alot

I haven’t used it in a while, so I don’t remember how clear and simple it is. But as a general rule I think it’s silly to ask people for help and guides before actually looking at it.

How proficient are you in Google Sheets functions? You can accomplish this using the =Query and =IMPORTRANGE functions.

Example (to put in the first cell, i.e. A1 or A2)

=Query(IMPORTRANGE("1w-3MCszsR00MBa9XsMaFTgNnrzDmfhfhfllWeLw","Expenses!A2:F"),"Select Col1, Col2, Col3, Col4 where Col2='Vendor Name'"

• Replace 1w-3MCszsR00MBa9XsMaFTgNnrzDmfhfhfllWeLw with the source workbook’s URL or Key (the key is the long random middle part of the URL)
• Replace Expenses!A2:F which the source sheet name and range of data
• Add/remove all columns from the range that you want to import: Col1, Col2, Col3, Col4
• The column number (in the source sheet that has the vendor names) and name of the Vendor Col2='Vendor Name'"

Makes sense? Works?

The behavior makes sense, you can’t tell a Script to Exit something that it is not itself - the Powershell window opened by the shortcut - if you just run the ps1 file from the shortcut it will Exit, but then you can’t put your arguments, are they needed?)

I’ve seen someone using a workaround to shut the PowerShell window from within the script using ($PID is a variable for the current PowerShell session):

stop-process -Id $PID

Browser extensions like Video DownloadHelper might do the job.

@Chaim-Feingold said in QUERY IMPORTRANGE - Google Sheets:

’

It’s difficult to see what exactly your formula is, next time please use the code format option.

I’m not sure what else is wrong butt one obvious one is that you have a opening bracket before the start of the URL and not closing bracket.