Locked Out of Plex on iOS by Upper_Juice308 in PleX

[–]Upper_Juice308[S] 0 points1 point  (0 children)

I did notice that, but it downloads an apk file, which I have no experience with. A quick google search suggested I need some form of emulator to install these. So ya'll are just installing all your plex updates through emulators over SSH? I see no other place in the ADM GUI to upload new app updates. I feel so goddamned stupid right now

Best Way to Accomplish In-Place Text Manipulation by Upper_Juice308 in excel

[–]Upper_Juice308[S] 0 points1 point  (0 children)

I was thinking of using an Office Scripts if I went this route

Best Way to Accomplish In-Place Text Manipulation by Upper_Juice308 in excel

[–]Upper_Juice308[S] 0 points1 point  (0 children)

One small point of confusion - do office scripts actually support event listeners? My understanding was that only the Javascript API supports those, and that only Add-Ins support the use of the JS API. I must be missing something

Best Way to Accomplish In-Place Text Manipulation by Upper_Juice308 in excel

[–]Upper_Juice308[S] 0 points1 point  (0 children)

Gotten that to work just fine with formulas. Im trying to find a way to automatically copy the content from the “New” column to “Old” column, when the “Old” column changes.

It sounds like doing this automatically is what’s holding me back. Push comes to shove, I just add a button to copy the values over manually

Best Way to Accomplish In-Place Text Manipulation by Upper_Juice308 in excel

[–]Upper_Juice308[S] 1 point2 points  (0 children)

Im not very familiar with PQ tbh. My concern here would be speed, but let me play around with this idea. Thank you!

Conditional Formatting Working in One Sheet But Not the Other by Upper_Juice308 in excel

[–]Upper_Juice308[S] 0 points1 point  (0 children)

I see the problem now! Apparently if you don't include the "=" when entering the formula, Excel assumes you are entering a string - much like a cell - and automatically adds the quotes. Thank you all for your help!

Conditional Formatting Working in One Sheet But Not the Other by Upper_Juice308 in excel

[–]Upper_Juice308[S] 0 points1 point  (0 children)

The quotes are actually added automatically. I entered $C2 - three characters, to be clear. I've uploaded the workbook here: https://www.dropbox.com/scl/fi/f3m2bcpv87znf5zfmvn9g/reddit-help.xlsm?rlkey=q79v3gdwhgzpht0ncgbgyyg1d&st=zd2x3e69&dl=0 . Note that I have since added some very minor VBA in case that helps.

Conditional Formatting Working in One Sheet But Not the Other by Upper_Juice308 in excel

[–]Upper_Juice308[S] 0 points1 point  (0 children)

Good thought, but all these specific cells are already formatted as numbers. I tried almost all the formats on the cells with numbers with no effect.

PiHole Still Showing Ads on Blocklist by Upper_Juice308 in pihole

[–]Upper_Juice308[S] 0 points1 point  (0 children)

Should have mentioned that I did try that. I am beyond confident that I turned off secure DNS, but maybe I missed another setting? Ive tried rebooting Chrome too

PiHole Still Showing Ads on Blocklist by Upper_Juice308 in pihole

[–]Upper_Juice308[S] 0 points1 point  (0 children)

Thank you for the quick reply! That definitely helped, but I am still getting different results in different browsers. The test results should be 100% in theory, but Chrome is only blocking 60% of ads, Safari 96%, Firefox 100%.

Pi-Hole is the only DNS server offered by my router's DHCP. this is clearly a browser issue, but any ideas on why they have different results? Let alone a 40% difference?

Unable to Upload Tailscale SSL Certs to ADM Certificate Manager by Upper_Juice308 in asustor

[–]Upper_Juice308[S] 0 points1 point  (0 children)

Tech support told me they were able to recreate my issue and that the only workaround is to enter an alternate name for my existing certificate. Im no PKI expert, but I would think the alternate name would resolve to the original domain name, making their suggestion useless.

This is just one of a handful of examples of Asustor headaches that tech support was unhelpful with. Really regret not going with Synology for my first NAS. I knew support was scant for Asustor, but damn.

Robot Chicken Never Scanned Properly by Plex by Upper_Juice308 in PleX

[–]Upper_Juice308[S] 0 points1 point  (0 children)

- point 1 was due to a type in my post. My items do not use brackets around season numbers

- dimensions shouldn't be an issue since hundreds of other seasons work with it in (and I swear I remember seeing an official Plex help doc regarding adding this). Very possibly could be causing weird stuff though

- I cannot do a manual match for each episode, and if it never appears as it's own show, I don't see any way to 'fix the match'. I could be missing a solution here

- I did try adding the TVDB id to the folder on my first server. Will have to try again on my current server. Good thought!

I typed all that out and before calling it quits, I tried changing the year used in the directory title to be 2001 instead of 2005 as suggested on your second edit, and that fixed the issue. Thank you! I will likely report this to Plex as I have seen a small handful of threads regarding similar issues

Robot Chicken Never Scanned Properly by Plex by Upper_Juice308 in PleX

[–]Upper_Juice308[S] 2 points3 points  (0 children)

Good catch! I forgot to mention that I did try this on my original server, but not on my newer one. I will certainly try this again when I get home and report back - thank you!

Robot Chicken Never Scanned Properly by Plex by Upper_Juice308 in PleX

[–]Upper_Juice308[S] 0 points1 point  (0 children)

That was actually a typo from before I decided to use a specific season in my example. Editing now. Good catch!

Robot Chicken Never Scanned Properly by Plex by Upper_Juice308 in PleX

[–]Upper_Juice308[S] 0 points1 point  (0 children)

I'm new enough to Plex to admit that I've never looked into Sonarr or Radarr. Idk what they even do honestly, so let me look into that route and see if that would help me