laenavesse: (Default)
laenavesse ([personal profile] laenavesse) wrote in [community profile] efryndiel2022-11-21 11:40 pm

[ commissions ] automation script codes



       

COMMISSIONS
I offer two types of commission services: code automation and plurk emotes. Further information can be found in their own sections below, but here is a quick general overview of how my commissions work.

» I can work with most pre-made codes and adapt them to my automation scripts. Thread trackers (with or without points and/or forms), CR charts, muse lists, info sheets, visuals—if there is anything that involves a lot of repetitive sections or data, I can script it.

» For script commissions, you can contact via PM, comment to this entry, or use my Ko-Fi to purchase a package. However I would like to see the code first to ensure that I can add a script to it.

» For emotes, please request using the current emote request plurk. There is a repository of the main style I make, but I can do other simple styles. The repository will also have a link to the current request plurk.

» Payments go through my Ko-Fi and uses PayPal. You can either pay via Tips or the designated package for scripts.

» Emotes can take anywhere between 1-2 days depending on my schedule. Code scripts can take 1-5 days depending on how difficult it is implement the script. I'll let you know beforehand if there will be a delayed start.


CODE AUTOMATION SCRIPTS
Many DWRPers like the idea of keeping up with thread trackers and CR charts for their characters, but when it comes to actual upkeep we groan because of all the work we have to do. Not only do we have to come up with whatever information we want to put, but we have to add or remove large chunks of code each time; and one wrong mistake can spell disaster, especially for those not HTML savvy.

However, I came up with a solution using Google's AppScript. Those familiar with my automated thread trackers (cottagecore; notebook; collapsible) and cr chart know that basically it turns all data saved in a Google Sheets into a fully coded layout with a simple click of a menu button. It's easy to setup, relatively simple to use, and makes maintenance so much easier. (all images can be clicked on for full view)


While my trackers and CR charts are most well known, here are some other uses for the script with example screenshots:


HEY MODS! Is maintenance taking a toll? I can help with that:


Those are just examples on hand. Anything that has a lot of data, especially repetitive lists, will work very well with spreadsheets and automation scripting. While most of the examples I linked are made using my own codes, as shown by the Info Sheet, I can adapt other pre-made codes to the script. Some other examples can be found under the cut:

EXAMPLES: Below are screenshots of the spreadsheet behind the code that is generated. There's a mix of thread trackers, cr charts, and other codes used.









As I've improved my script and spreadsheets over the years, the spreadsheet layout will look more similar to my Cottagecore thread tracker set up. For those who are interested but haven't really used my automations before, I highly suggest you look at one of them and test out its functionality.


WHAT YOU GET: Regardless of type, you will receive:

  • A customized spreadsheet tailored made for whatever needs and features you need (or as close as possible).
  • Designated Settings sheet that will allow you to customize fonts, colors, etc. for the overall design. The more specificity, the longer it will take and increase in price.
  • Preview feature to allow you to see how the code should look before pasting it into a DW entry.
  • Detailed instructions on how to operate the spreadsheet.
  • Continued support so that if something bugs or a new modification needs to be made, I can help. Usually this won't have an extra charge, but if something big needs to be changed to the script, I may ask for a tip for the time.

Proper credit to the original code maker will be retained.


PRICING:Pricing will vary depending on how robust the project and can be made through my Ko-Fi. But I do have base prices:

  • Thread Tracker: $30USD - depending on what other features you may want to include, the price may increase. Suggested add-ons are points, inventory, form submissions.

  • CR Charts, Muselists: $25USD - these tend to be less complex and easier to implement compared to the trackers. No extra charges for affinity or rating bars.

  • Info/Profile Sheets: $25USD - these may vary depending on how complex the sheet is, but as you can see in my example, I can adapt fairly complex ones.

  • Gallery: $25USD - any gallery type script, including mood boards and visualosities.

  • Mod Package: $40USD - the base price includes script for Taken and Reserve pages. I also offer the following for an additional $10USD each: mission board (or similar), rewards list (or similar), activity/point spreadsheet for players, and any other page that requires constant maintenance and can be adapted.

  • Unique Script: $30USD - if there is a code that doesn't fall into any of the above categories, I can try to create a script for it. This is the base price, but depending on time and complexity, I may increase it. If the code in question can be made using one of my existing scripts, I'll inform you and price it to match instead.

Although I have the commission packages, you can also pay through tips instead if you request indirectly.


REQUESTING:
When making a request, I highly suggest if you ask about the code first before making an official order. This is just so I can confirm that I am able to do it. Once I get the request, it will take (hopefully) no more than a week to complete once I start, though so far it has been less.

You can make a request by commenting here, PM, or through my Ko-fi.


PLURK EMOTE LABELS
I have two types of Plurk emotes I can offer to make. If you have a request, please PM on my main plurk at [plurk.com profile] laenavesse for easier communication.

EMOJI LABELS: ~$5USD
The full public collection can be found in this repository plurk. These emote labels uses an emoji or any small symbol or logo with a text box next to it, like so:


