How to avoid re-authorization request for a copied Google Spreadsheet + script -
i have spreadsheet functions template weekly reports. @ point copy undated template sheet using driveapp file has date in name. user shown date-specific spreadsheet , can interact it. when done user instigates function copies of portion of spreadsheet data third file.
every time user calls function authorization request shown. trying avoid authorization request. possible?
i using stand-alone google apps script copy original template date-specific file. have considered trying perform of ui there. there many contingencies make practical. stands once template copied stand-alone script returns url of date-specific file , ends.
every time user calls function authorization request shown. trying avoid authorization request. possible?
publishing script add-on facilitate this; each user need authorize add-on once, , authorization remain in effect in sheet add-on used in.
Comments
Post a Comment