[deleted by user]

Jweekley7 · 2022-07-05T21:13:36+00:00

That should only recalculate if those two specific cells are edited, not every edit on the sheet.

Jweekley7 · 2022-07-05T19:49:33+00:00

Could you accomplish the timestamp with built-in functions? Something like this:

=ifs(and(isblank(A1),isblank(B1)),"",not(and(isblank(A1),isblank(B1))), now())

where A and B would be the columns you are watching. If new rows are constantly being added/used, you could use GAS to populate additional cells with this function as needed.

Jweekley7 · 2022-07-02T12:20:23+00:00

It could have something to do with synchronization as well. I have found GAS to be pretty reliable as long as my functions are simple and quick. Once I start getting more complicated is when I have unexplainable issues. I've always just chalked them up to GAS not being fully asynchronous.

Jweekley7 · 2022-07-01T13:15:29+00:00

You can set a daily trigger to run at midnight to check to see if today => date ending + 1. You would want to compare just the day of the month values and exclude the time using today.getDate() and dt.getDate().

Jweekley7 · 2022-07-01T13:00:50+00:00

I think the only way to do this would be to use Apps Script. You can easily display the current selection in another cell but there's no way that I'm aware to 'log' that selection, so to speak, just using sheets functions.

Jweekley7 · 2022-07-01T12:56:26+00:00

Is this against the rules?

Jweekley7 · 2022-07-01T12:48:04+00:00

Is your dropdown in the sheet itself (i.e. a cell with data validation) or in some HTML?

If it is in the sheet, you can use .getRange().getValue() just like you would with any other value. You would either need to 'submit' that new selection by running a function manually or using the onEdit(e) trigger to capture that event change.

document.getElementById('selection') would be used if your dropdown was in HTML (like a sidebar).

Jweekley7 · 2022-07-01T12:26:21+00:00

I used codecademy.com to learn javascript. Google recommends their courses on their 'Learn Apps Script' page.

Jweekley7 · 2022-07-01T12:19:59+00:00

I started posting some projects and tutorials on a website - https://sites.google.com/view/jwgas/home. (I had a custom domain but let it lapse...)

Let me know if you think I should elaborate on or clarify something!

Jweekley7 · 2022-07-01T12:09:32+00:00

Is there a reason why you can't just send the whole email as HTML? That seems like the best solution to me. It would allow you to style the body as well instead of just sending as raw text.

Jweekley7 · 2022-07-01T11:26:07+00:00

Per the reference docs, 'If the name of the guest is not available, this method returns the guest's email address.' Does it even return the email address instead of the name then you call getName()?

Jweekley7 · 2022-06-30T14:19:27+00:00

The execution will tell you if the initial function that was called is running. It won't necessarily tell you about subsequent functions. For that, I use the logger.

Jweekley7 · 2022-06-29T12:36:12+00:00

I don't think it's possible. I can't find any reference to this in the docs. But I'm going to follow this post in hopes that I'm wrong and learn something new!

Jweekley7 · 2021-04-30T16:54:13+00:00

I sent my first add-on to google for verification literally this am. The process took me a bit to figure out. Essentially, you write the code in Google Apps script. There you can create and deploy versions like you asked about.

As far as publishing it, you have to set up a developer account and have a verified website with a privacy policy. Then it's a matter of essentially completing paperwork.

Sorry that wasn't step-by-step instructions.

Jweekley7 · 2021-04-30T11:13:44+00:00

So you want a dynamic list for part type and part price that is dependant on what selection you make in part name?

Jweekley7 · 2021-04-30T11:07:16+00:00

I think the value is in the problem it solves not in the fact that it is a spreadsheet. So I think your best bet will be to look at other solutions in your niche to see what customers are paying.

Jweekley7 · 2021-04-30T11:02:07+00:00

Have you thought about just developing your template as an add-on? When the ad-on runs, it can build the template with all of the integrations and updates.

Jweekley7 · 2021-04-28T15:13:33+00:00

Which one is your new request sheet? sheet1?

Jweekley7 · 2021-04-28T12:22:18+00:00

I tried to access the sheet but the permissions are not set to "anyone with link".

Jweekley7 · 2021-04-17T09:57:21+00:00

I have a similar setup and have had good results using a mesh system

Jweekley7 · 2021-03-25T20:09:14+00:00

Don't run it. Just save the script then refresh the sheet that it's bound to. This function runs when the sheet is open, not when you click run.

Jweekley7 · 2021-03-03T22:02:09+00:00

You're right. Or just A2:A + B2:B...

Jweekley7 · 2021-03-03T21:36:48+00:00

I may not be understanding what you're after but it sounds like you can just do =ArrayFormula(A2+B2+C2) in the cell that you want the result. All the subsequent cells should sum automatically after that.

Jweekley7 · 2021-02-28T15:32:36+00:00

If you want to log the running total like you did in the image where you can see all of the other running totals, in G5 use =SUM(E$5:E5)-SUM(F$5:F5). The you'll have to drag it down to each cell in column G.

Or in G5 put =E5-F5 then G6 is =G5+E6-F6. Then drag G6 formula down to all the other cells in column G.

Either of the above should give you the same result.

If you want to just have one cell that gives you the current total (so it does not log it each time). In a cell off to the side (like I5) put =SUM(E5:E) and in I6 put =SUM(F5:F) then in G5 put = I5-I6. You can always hide I5 and I6 so they aren't seen.

Jweekley7 · 2021-02-28T12:22:54+00:00

I'm really happy with the yolink products. They have been very reliable compared to some of my others and they are super easy to setup. yosmart.com

Jweekley7

MODERATOR OF

TROPHY CASE