
Best posts made by Knaper Yaden
-
RE: Windows tricks you might not know
@Yitz said in Windows tricks you might not know:
Window key + .
Will open the emoji selectorBTW 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.)
-
RE: Windows tricks you might not know
@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.)
-
RE: Linking Text In InDesign
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
-
RE: Running out of space in Gmail?
@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 alotI 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.
-
RE: Linking within 2 google sheets
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
orA2
)=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?
- Replace
-
RE: Exit a Powershell Script
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
-
RE: Download video from website
Browser extensions like Video DownloadHelper might do the job.
-
RE: QUERY IMPORTRANGE - Google Sheets
@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.
Latest posts made by Knaper Yaden
-
RE: Xiaomi Pocco X3 NFC WiFi Function broken
If you know that Netspark did it, why but ask them?
-
RE: Request | Video censorship software
He probably means blurring/cutting out parts of a video.
I think VSDC Free Video Editor is the most comprehensive free video editing software: http://www.videosoftdev.com/
-
RE: How can I know if I can Add Memory to my Computer?
@manual branding certainly matters, the boards might be bad and can technically cause damage to the motherboard.
-
RE: How can I know if I can Add Memory to my Computer?
Or run the Crucial System Scanner:
https://www.crucial.com/store/systemscanner -
RE: Running out of space in Gmail?
@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 alotI 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.
-
RE: Software for displaying content in a Restaurant
@Hacker26 said in Software for displaying content in a Restaurant:
Google signs builder
I have not used it myself, but I once commanded for someone https://www.digitalsignage.com/, and he says it’s awesome.
He’s using it with a Windows compute stick at the TV screen, but they have for Android TV as well https://www.digitalsignage.com/_html/android_tv.html
-
RE: Running out of space in Gmail?
@Manual said in Running out of space in Gmail?:
@Knaper-Yaden said in Running out of space in Gmail?:
(As I wrote) that is what the Restore option is for.
Can you point me to instructions or a tutorial?
Have you tried choosing Restore and follow the prompts?
-
RE: Running out of space in Gmail?
@Manual said in Running out of space in Gmail?:
mails from an account and then upload (Restore) back to another account.
Any way to upload all emails I download from my old account to a new one?
(As I wrote) that is what the Restore option is for.
-
RE: Convert a non-running Windows 10 installation into a HyperV VM
This same Disk2vhd doesn’t work on any disk even if it’s not the active one? I think it does.
-
RE: URGENT Advice Needed
Maybe turn Off DHCP server, set the network range to some obscure one (not the default 192.168.1.x etc), and assign static IPs to all devices that you want connecting (the question is if the VoIP phones have the IPs visible in which case they can see it and use on their device…)?
(MAC Filtering isn’t very secure, MACs can quite easily be spoofed.)
And also, what switch do they use? If it’s a Managed Switch it might have a MAC Filtering/Port Security option.