These labels are just a cute style to give a small visual along with the text to label your plurks. They can even be used for games and your own characters:


While you are welcome to request a public one for free in the current emote request plurk, larger batches will require a tip through my Ko-Fi. For specialized emotes, minimum is $5USD up to 5 emotes. After 5, pricing may increase depending on how many.

Please provide an emoji or logo I can use to make things easier! A color scheme is also preferred. These are the sites I use: emojipedia, flaticon, freepik, iconify, google.


CUSTOM LABELS: ~$5USD
First I want a put disclaimer that I'm not a pixel artist by any means, so my skills are limited! But if you want something simple I can do so.

Please bear in mind that any images may not resize well.


multidisciplinary: (Default)

[personal profile] multidisciplinary 2022-11-25 10:50 pm (UTC)(link)
Hey Lae! I've been using the notebook thread tracker since I joined Song and on some of my overly-active months ( Like September ), I have too many entries to fit in a single month page, so I have to make a second one. Would you be able to make it scrollable like you did with Eustace's? How much would you want for that?
flamekthunder: (ϟ 088)

[personal profile] flamekthunder 2022-11-25 10:54 pm (UTC)(link)
No charge it's pretty easy!

And coming back here as I realize hours later what post you're commenting on so that was a dumb question bdbsbsnsn point still stands it's an easy change so I can either guide you through or do it for you!
Edited (I dumb) 2022-11-26 12:16 (UTC)
multidisciplinary: (Default)

[personal profile] multidisciplinary 2022-11-26 08:36 pm (UTC)(link)
LOL well I think it is kinda relevant, because I think I'm gonna switch to the automated one.

I guess I'll just have to tip you later lmao
flamekthunder: (ϟ 086)

[personal profile] flamekthunder 2022-11-26 09:24 pm (UTC)(link)
Oooooooh in that case the script already has it set to auto scroll. So you'll be set πŸ‘
rippleonthewater: (Rhythm Nocturne)

[personal profile] rippleonthewater 2023-01-07 01:56 am (UTC)(link)
Hey Lae! I’ve been using this CR chart for a lot of my game characters. And I was wondering if there was a way to make it so that I can update the color bar for characters, or if new CR is added or removed, it’ll automatically group them with others of that color (like this) without having to rearrange them
Edited (Probably should’ve provided an example from the get-go) 2023-01-07 02:01 (UTC)
rippleonthewater: (Heart)

[personal profile] rippleonthewater 2023-01-07 02:27 am (UTC)(link)
Awesome! I would love to commission that then, please!
rippleonthewater: (Jeffrey Sangster)

[personal profile] rippleonthewater 2023-01-07 02:49 am (UTC)(link)
Thank you! β™₯
jedied: (Default)

[personal profile] jedied 2023-01-07 02:58 am (UTC)(link)
Oh my god? This could not have appeared on my Plurk feed at a better time. I'm gonna look at your current tracker and may commission you for something else soon.
greatairplane: (Default)

[personal profile] greatairplane 2023-01-20 11:45 pm (UTC)(link)
hello! I like your notebook tracker, is there a way to add number of comments to the automated script one for easy reference when browsing the tracker come AC time?
greatairplane: (Default)

[personal profile] greatairplane 2023-01-21 01:07 am (UTC)(link)
If you wouldn't mind formatting it for the automatted? I'd appreciate it. I'm not using it yet but I just got into a game with a rewards system and I'm going to need something to help Dave time and still be readable. Lol
greatairplane: (Default)

[personal profile] greatairplane 2023-01-21 02:09 am (UTC)(link)
That would be very helpful! Yes, please!
multidisciplinary: (🌱 026)

[personal profile] multidisciplinary 2023-03-09 02:05 am (UTC)(link)
Okay I'm finally remembering to actually commission you for the thing I want.

Would you be able to automate this CR code? Specifically with the changes I've made here. (I can provide you with color hex codes.) I'm interested in having both an "active cr" section and a "dropped cr" section. In the "dropped" section, I'm hoping that all the colors/icons can be desaturated/gray-ish.
multidisciplinary: (🌱 054)

