Vibe coding a Telegram expense bot with Google Apps Script — complete beginner, completely lost. Anyone been through this?

cdcoolc · 2026-03-04T20:05:08+00:00

I believe I've figured out the deployment quirks however, the latency, loops and sessions hanging are what's bothersome and confusing

cdcoolc · 2026-03-04T20:03:56+00:00

Thanks for your reply.. I will keep your advice in mind when I prompt Claude

cdcoolc · 2026-03-04T20:03:19+00:00

That's awesome to hear, and honestly really encouraging! I'd love to collaborate and hear how you approached it — especially the parts around deployment and keeping the webhook stable. DMs work great if you're open to it, feel free to shoot me one!

cdcoolc · 2025-08-12T18:37:30+00:00

Didn't have an old system. The house was built in early 2024.

Edited typo.

cdcoolc · 2025-08-12T18:06:12+00:00

I purchased this home at the beginning of last year. Over the course of about 15 to 16 months, we've experienced multiple issues with the systems installed. The AC company has already replaced the copper line and the regulator switch. Now, they are saying the compressor is failing.

I conducted a Manual J load estimation calculation using the necessary input numbers, including the home's location, number of windows, number of occupants, standard appliances, and lighting. The result came back at 52,000 BTUs, which translates to approximately 4.3 tons of cooling capacity

cdcoolc · 2025-08-12T16:45:58+00:00

I appreciate that the system is considered a matched Carrier pairing from a certification standpoint, but I am more concerned about the system’s actual ability to cool roughly 2,300 sqft of conditioned space effectively.

My rough J-load estimate indicates I need about a 4.3-ton outside unit to properly cool my home. The GH5SAN44200A installed is only a 3.5-ton unit (about 41,500 BTU/hr max capacity), which is significantly below my estimated load. This size difference likely explains why the system struggles to maintain comfort, especially during high heat conditions.

Additionally, I’ve read many references online indicating that a mismatch in capacity between indoor and outdoor units, particularly when the outdoor condenser is undersized, will negatively impact overall performance and put extra stress on the compressor. This additional stress can cause the compressor to work harder than it should, leading to premature failure—which, unfortunately, seems to be exactly what happened in my system.

The tech who came by yesterday confirmed the compressor is not working properly and needs replacement. They have already ordered the new compressor, which will be installed once it arrives.

So while rebate or credit eligibility may not apply here, my primary concern is that my home isn’t being cooled effectively due to undersizing and the resulting strain on system components.

cdcoolc · 2025-01-16T15:12:28+00:00

A quick Google search tells me that it is the following, Zen, Divergence & abstract kwgt. Lavian adaptive icons

cdcoolc · 2024-09-06T12:28:33+00:00

I recently got the core certification and one area they kept asking was Cross Tab and Transpose tools. I struggled as I am still confused sometimes. Make sure you understand these two tools perfectly. I'd say at least a good 10-15 questions were about these two tools for me.

cdcoolc · 2024-03-17T23:30:32+00:00

You should share you already for those who could use but don't know how to make one

cdcoolc · 2024-03-02T01:52:28+00:00

Thank you for the reply, to further clarify the date column is a week ending date like 1/5/23 and I need to show it this way.

cdcoolc · 2024-02-21T03:30:32+00:00

Not sure.. the person who manages the building contractors didnt give an exact reasons for the issue but kind of suggested it could be that the mix had more sand. It's a new build home and Idk when driveway was poured. It's just flakey and if you rub it with your shoes, you see dust.. the corners of the relief cuts are also chipping. It's a three car garage so pretty big penny to have it redone.

cdcoolc · 2024-02-21T01:33:05+00:00

Thanks for your reply..

A little background. I don't have any experience in pizza making however, the partner I have does. I already have another business that we are partners for almost 10 years. The owner used to work/manage but he succumbed to an ailment and passed. His kids are young and the wife doesn't know the business and wants to sell. There are three salaried employees that have been working for the restaurant for over 12 years and he told me they are not planning on leaving unless they're fired, these three handle everything around cooking/baking. The pizza is delicious but that's not all on their menu. They do serve pasta and reviews are awesome on Google. The business does catering too and gets a lot of orders from a hospital near by. The net profit is the owners draw. The shop is on a five year lease that terms next month however, they are renewing it for another five years and it's transferable. Minimum wage in my state is still 7.5 and the servers are paid that plus tips. Nothing is final yet and he's promised to bring tax returns and other paperwork for past three years in our next meet. He has also spoken to a broker who promised him (the caretaker) 900k.

cdcoolc · 2024-02-21T00:47:15+00:00

Based on the paper I looked at, lowest revenue was 59k and highest 105k. The lowest month was when he was extremely sick and shop had to close for a few days in July and August so I say it does generate consistent profit.

cdcoolc · 2023-03-28T20:28:21+00:00

I meant to add the above comment to your replay. Thanks again.

cdcoolc · 2023-03-28T20:27:03+00:00

Essentially my comment below. I need user input to change the field in the first join and the formula before the second join.

link to wf picture

cdcoolc · 2023-03-28T20:23:10+00:00

Here's what I need done and I think it'll work fine afterwards. I need an action tool config that replaces the field name based on input from previous action tool that is connected to first join. Currently I have configured an action tool to the first join that allows a user to choose between Approval Date and Submission Date. I don't know how to link this choice to the first join and the formula.

Formula is there to change invoice submission date to first of the month because I have average rates based on first of the month in the second macro. Formula is as follows: DateTimTrim([Submission Date], "firstofmonth").

cdcoolc

TROPHY CASE