SOLVED, with a huge thank you to [email protected] https://lemmy.world/comment/6271130

Hiyo Librecalc pros. Hoping someone has an idea how to automate or minimize the steps for this. Or where should I start? I'm trying to automate transcribing a list from: Closet_01 Cartridge123 Cartridge234 Garagenook_01 Cartridge456 Toolbox567 Toolbox789 Garagenook_02 Cartridge890

Into an array/table like: Cartridge123, Closet_01 Cartridge234, Closet_01 Cartridge456, Garagenook_01 Toolbox567, Garagenook_01 Toolbox789, Garagenook_01 Cartridge890, Garagenook_02

I get it; I should just carry around a barcode list of all my shelf names and take turns between scanning the list, tabbing over on my phone, scanning a box, then tabbing back again. But... what if I want to be lazier and just scan things in an order and automate the rest later?

Is there a faster way than copy-pasting my way down?

I got as far as making an adjacent column with a formula to check for "_", then copying the location if "_" was found.

Short term: I'm trying to automate transcribing a list from: A 123 234 B 456 567 789 C 345

Into an array/table 123, A 234, A 456, B 567, B 789, B 345, C

Long term answer I'm looking for: where's a lemmy community I can ask questions like this (like about using formulas in Librecalc/Onlyoffice suite/maybe VBA with them too) in the future?

Or, if not yet established on lemmy, recommended librecalc/Onlyoffice forums?

Thank you for your time.

Hope this is one of the next best places to post and be able to return to. Going to the spotify/meta hosted community forum isn't working out for me due to login issues on multiple browsers and difficulty finding a report like my problem. Typing in just "Jam not working" on their website didn't even bring slightly relevant results.

So, each time I click a link a friend shares with me to join their Jam (formerly known as Group Session), the spotify app opens. If opened earlier and not on my homepage, it switches to the homepage. If the app was closed before, it opens to my homepage. After either scenario, nothing happens. If I'm playing spotify music already, the app opens to my homepage, and the music keeps playing. If I initiated a Jam, then click my friend's invite link, it opens to the homepage, the music I had continues playing, it shows I'm still in my own Jam, and nothing else happens. No matter how long I wait for something to happen after the homepage shows up, my friend's jam never comes up on my screen.

In case this is relevant:

• Running android 13
• Spotify version 8.8.80.599
• VPN sometimes on, sometimes off, but same bug occurs either way. About a week ago, spotify would only open to show a message along the lines of "no internet connection", but it went away once VPN turned off.
• Logging in through fb account without issue, even after uninstalling/reinstalling the spotify app
• Subscribed with Premium Duo as main account manager (post edit: this fact was actually irrelevant)

Thank you for taking your time to read this post.

SOLVED: Spotify loathes VPNs, maybe? I haven't tested with a home VPN service. Consistently, I only get this problem when my phone is connected to VPN. The little key icon in the top-right appears when I'm connected one of my VPN services. I didn't pay close enough attention earlier. Also consistently, if I induce this error message, spotify jam only works after ensuring my VPN service is turned off (it could still be running, but as long as I'm not connected to vpn) AND I've swipe-closed spotify from my recent apps/task-switcher, then reopened the app.

Hi all. I'm trying to make my own twitch chatbot in the spirit of Linux DIY'ing and masochism; having my own bot's name is waaaaay cooler than a common bot with user-friendly UIs and their plethora of engaging and powerful features, apparently.

TL;DR: How do I min-max learning how to translate the Twitch API documentation for Node.JS? Exact questions at the bottom.

My progress so far on July 9, 2023: I set up a bot successfully using this article but with tweaks: https://www.section.io/engineering-education/build-a-twitch-chatbot-in-nodejs/ Archive .org capture here: https://web.archive.org/web/20230000000000*/https://www.section.io/engineering-education/build-a-twitch-chatbot-in-nodejs/

Changes:

• Skipped the streamyard stuff because, who cares, I have OBS
• I added identity tags under the connection configurations because I kept getting errors in my terminal that my bot couldn't write to chat anonymously (I've never seen anonymous chatting, why the hell is this in the suggested code). Connection config section of the .js file now looks like this:

>const client = new tmi.Client({ options: { debug: true, messagesLogLevel: "info" }, connection: { reconnect: true, secure: true }, identity: { username: ${process.env.TWITCH_USERNAME}, password: oauth:${process.env.TWITCH_OAUTH} }, channels: [${process.env.TWITCH_CHANNEL}] });`

• Kind of nested (is that the right word?) in the switch section, I removed the entire "Upvote" and "Cheers" shenanigans because, for some reason with the suggested code in the article, it replied like "FireEmoji unknown_user unknown_user, you have been upvoted!" to every single line of chat, lmao. The bot would reply to "Watsup dorks" with something like "FiReEmOji @Watsup dorks, you have been upvoted!".
• Also kind of nested in the switch section, I added the random number generator example given in other people's tutorials around the internet and formatted it similarly to the article's method of checking messages like so:

>// When user enters "!rolldice" in chat, bot returns random number between 1 and 20. case '!rolldice': client.say(channel, ${tags.username} rolled a ${Math.floor(Math.random()*20)+1}!); break;

If you would like me to revisit that article's suggested code as-is and be more specific with my errors encountered, I'd be happy to oblidge upon request.

Questions I hope to answer someday: How do I get my bot to see if a message has a hyperlink, then delete that message? How do I set up a whitelist database of usernames for my bot to reference so they could post whatever links? How do I get my bot to timeout people who have entered trigger words in chat? How do I get my bot to change other chatters' name colors in chat? What is the next best source of internet community I can go to for advice on Twitch API use? (It's July 2023 at the moment, and giving Reddit traffic to learn to make moderator bots is, IMO, a bit ironic). How can I learn to translate the Twitch API commands to javascript like this? Is there a library that can tell me in close-to-plain-english that explains things like "client.say() means this, this is how you can use it, and X things must be specified in these brackets for client.say" etc.?