05-20-2018, 05:21 AM
@Rurouni
I don't think I'll be able to replicate the website experience from the previous tool.
Due to Google Sheet/Google Scripts limitations any script I create for my Sheet would not replicate on copies.
The major benefit though is that since everyone has their own version it won't go offline.
Plus anyone with a bit of knowledge will be able to update them if necessary (tried to make them as simple as possible formula wise)
Though, found a possible midway option.
This will create the proper string to trigger the download.
---- This should help against mistake (I kept accidentally downloading the "Input Macro" tab instead of the "End Result" tab
Basically, I added a cell that will work as a link/URL that triggers a download function.
You will need to copy YOUR own sheet ID and the "End Result" tab ID in the "Instruction" tab
Added updates in original post.
I don't think I'll be able to replicate the website experience from the previous tool.
Due to Google Sheet/Google Scripts limitations any script I create for my Sheet would not replicate on copies.
The major benefit though is that since everyone has their own version it won't go offline.
Plus anyone with a bit of knowledge will be able to update them if necessary (tried to make them as simple as possible formula wise)
Though, found a possible midway option.
This will create the proper string to trigger the download.
---- This should help against mistake (I kept accidentally downloading the "Input Macro" tab instead of the "End Result" tab
Basically, I added a cell that will work as a link/URL that triggers a download function.
You will need to copy YOUR own sheet ID and the "End Result" tab ID in the "Instruction" tab
Added updates in original post.