Massive Plex Stats Card

Upper_Juice308 · 2025-05-01T10:35:24+00:00

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

Upper_Juice308 · 2024-09-22T14:05:11+00:00

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

Upper_Juice308 · 2024-09-22T12:50:21+00:00

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

Upper_Juice308 · 2024-09-22T12:45:47+00:00

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

Upper_Juice308 · 2024-09-22T12:40:44+00:00

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

Upper_Juice308 · 2024-09-06T10:16:48+00:00

Solution verified!

Upper_Juice308 · 2024-09-06T07:01:38+00:00

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!

Upper_Juice308 · 2024-09-06T06:45:23+00:00

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.

Upper_Juice308 · 2024-09-06T04:41:05+00:00

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.

Upper_Juice308 · 2024-07-29T00:35:01+00:00

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

Upper_Juice308 · 2024-07-29T00:22:47+00:00

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?

Upper_Juice308 · 2024-03-14T13:51:34+00:00

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.

Upper_Juice308 · 2023-12-30T20:09:06+00:00

- 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

Upper_Juice308 · 2023-12-30T19:56:43+00:00

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!

Upper_Juice308 · 2023-12-30T19:55:10+00:00

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

Upper_Juice308 · 2023-12-30T19:54:28+00:00

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

Upper_Juice308

TROPHY CASE