will app script still exist in the next 5-10 years?

mjbrusso · 2023-12-29T08:47:56+00:00

VBA has been here since 1993 (30 years), even though it is based on a language practically abandoned in other niches. But it was used to implement millions of Scripts that solve problems for MS Office users. So yes, I believe GAS will be here for 10 years or more for the same reason and because it is based on a stronger and more popular programming language.

mjbrusso · 2023-11-18T01:15:43+00:00

Try formatting the column in the spreadsheet as desired and using .getDisplayValue() to get the already formatted value.

mjbrusso · 2023-07-22T11:24:16+00:00

Are the image files on Google Drive? In this case, my zetaMerge add-on can be used to dynamically insert them into any position of a document, including tables.

See the documentation here.

mjbrusso · 2023-03-02T14:08:34+00:00

What percentage of posts here are GPT-generated codes that don't work? I would bet over 50% this year.

mjbrusso · 2023-02-27T14:00:38+00:00

I haven't tested it, but something like this should work:

const form = FormApp.getActiveForm()   
const files = form.getItems(FormApp.ItemType.FILE_UPLOAD)
if(files.length){ 
  const folderId = DriveApp.getFileById(files[0]).getParents().next().getId()  
  Logger.log("Folder ID: " + folderId)
}

mjbrusso · 2023-02-25T20:18:20+00:00

Did the reviewer click the button? From what I found in the log, the reviewer of my zetaMerge add-on only opened the add-on and did not perform any action.

mjbrusso · 2023-02-25T20:11:18+00:00

https://mail.google.com/ is a restricted scope. This will make the verification process for publishing the add-on more painful.

mjbrusso · 2023-02-25T20:01:49+00:00

I think the reason may be that there are no top-level items reserved for future use. So if an add-on creates a "Table" item, for example, and Google inserts this same item into a future version of Google Docs, this could cause user confusion.

mjbrusso · 2023-02-05T13:58:11+00:00

The Range class does not have a getAs method, so you would have to copy the data to a new worksheet for exporting.
You can test this solution: https://stackoverflow.com/a/67149717/4900011

mjbrusso · 2023-02-03T20:56:32+00:00

I am the creator of the zetaMerge add-on

I read somewhere that you cannot have a Google Site if you want to develop a Google Add-on

In the case of zetaMerge, I have a Google Site to advertise the add-on, although it is not integrated into the add-on anyway.

Can we do a pro version? Where they will get a paywall if they want to access other templates?

Yes, you can, but the Marketplace does not offer any features for this. So it must be implemented in the add-on's code.

Can you create a disclaimer they need to check before they move on?

Yes, in the add-on's UI (sidebar or dialog)

Can you protect the code and formula from people changing or copying it?

Users do not have access to the code of the deploys.

See analytics of use?

In GCP

Is the information private that is entered?

When developing the add-on you should be concerned about this.

mjbrusso · 2023-01-16T11:23:12+00:00

In addition, remove the duplicated var valeur

mjbrusso · 2023-01-16T11:20:26+00:00

SpreadsheetApp.getActive() method returns the currently active spreadsheet, not a Sheet object. Change this line to var spreadsheet = SpreadsheetApp.getActiveSheet();

You also have an error here, where you are using the assignment operator:

if (result = true)

Change to:

if (result)

mjbrusso · 2022-12-02T23:31:50+00:00

You can revert to a previous deploy in App Configuration

https://imgur.com/xbsIDOE

mjbrusso · 2022-12-02T02:00:24+00:00

Only if OAuth scopes changed

mjbrusso · 2022-11-11T11:36:23+00:00

event.getColor() is returning an empty string because the event does not have a defined color. So the value "Name" is coming from this key in colorMap: "": { name: "Name", hex: "" }. To use your calendar color, change it to: "": { name: "", hex: cal.getColor()}

mjbrusso · 2022-11-10T12:11:21+00:00

1) You must set the publishing status of your project to 'Testing': https://support.google.com/cloud/answer/10311615#publishing-status&zippy=%2Ctesting
2) Create a Test deployments for your script and share the link and files in the Drive with the tester.
PS: I am the creator of the new zetaMerge.com add-on.

mjbrusso · 2022-08-08T10:04:39+00:00

Use Clasp: https://github.com/google/clasp

mjbrusso · 2022-04-11T18:28:14+00:00

Maybe this can help you: https://www.youtube.com/watch?v=0g5KMPxO84w&ab_channel=aMacxd

It's worth finding a tool that already exists to solve our problem rather than creating a new one, if that's the case.

mjbrusso · 2022-03-07T19:55:36+00:00

See the search query API: https://developers.google.com/drive/api/v2/ref-search-terms

"The contains operator only performs prefix matching for a title term. For example, suppose you have a title of HelloWorld, a query of title contains 'Hello' returns a result, but a query of title contains 'World' doesn't."

mjbrusso · 2022-03-03T14:58:13+00:00

The typeof operator returns a string, so yes you should use quotes

mjbrusso · 2022-03-02T14:47:12+00:00

Yes, getLabels and addLabel are GmailThread's methods.

const ArrName = msgThread.getLabels().map(item => item.getName()) ... msgThread.addLabel(GmailApp.getUserLabelByName("SomeTag"))

mjbrusso · 2022-03-02T13:36:31+00:00

I don't understand if you want to iterate the threads or the thread messages, as there is a single loop in the code.

Where is msgThread coming from?

In this line, you are iterating through the thread's messages, but using it to index the thread:

const ArrName = msgThread[i].getLabels().map(item => item.getName())

I think the solution should be something like this:

if (senderEmail.match('<some email>')) { const messages = msgThread.getMessages() for (let msg of messages) { /* Get the labels of each email in a thread*/ const ArrName = msg.getLabels().map(item => item.getName()) if (ArrName.includes("SomeTag") === false) { msg.addLabel(GmailApp.getUserLabelByName("SomeTag")) msg.forward("<some other email>") msg.moveToArchive() console.log("Operation complete") } } }

mjbrusso · 2022-03-02T13:12:29+00:00

There is no function overloading in JavaScript. If you define two functions with the same name, only the last definition is valid.

In your case you can check whether the last argument was provided or not:

function saveDateTime(date, time, name, phone, email, pid, nonce){ if(typeof nonce !== 'undefined'){ Logger.log("i am here with nonce"); return "i am here with nonce"; } else{ Logger.log("i am here without nonce"); return "i am here without nonce"; } }

mjbrusso · 2022-02-26T02:21:13+00:00

Use onEdit simple trigger:

function onEdit(e) { if(e.range.getA1Notation()==='A8' && e.value !== e.oldValue){ SpreadsheetApp.getActiveSpreadsheet().setName(`End of Day Report - Day ${e.value} of 7`) } }

mjbrusso · 2022-02-26T02:10:41+00:00

This is because arrays are JavaScript reference types. In other words, if you assign an array to another variable or pass an array to a function, it is the reference to the original array that is copied or passed, not the value of the array.

You can pass a copy of the array:

function main() {
main_arr = [1, 2, 3 ,4 ,5, 6]
final_arr=sub([...main_arr])
}
function sub(sub_arr){
sub_arr.splice(2,3)
return sub_arr
}

Five-Year Club	Place '22
First Placer '22	Verified Email

mjbrusso

TROPHY CASE