*grimaces* Sheets doesn't want to work for me; I had to delete teh assignment and reassign it to make it work. Just in case anyone else has any issues.
The script is assigned to the RESET button. And I can click it. But I get the following error:
There was a problem
Script function ClearTrainingFields could not be found
this happens on every page, including the intro for 'all'.
If I click 'Assign script' the correct one is there for the given page; I just copied it, deleted it, saved, opened up 'Assign script' again, and pasted it in and saved and now it works :rolls eyes:
Semi-related; I want to Separate the 'skins dropped in chests' from the 'skins dropped as skins' in each of the venues. Will there be an impact on the script if I do that? I'm planning to add the skin-chests to the 'Treasure Chests' line(s) and then condense down the skins to whatever few are dropped as items.
*grimaces* Sheets doesn't want to work for me; I had to delete teh assignment and reassign it to make it work. Just in case anyone else has any issues.
The script is assigned to the RESET button. And I can click it. But I get the following error:
There was a problem
Script function ClearTrainingFields could not be found
this happens on every page, including the intro for 'all'.
If I click 'Assign script' the correct one is there for the given page; I just copied it, deleted it, saved, opened up 'Assign script' again, and pasted it in and saved and now it works :rolls eyes:
Semi-related; I want to Separate the 'skins dropped in chests' from the 'skins dropped as skins' in each of the venues. Will there be an impact on the script if I do that? I'm planning to add the skin-chests to the 'Treasure Chests' line(s) and then condense down the skins to whatever few are dropped as items.
@ThistleProse Yeah, Sheets scripts are finicky and I've encountered the same error even as the maker of the sheet. Sometimes it works, sometimes it doesn't, and when it doesn't I just refresh and come back to it. Ta-da, it works again. No clue why. Stupidly annoying, wish I knew more.
As far as tweaking your sheet to customize it to your needs, that shouldn't be hard as long as your comfortable with going into Apps Script and doing a little fiddling yourself (and it's very straightforward). Adding or removing rows in the sheet may require you to do that if you wish to keep the scripted reset button, but it's as easy as typing in and deleting ranges in the code.
Menu Bar > Extensions > Apps Script. Should open up the script in a new tab, and you can edit the sheet's cell ranges as needed.
@ThistleProse Yeah, Sheets scripts are finicky and I've encountered the same error even as the maker of the sheet. Sometimes it works, sometimes it doesn't, and when it doesn't I just refresh and come back to it. Ta-da, it works again. No clue why. Stupidly annoying, wish I knew more.
As far as tweaking your sheet to customize it to your needs, that shouldn't be hard as long as your comfortable with going into Apps Script and doing a little fiddling yourself (and it's very straightforward). Adding or removing rows in the sheet may require you to do that if you wish to keep the scripted reset button, but it's as easy as typing in and deleting ranges in the code.
Menu Bar > Extensions > Apps Script. Should open up the script in a new tab, and you can edit the sheet's cell ranges as needed.
This will make tracking festival drops so much more efficient! Thank you!
I just got an Ancient Gene Parchment: Swallowtail drop from Forgotten Cave! (wasn't sure if you were still working on adding these or not, so I thought I'd bring it to your attention!)
Thank you for this amazing sheet! It's made life so much easier! <3
I just got an Ancient Gene Parchment: Swallowtail drop from Forgotten Cave! (wasn't sure if you were still working on adding these or not, so I thought I'd bring it to your attention!)
Thank you for this amazing sheet! It's made life so much easier! <3
[quote name="@SakuraSundae" date="2024-11-25 21:48:25" ]
I just got an Ancient Gene Parchment: Swallowtail drop from Forgotten Cave! (wasn't sure if you were still working on adding these or not, so I thought I'd bring it to your attention!)
Thank you for this amazing sheet! It's made life so much easier! <3
[/quote]
I'm currently working through adding the new content to each venue! This includes the Everlux gene Coli drops as well as the item drops that now drop from new enemies (from the [url=https://www1.flightrising.com/forums/ann/3378654]Gaoler Displays[/url] update)!
I'll make an official post and send a ping when everything is properly added and up to date :)
I just got an Ancient Gene Parchment: Swallowtail drop from Forgotten Cave! (wasn't sure if you were still working on adding these or not, so I thought I'd bring it to your attention!)
Thank you for this amazing sheet! It's made life so much easier! <3
I'm currently working through adding the new content to each venue! This includes the Everlux gene Coli drops as well as the item drops that now drop from new enemies (from the Gaoler Displays update)!
I'll make an official post and send a ping when everything is properly added and up to date :)
Grr..> I can't figure out why because I can't seen an issue with the code but for some reason the 'Silk-Strewn Wreckage' tab, the 'Vial of Hypnotic Sight' isn't going into the copy & paste boxes D<
lmao
FIGURED IT OUT lol; row K97 is looking for the code in the J column. The other sheets seem to be fine (at least, the ones i checked XD)
Grr..> I can't figure out why because I can't seen an issue with the code but for some reason the 'Silk-Strewn Wreckage' tab, the 'Vial of Hypnotic Sight' isn't going into the copy & paste boxes D<
lmao
FIGURED IT OUT lol; row K97 is looking for the code in the J column. The other sheets seem to be fine (at least, the ones i checked XD)
[center][b]Spreadsheet Update (November 28, 2024):[/b]
Happy Thanksgiving to those who celebrate! And to those who don't, hope you had a wonderful day :)
New updates are now live on all the sheets! this includes quite a few things:
The newest breeds have dropped! You can now find the Coli Everlux genes [b]Papillon[/b] and [b]Swallowtail[/b] on all sheet tabs. Yippee!
[item=Primary Everlux Gene: Papillon][item=Secondary Everlux Gene: Swallowtail]
That's not all! The [url=https://www1.flightrising.com/forums/ann/3378654]Gaoler Displays update[/url] added a bunch of items to the Coliseum! You can now find all of these in their respective venue tabs :)
[item=Blushing Pink Rose][item=Golden Birdskull Necklace][item=Violet Corsage][item=Violet Highnoon Hank][item=Sparkling Violet Arm Bow]
As always, please ping me if you notice any errors! Have a great rest of your Rockbreaker's! [emoji=earth rune]
@pinglist-33558
Happy Thanksgiving to those who celebrate! And to those who don't, hope you had a wonderful day :)
New updates are now live on all the sheets! this includes quite a few things:
The newest breeds have dropped! You can now find the Coli Everlux genes Papillon and Swallowtail on all sheet tabs. Yippee!
Primary Everlux Gene: Papillon
Specialty Items
A scroll that will change the primary gene of one Everlux dragon to Papillon. This item can only be used once and will disappear after it has been applied.
250
Secondary Everlux Gene: Swallowtail
Specialty Items
A scroll that will change the secondary gene of one Everlux dragon to Swallowtail. This item can only be used once and will disappear after it has been applied.
250
That's not all! The Gaoler Displays update added a bunch of items to the Coliseum! You can now find all of these in their respective venue tabs :)
Blushing Pink Rose
Apparel
A vibrant, pink rose with a sweet fragrance. Pink roses are seen at the onset of spring, but quickly die out.
750
Golden Birdskull Necklace
Apparel
A loose-hanging fetish of skulls and golden charms. The feathers are said to have medicinal properties for the wearer if held close to the heart.
1350
Violet Corsage
Apparel
A violet corsage, a gift from a charming someone.
1500
Violet Highnoon Hank
Apparel
A simple purple bandana tied around the neck blocks the sun and really pulls the whole look together!
450
Sparkling Violet Arm Bow
Apparel
A soft and glittering purple ribbon tied into the perfect bow.
500
As always, please ping me if you notice any errors! Have a great rest of your Rockbreaker's!
hello! i love these sheets a lot and have been using them to enhance my coli experience for a bit now :) i'm trying to update them with the new stuff currently and it's um. not. working great? i tried to copypaste in the new boneyard apparel section and the rows and such all ported over okay but none of the images are showing up and i don't think the coding's working either. am i doing something wrong? how should i go about updating the sheet?
hello! i love these sheets a lot and have been using them to enhance my coli experience for a bit now :) i'm trying to update them with the new stuff currently and it's um. not. working great? i tried to copypaste in the new boneyard apparel section and the rows and such all ported over okay but none of the images are showing up and i don't think the coding's working either. am i doing something wrong? how should i go about updating the sheet?