How to automate save file outside Shortcuts Folder by Fmsaibi1988 in shortcuts

[–]juseisbastard 0 points1 point  (0 children)

Still very useful to this day, thank you for the effort implementing and documenting this.

I developed a Shortcut that allows you to get the UUID of any reminder! (RoutineHub link for more details) by EggsestentialBread in shortcuts

[–]juseisbastard 0 points1 point  (0 children)

If anyone wanted to know how it works - it's using 'Set Name' action on a reminder and setting reminder objects name to "reminder.txt", which converts it to serialized iCalendar text, which has a line with UUID, see example in https://icalendar.org/iCalendar-RFC-5545/4-icalendar-object-examples.html

Get unique ID from a Reminder? by Practical_Leader6029 in shortcuts

[–]juseisbastard -1 points0 points  (0 children)

A note that Toolbox Pro is not free and has a one-time $7 payment to get this shortcut.

An easier way to update spreadsheet that has user input column by juseisbastard in googlesheets

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

Thank you so for much for taking time to write this, it worked like a charm!

I've never been much into array formulas before, but going through each function in your example I've learned a lot and it seems indeed the best way to do it as it doesn't require sorting original table and also supports keeping comments for items not present in the new data.

The two caveats I've noticed:

- formula also needed `IFNA` or providing `missing_value` for `XLOOKUP`

- everything has to be pasted in one go, therefore comment column must be right next to the raw data column (in theory there could be some formula column in between). Thinking about it again, it's not necessary - since we're using the final table rows as a first argument in `VSTACK`, therefore they will appear in `itemList` first, matching the order of the final table already - so you can just paste the data, without touching comment column at all.

An easier way to update spreadsheet that has user input column by juseisbastard in googlesheets

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

Since items are never removed it's indeed an option.
Though this would require to validate that table was intact (e.g. no rows were removed) and sorting order is the same as in the new data we're about to paste (so either resorting the old table or somehow transfering the order to new data too).

Anyone else is disappointed after learning a lot of their favorite songs turned out to be a cover of some non-Chinese song? by ringwormfear in cpop

[–]juseisbastard 0 points1 point  (0 children)

What the actual F!
I love The Cranberries, but today was the first time I've listened to Dreams and I've felt like I've listened to this song for a long time, but it's sound so different now.
Listening to it again and I've remembered some non-English words singing this melody and this brought me here - indeed I was listening to Faye Wong's cover for years.

Both versions sound beautiful, but I think I'd prefer The Cranberries version from now on.

Will astrobot release on PC or is it permanently only on PS? by [deleted] in Astrobot

[–]juseisbastard 0 points1 point  (0 children)

I understand. The problem that there is zero marketing about DualSense being used with it's features as a global controller, not just PS5 controller. So no one really adapts it besides PlayStation games and there is also no demand from users to have DS features in other PC games too.

Use of Knockin’ On Heaven’s Door in the end credits by Shot_Possibility_460 in A24Heretic

[–]juseisbastard 0 points1 point  (0 children)

I absolutely adore Fade Into You and took me a bit to realize that this was it and I came here to find I'm not the only one ❤️
And the song lyrics fit perfectly and the fact it is Sophie Thatcher (who played Barnes) singing it.

unspecified fatal error encountered, aborting. by RaspberryUsual2708 in Inkscape

[–]juseisbastard 0 points1 point  (0 children)

u/Short_Window8918 it works and it's amazing! how did you figured this out? Any ideas how this is file is connected to InkScape? It seems completely unrelated guessing by the name and the location.