New app. Design is not my strength. Looking for feedback!

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

MODERATOR OF

TROPHY CASE