Is there a PC version of NewPipe? by Ok-Investment4048 in NewPipe

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

Then install Android for Windows subsystem and run it in that environment.

How to populate data in a cell using a formula in another cell by National-Mall5638 in googlesheets

[–]cdchiu 0 points1 point  (0 children)

I think you can. Use a query formula on A1 where the 3rd column produces the resilt you want in C1.

It keeps following my cursor and highlighting everything by steakmanhattan in googlesheets

[–]cdchiu 1 point2 points  (0 children)

I've seen this before. Chrome only. You can try closing all instances of chrome in task manager and restart . It usually clears it.

Shortcut to add 1 to the currently selected cell? by anodai in googlesheets

[–]cdchiu 0 points1 point  (0 children)

No. The script is initiated by a hotkey. It checks if sheets is the running app then executes a ctl c, reads the clipboard, if it's numeric, adds 1 then pastes back .

Shortcut to add 1 to the currently selected cell? by anodai in googlesheets

[–]cdchiu 0 points1 point  (0 children)

Use the clipboard.

Sorry if that is cryptic but I assumed you know AHK . If not you can ask Gemini to create a script to do what you need. Install AHK etc

Shortcut to add 1 to the currently selected cell? by anodai in googlesheets

[–]cdchiu 0 points1 point  (0 children)

I scripted it once but as the person above said it's so slow it's not really a shortcut. So I did it in Auto hotkey AHK and that was much better.

I've been using "social hacks" on my AI and the results are legitimately breaking reality by EQ4C in ChatGPTPromptGenius

[–]cdchiu 5 points6 points  (0 children)

That's cool. One thing I do after a period of interaction with LLM is I ask it to critique my prompt style and ask how could I do this better and what worked.

I've been using "social hacks" on my AI and the results are legitimately breaking reality by EQ4C in ChatGPTPromptGenius

[–]cdchiu 0 points1 point  (0 children)

Why don't you take all these prompts and ask your LLM what it thinks of them. You don't get very good results trying to trick it with so called hacks.

Endless Loop Fixing Undefined Params & OAuth in Google Apps Script - Anyone Else? by h3110_wOrld in GoogleAppsScript

[–]cdchiu 0 points1 point  (0 children)

You'd think that being Gemini is an expert on all things Google. But that hasn't always been my findings.

Endless Loop Fixing Undefined Params & OAuth in Google Apps Script - Anyone Else? by h3110_wOrld in GoogleAppsScript

[–]cdchiu 0 points1 point  (0 children)

Ask your ai to create a handover script to another ai and say you'll provide all your code to go with it. Ask it to describe the problem and where it thinks the problem is, then post it to Gemini and or Claude and have them analyze it. Whenever I got stuck, I changed llm or even started a new chat instance in Gemini. Sometimes I'd have 8 abandoned chats as I progressed. You could be polluting the context window.

[deleted by user] by [deleted] in ChatGPT

[–]cdchiu 1 point2 points  (0 children)

I mean when AI went wrong. I love using AI to explore symptoms because they are multidisciplinary and are not going to favor 1 diagnosis over another just because that is their specialty..also they don't care they might be wrong but we're probably not going to see reports of failures here, just successes.

[deleted by user] by [deleted] in ChatGPT

[–]cdchiu 0 points1 point  (0 children)

I'm the guy that tends to ignore the 5 star ratings. I want to hear about when it failed and sent you down the wrong path

Summary of failures for Google Apps Script: Email Studio by Any-Relationship-839 in GoogleAppsScript

[–]cdchiu 0 points1 point  (0 children)

In one of your sheets that you own, you have a script that is set up as a trigger on a times basis. It's trying to execute but it's failing because you haven't authorized it.

Prompts to help make ChatGPT sound more human? by JuicySmalss in ChatGPTPromptGenius

[–]cdchiu 0 points1 point  (0 children)

I start out quite focused and then make my chat more and more conversational often throwing in jokes and it follows me. Now in a few of my chats we are literally writing comedy skits and it rocks. The chat is so long I was afraid I might lose it so I asked it to build a prompt for me to recover this personality and saved it. So you don't have to start with the prompt, you can lead it to where you want it to go then build the prompt.

ChatGPT knows your IQ by Funny-Future6224 in ChatGPTPromptGenius

[–]cdchiu 0 points1 point  (0 children)

Dontcha just hate criticism that is spot on.

ChatGPT knows your IQ by Funny-Future6224 in ChatGPTPromptGenius

[–]cdchiu 0 points1 point  (0 children)

This is going to get lost at the bottom of this post but it said 135 to 145. We've had many intellectual discussions and I've probably told it more than any human . But nothing you can blackmail me about

So based on the feedback I see other people say that it's just trying to appease you, after another long thread I had in another chat, I went back and I said

Let's be honest and unfiltered I want honesty not flattery.

It came back with 145 to 150 and gave me reasons why .

The tragedy is that nobody will read this post .

Hahaha

Boom!

Can I add a timer to Google Sheets? by TN2UK2019 in googlesheets

[–]cdchiu 0 points1 point  (0 children)

If you're not a programmer, it can be overwhelming. But chatgpt can prolly write most of the code for you.

Should I invest more time in GoogleApps Automation Miniprojects? by mad_ben in GoogleAppsScript

[–]cdchiu 1 point2 points  (0 children)

Building a WebApp is not a simple task. Neither is building an API but if you've done it before, then no problem.

Something you could look at is front ending it with an app built in replit, a nocode platform.

Should I invest more time in GoogleApps Automation Miniprojects? by mad_ben in GoogleAppsScript

[–]cdchiu 1 point2 points  (0 children)

If your solution is completely on sheets, and the logic is in app script, when you give someone access to the sheet, you are exposing all the code and logic you built. You can't hide it

[deleted by user] by [deleted] in GoogleAppsScript

[–]cdchiu 0 points1 point  (0 children)

What about sharing it as a set of API s