search

PopGoesTheWza / swgoh-tb-sheets

SWGoH Territory Battles Spreadsheets
MIT License
7 stars 2 forks source link

ENHANCEMENT - Use exclusions sheet to import personalized data automatically to new versions #23

Open plumwski opened 6 years ago

plumwski commented 6 years ago

As the sheet gets updated pretty often, I wonder if there is a way that we could use a tab on the Exclusions spreadsheet to import our personalized data.

Things such as (but not limited to): Meta tab SWGoH.gg link

Discord tab Webhook Role Discord text blocks Members and Mention IDs

Right now, I copy all of that, as well as the information on the Estimate tabs.

It would be nice if when the sheet is updated, we only had to update our Exclusion Spreadsheet ID, and all that could be populated for us.

PopGoesTheWza commented 6 years ago

Looking into design and implementation options.

DarkPhoenixSniper commented 5 years ago

@PopGoesTheWza similar to what I started with an Import function. Simply needed a cell with the Old sheet's SpreadsheetID, and then import.

I could revisit this if you want?

plumwski commented 5 years ago

I think it's worth it, it would make updating to a new version much more simple.

On Wed, Apr 17, 2019, 4:38 PM Dark Phoenix Sniper notifications@github.com wrote:

@PopGoesTheWza https://github.com/PopGoesTheWza similar to what I started with an Import function. Simply needed a cell with the Old sheet's SpreadsheetID, and then import.

I could revisit this if you want?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/PopGoesTheWza/swgoh-tb-sheets/issues/23#issuecomment-484271176, or mute the thread https://github.com/notifications/unsubscribe-auth/AKTKNZMHLDEWHJLX74NUFDDPQ6KEHANCNFSM4F7KXU6A .

DarkPhoenixSniper commented 5 years ago

@plumwski what info on the Estimates tab do you copy over?

plumwski commented 5 years ago

from the Meta tab: SWGoH.gg guild link (A2) Exclusion Spreadsheet ID (A7)

from the Discord tab: Webhook (E1) Role (E2) Member and Mention ID (A:B) In fact, pretty much the entire Discord sheet would be useful to be able to be copied

from the Estimate tab: All manually entered data, e.g.: CM Count 1 Tiers CM 1 CM Count 2 Tiers CM 2 Platoon Count % GP Target *

On Sun, Apr 21, 2019 at 9:23 AM Dark Phoenix Sniper notifications@github.com wrote:

@plumwski what info on the Estimates tab do you copy over?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.