[personal profile] multidisciplinary 2023-03-09 05:38 pm (UTC)(link)
Awesome, thank you!! (The hexes are #58b4ba, #78c76d, #DB6767, #aa5e85, and #E9C16A.)

I hadn't really thought about that, honestly, so I'll leave it up to you. Go with whichever one you think looks nicer! (Or I'll have an opinion after I see it in action lmao)
multidisciplinary: (Default)

[personal profile] multidisciplinary 2023-05-22 03:02 pm (UTC)(link)
Hi again! Do you think you can automate this one by tessisamess? It seems really complex (to me).
multidisciplinary: (Default)

[personal profile] multidisciplinary 2023-05-23 05:23 pm (UTC)(link)
Lmao yeah that makes sense. It is a lot of code and it's a pain in the ass to make changes to, but I really only do that like a couple times a year at most. I was thinking maybe automating it would make it easier to do a new one for Zelda's canon update buuut it sounds like that wouldn't actually be the case. Never mind then!
multidisciplinary: (Default)

[personal profile] multidisciplinary 2023-05-30 08:01 pm (UTC)(link)
Okay I've been thinking this over for awhile and I like your idea here. Having complex/fine tuned sheets doesn't really bother me, and I like that I'd be able to rearrange different elements based on the order of the rows and such, or add/subtract things or whatnot.

Would I also be able to create additional sheets later if I wanted to? Are there any elements you don't think you'll be able to adapt? The tiny piece of tape on the top of each image is something I'm really fond of, but I wasn't sure it could be recreated.
getratioed: (145)

[personal profile] getratioed 2024-01-23 06:05 am (UTC)(link)
I was going to change the separators and make a few other small changes including adding a couple columns to the collapsible style automated sheet, but Tools > Script Editor does not seem to exist, so I'm not sure how I'm supposed to access the code to change it.
ramuhs: (⚑ 015)

[personal profile] ramuhs 2024-01-23 06:28 am (UTC)(link)
Aah, I had forgotten to update the instructions after Google changed the menus. It's now under Extensions > Apps Script.
getratioed: (Default)

[personal profile] getratioed 2024-01-23 06:31 am (UTC)(link)
Ah. that's not working either. when I click that I get this error:
The page isn’t redirecting properly

An error occurred during a connection to script.google.com.

This problem can sometimes be caused by disabling or refusing to accept cookies.

Thanks though. I will have to try to figure out what firefox is doing that's not letting me get to that.
getratioed: (Default)

[personal profile] getratioed 2024-01-23 10:16 am (UTC)(link)
I got it all sorted! Thanks again.
ramuhs: (⚑ 285)

[personal profile] ramuhs 2024-01-23 04:31 pm (UTC)(link)
Oh good!! Glad it worked out /o/
multidisciplinary: paid commission - do not take! (🌻 082)

[personal profile] multidisciplinary 2024-05-26 05:23 pm (UTC)(link)


Hello i am here to buy one (1) cottagecore tracker updated with the escordvi points rewards tracker thingie.
flamekthunder: (ϟ 160)

[personal profile] flamekthunder 2024-05-26 05:47 pm (UTC)(link)
JEN THAT IMAGE WAS SUPER HUGE ON MY PHONE I AM CRYING LMSMJDJDJ

But yes I can work on that nsnnsnsnsnnejekkdn
multidisciplinary: (🌱 055)

[personal profile] multidisciplinary 2024-05-26 06:29 pm (UTC)(link)
I EVEN RESIZED IT TO 300PX LMFAOOOOOOO i'm glad your phone conveyed the intent of the image so perfectly

Cool excellent I shall be looking forward to it
marwood: (Default)

[personal profile] marwood 2024-05-29 02:10 pm (UTC)(link)
hello!! i've been modifying your amazing life-saving scripts for my own personal use for ages, but i was wondering if i could commission you to set up a sheets thingy for a thread tracker code i set up that's a little bit more complicated than i'm used to because of all the moving parts. i just get lost in a sea of javascript which is a language i DO NOT SPEAK, and get scared and backflip out of there lol

BASICALLY if possible, i would like for it to have the same functionality as your cottagecore thread tracker but with this code i put together:



i don't need to be able to change the fonts/colours/etc, but if possible could i have a part on the spreadsheet where i can put in different image links to change the background pic on each year box?

in terms of the variables, if possible i would like for the years to be in the order of current/most recent year at the top (with the details set to open, and also the permanent ac link only needs to be on the current/most recent year) and then descending from there (e.g. 2024, 2023, 2022, etc., with earlier years' details closed), but then the months running chronologically within each year (e.g. jan, feb, march, in that order), with all their details set to open. i hope this makes sense and sorry in advance for this novel 😭
marwood: (Default)

[personal profile] marwood 2024-05-31 12:17 am (UTC)(link)
no rush whatsoever, i appreciate it so much!! and yes it's just the threads, no points :^)
1yric: (πŸŽ€ 059)

[personal profile] 1yric 2025-01-24 11:04 pm (UTC)(link)
hello! i was wondering if your code automization commissions are open? if so, i wanna check with you/explain my vision and see if it's something you'd be willing to do.

i've been using this code by 10billionghosts to rework my muselist (seen here). i'm specifically using the two-column variant with the portrait turned into a hidden link with its border radius changed from 50% to 15% to better match the other code on the page. i'm envisioning one column being for canon characters, one for ocs, with changeable border colors.

let me know what you think, and what your price would be! thanks in advance!!
1yric: (πŸŽ€ 048)

[personal profile] 1yric 2025-01-25 06:24 am (UTC)(link)
sounds right to me! i think i like the idea of the two sheets more, just to keep things super organized. i don't think i'd play around too much with individual background colors, but if it isn't too much trouble to add that in then there's room for me to change my mind later lmao.

the only other thing i'd like to add to the row is journal url, since i altered the portrait/icon to be clickable.

thank you again!!