Copying Google sheet Template seems missing DeveloperMetadata

[SPCsoft Solutions]

I developed a Google Sheets add-on called Pivot Expense Split with several templates. User needs to make a copy of a template before using it. In the template, I ran below to save a template ID 'T1':

SpreadsheetApp.getActive().addDeveloperMetadata('template', 'T1', SpreadsheetApp.DeveloperMetadataVisibility.DOCUMENT);

When user activiate my add-on on the copy, I have below to read the template ID 'T1':

var value = SpreadsheetApp.getActive().createDeveloperMetadataFinder().withKey('template').find();

var template = value[0].getValue();

From the Apps Script activity log, I noticed that after installation, users open my setup page:

https://spcsoft-galaxy.blogspot.com/p/pivot-expense-split-setup.html

I suppose user has copied the template. My log shows that the activation function was ran several times but my script could not find the template ID.

I tested the same flow myself (install → copy template → activate), and activation works fine on my end.

Could anyone help me identify what might cause this issue? Any suggestions or troubleshooting ideas are appreciated!

[Om Banerjee]

Please call me 9911529853

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/23b70802-a44d-44ba-8e19-cb1625cd04dan%40googlegroups.com.