Team builds database

Hi,

A couple of things about reading the forum for Team ups
Sometimes people abbreviate, eg GSBW took me a long time to get grey suit black widow…
Sometimes people don’t say which star variety it is… Star Lord could be 3/4/5 star

And sometimes you know you read about a team for character x. But you can’t find it.

So I made a db with a google form.
It will store peoples entries and then is searchable.

Form for entering team is MPQ Teams POC - Google Forms

For looking at the list of teams is MPQ Teams POC - Google Sheets (only a few I entered so far…)

Tell me what people think.

Tim

Please folks. Enter some teams. Becomes more useful the more it used

Any chance you can sort the characters in the selection dropdowns?

I have them by star. I will sort by alpha later.

sorted by power/star level, then alphabetical (some exceptions Sam Wilson under S not W)
Correct some dupes, and ambiguity (eg Peter parker and Back in Black both level 5 spiderman)

Remember you can type in pulldowns, but will bring you to the highest level one.

it would be nice to see the character builds too.

I will put it in the suggestions…

Just go to the character threads and the fun team thread. There’s stuff there to collect.

I have pulled some stuff from there. I mainly wanted an easy to read, easy to search DB of teams. For those times your like, I really should be able to do more with _________.

I added a few, including a bug check. You can enter the same character more than once. (My error check is the Gambit 5/Gambit 5/Gambit 5 - Does it really matter who he is paired with???)

Thanks, I am not sure how to prevent in forms. I will check into it…

@sambrookjm
Hi, there is no error checking on dropdowns in google forms. So I thought I would setup the sheet to look for duplicates by row. But conditional formating is not applies to form propagated entries. I don’t want to use more time on it, maybe I will have someone with more modern programing volunteer to help…

Added a selection for Use: PVE/PVP/Node clearing.

any thoughts…

Thanks for the effort. I did notice that the Gambit x3 team was missing the last time I checked the sheet.

As for node clearing, goons is pretty easy. Tile movers are a bit more difficult.