(General) Expose file name template - Githubissues

Synthoid / ExportSheetData

Add-on for Google Sheets that allows data to be exported as JSON or XML.

MIT License

237 stars 46 forks source link

(General) Expose file name template #106

Open Synthoid opened 4 years ago

Synthoid commented 4 years ago

Add an option to override file naming with support for template keywords. For example:

_	Value
Sheet	Test
Tab	Sheet01
Name template	%sheet%-%tab%

Would export a file named: Test-Sheet01

Synthoid commented 4 years ago

Keywords would need to be flanked by special chars, likely %.

Possible keywords:

Sheet specific keys:

%sheet% - The sheet's name
%tab% - The tab's name
%format%- The current export format (JSON or XML)

General keys:

%date% - The current date
- Variants like %date-day% or %date-time% could have more specific formatting
%user% - Username for the person running the export

File keys:

%id% - The [ID for the sheet file](https://developers.google.com/apps-script/reference/drive/file#getId())