What is Reddit's opinion of Google Apps Script?

This is insanely useful:

https://script.google.com/macros/s/AKfycbyVSaJC5L7Tj4aTouH0Tc-cflQHzrUdgoVjUjn0A9xQVH99tG0/exec

Input which abilities you want, and it will give you a list of all possible combinations of gear and how many sea snails it will probably take until you get 3x the same ability.

> Predicted amount raised (based on past hour): $6,152,608.55

https://script.google.com/macros/s/AKfycbzbixsVFtLZMQ2pVVaQc_jT0w-vNBw5GI7zsiQ9gnakMRHJ1A/exec

And now the huge storm is probably over, they don't even have proper stretch goals anymore;)

According to this chart: https://script.google.com/macros/s/AKfycbzbixsVFtLZMQ2pVVaQc_jT0w-vNBw5GI7zsiQ9gnakMRHJ1A/exec
we're slowing down. We were 130k away from 6m projected. Now it's closer to 200k.

6m is close, but potential. And we get extra missions for all pledgers! That alone is worth the push! Lets get us there!

edit: I really want the extra missions so put my money where my mouth is. Added a Hornet to my hanger.

edit 2: with the US waking up, the projection is just over 6m now. We've got a real chance!

Well there is your issue. Marksman trigger costs a lot in repairs and has a horrible spread. That trigger was nerfed a long time ago (used to be OP) and is better suited for the Soviet SMG's now because they have horrible spread to begin with.

This calculator may be a bit outdated in exact cost amounts but is still good as a guide to help with knowing where your credits are sinking.

I did figure it out from your reddit post which was only a little more than two weeks ago.

Also going this useful utility AaronIceGem's stainless pot has only been renamed 16 days ago, shortly after your reddit post, so it is not unlikely he two figured out it was because of the post.

It's a sort of shout out for when any of us have sex. There's actually a page where you can "ring the gong".

What exactly are you talking about? Space whales don't compete within their bracket, they compete across brackets in Ratsound's tracker. Top 5 is nothing, the top 10 on the tracker are all sub 13 seconds.

https://script.google.com/macros/s/AKfycbw57wuNnMFqTQkIWsdlc5lila-Le5ObPEfJHJIT21ohmWNSvxk/exec

u/StroupBSlayen had a Cost Calculator that pulls from Sandman's cost sheet. You are correct though that most of these values are outdated and haven't been tested in a long time on modifications so they should be used as guide rather than fact.

ReDemoN's tool hasn't been updated in a very long time either so it doesn't include things after Everhart build like the M2 carbine damage nerf but I think a lot of its info is still fairly reliable.

Modification doesn't mean upgrade. You can click the modification and see its effect on a weapon. Use this site to compare weapon modifications (as, with H&G, you can only see what 1 mod does at a time)

https://script.google.com/macros/s/AKfycbwF7UGqPbT8Ad_PscA2IftxJRh2hDu7Za8tkJ9y2vr7ckZhFsG0/exec

ALSO TO NOTE: the person stopped updating that website a month ago, so don't expect perfectly accurate results if Reto changes anything, but it's still valid IMO.

Dude. My best games are with starter rifles. Even stock. A scoped M1G/G43/SVT40 is amazing but scopes are expensive to buy and repair (but not as expensive as grenades). You can't beat the versatility of those semi-autos; perfect accuracy at whatever range, really good hipfire.

A friend of mine wrote a handy item ID to time lookup using a database of gifted items, employee badges and whatnot. I use it a lot because I'm a hardcore collector and investigator.

Step 1. Go to IFTTT.com
Step 2. Sign up
Step 3. create a recipe
Step 4. For 'this' choose an RSS feed
Step 5. Choose New feed item
Step 6. Feed URL =
https://script.google.com/macros/s/AKfycbxR5a4BxAw6R1zjN_cSZk--j5zF1MKVhYuLEq4kfmrGuf9Q9jM/exec?510557723780345858

Step 7. For 'that' choose twitter
Step 8. choose "post a tweet"
step 9. delete whats in the twitter box and put "RT {{EntryContent}}" without quotes
step 10 activate your twitter account at some point
step 11 DELETE the recipe title and make your own, as it ends up being too long and you have to redo it all
step 12 Join the twitter wars

These are the highest damage builds you can do, but the types of players that sit +250m away just getting their lulz in from the mountains will often adjust for precision since any round at that distance has its damage reduced and will require 2 hits anyways. For more information regarding the effective distances for weapons, you can use ReDemoN's old weapon tool

Thank you for the call to direct action here. I sincerely appreciate the clarity on how to turn my feeling of discomfort about the situation into something I can do today to begin improving it.

If you also want to contribute to this project, here are some links:

Here is a link to the Shooting Guide for the photography.

Here is a link to the place to submit your photos.

This sounds fun! I look forward to the next time I see my friend who knows about photography to do this together. :)

/u/doctors_like_cash

Here is a Google Scripts file that implements some pretty basic functionality to get you started. It would be pretty trivial to add more columns, such as: Previous Week's Spending, Amount Remaining, etc. Most of the code is actually used for converting a js object to a HTML table. I lifted that part from someone else's project, because I'm lazy and it's easier than hardcoding the table details.

Screenshot: https://i.imgur.com/nocIDV4.png
Gist: https://gist.github.com/ConnorGriffin/bbae5d2a99a58aca847f413dd2540b73

Copy the code from the .gs file to a new Google Apps Script project and fill in the parameters at the top of the script (API key, budget name, categories to monitor, and email recipients). Select 'sendYnabReport' as the function, and then click the run arrow. If it works, you can set it on a weekly timer using the clock icon. If you are sending the email to your own Gmail, it will mark it as unread and move it to the inbox.

This may be something that I look into setting up as an actual service on AWS instead of having people host their own code. I've been looking for a project like this, but always assumed other people would do it faster, better, and more securely, so never bothered.

According to this tool, you get 5 sand dollars ~50% of the time every exceptional slot.

So the average SD per golem is (Golem Level - 4)*2.5.

/u/poopdrip and /u/Cozichacozee

I've got a couple things that might be useful.

Here's a spreadsheet that just imports data from Sandmans and added a calculator to the front page for weapons. I also added some misc tank data to it because I could :P The downside is you have to add the file to your google account to use it.

I also recently made an HTML calculator. It's very simple and I'm sure there are some bugs because I've only been learning HTML/Javascript for like a 2 weeks. If there are any bugs feel free to PM me and I'll see what I can do :)

If you did go to the Resources section on this subreddit, you would have seen Sand Man's Cost Sheet or ReDemoN's HnG Tools which both contain the information you were looking for. ;)

This is exactly the right solution. It works like this:

Google docs provides a feature, where you can publish a Google spreadsheet as a web app.
This gives you a special URL, with an embedded secret token: https://script.google.com/macros/s/SCRIPT_ID/
Each time you call this URL with a get request, Google adds the parameters for this request as a new line to the spreadsheet: https://script.google.com/macros/s/SCRIPT_ID/exec?time=1464325345&power=1234
Everyone guessing the token can add her own lines to the sheet. So keep the token secret or add some kind of signature as a separate column.

you can also take a look over here for possible sets (and chances of getting them): https://script.google.com/macros/s/AKfycbyVSaJC5L7Tj4aTouH0Tc-cflQHzrUdgoVjUjn0A9xQVH99tG0/exec

OR here: http://leanny.github.io/splatools.html

which is a great tool developed by a german community member, gosh this makes looking up things so much easier...

This is the problem with to do lists, they take too much upkeep and don't really help you prioritize. It helped me a lot to put to dos in a spreadsheet and let it calculate priority based on their urgency and how important it was to me.

Do you use Google calendar? If so try this.. It gives you a spreadsheet to put your tasks in like this. Then it adds things to your calendar in the empty spots in your schedule based on priority. It helps you figure out what you need to do every day.

I made it and I use it all the time! It helps me juggle full time work and school. It even freed up enough time that I go out once a week now.

If people just want to check what the current pledge amount is I suggest using this app to take some load off their site. It updates every minute.

Tritium does tend to be the bottleneck - in Colonia there's no bulk Tritium selling stations, only FCs selling Tritium at 120k/T+ a pop.

Best Tritium mining spot I've found near Colonia is Eol Prou RA-P c6-5, first ringed giant. Tight overlap there, but it's a push to get beyond 230-250T an hour Cutter mining unmapped. No NPCs there so you can ditch the weapons.

Whilst you're out in the black, you can use the Tritium Pathway Network to top up.

https://script.google.com/macros/s/AKfycbx6cEi2RRVZum98jZinXqzyK74RrHPVF71Qlmg8HEE1Z6e-4FLw/exec

Because of the scarce supply of Tritium in Colonia, I found it was better time/value to go back to the bubble, mine the meta (platinum) to fund tritium in bulk, and go from there.

But if you're not in a rush & not in need of the credits you can do both, just watch out for space madness from all that slooow Tritium mining.

I recommend joining the Fleet Carrier owners discord. They've got this awesome tool that they've built that works as a database for Tritium hotspots that are 2x and higher.

Tritium Hotspots Tool

Any further dev is always appreciated :) I'll be the first to admit I'm not a web-dev by any stretch of imagination - my daily drivers are assembly, c/c++, and android/ios lol. A far cry from javascript.

If we were to take this to the next level, it'd be nice (for the people that need it), to auto import into a pre-selected spreadsheet.

I've been working on a script using script.google.com to run this on a weekly basis, but I've been so busy at work I haven't gotten a chance to work on it in a while.

Anyways, nice job man

Ok, so I kind of went a little nuts with this. I added a tab called from script. I created a script that generates a list of the data in the format you want it. I added a menu item in the script drop down that appends the list to the tab I added.

Here is the code

OK, you need a couple of changes here to set the triggers and change the email collection dates. This will set the trigger for every 5 minutes , I've tried to account for running at minutes under 5 past the hour too.

var MARK_AS_READ_AFTER_MINUTES = 5; var LABEL_TO_MARK="inbox"; function Intialize() { return; }

function Install() { ScriptApp.newTrigger("markMails") .timeBased() .everyMinutes(MARK_AS_READ_AFTER_MINUTES) .create(); } function Uninstall() { https://script.google.com/macros/d/MBqrNPSzGjwZ_-vuH7kZCsXuAQ7im4wST/gwt/clear.cache.gif var triggers = ScriptApp.getProjectTriggers(); for (var i=0; i<triggers.length; i++) { ScriptApp.deleteTrigger(triggers[i]); } }

function markMails() { var age = new Date(); if (age.getMinutes() <= 4){ age.setMinutes(59 - 4 + MARK_AS_READ_AFTER_MINUTES) } else { age.setMinutes(age.getMinutes() - MARK_AS_READ_AFTER_MINUTES); }

edit: changed the code for minutes 0 - 4 instead of 0-5

Use this link here to update your information. Enter your username, update the # you want to lose. And do the same thing for your checkin weight by selecting "starting weight" and entering it.

That's what I recommend too. I wrote this script if anyone wants to use it, just replace the column numbers etc.

Yes, the idea is that I use Google only as a temporary measure and in the meantime as an off-site backup. Most of the files that I've uploaded from my computer are encrypted, however, I do have a lot of files on other Drive that I'll copy using this godsend script. The problem is, I don't see a way to encrypt those file without downloading those file first and then reuploading them (~500 GB).

As for the nsfw and copyrighted stuffs I only plan to free my HDD spaces because I've got a project upcoming and didn't had the budget to get another HDD.

According to what JP players said, it's 100 Crit stats = 1% crit chance. Using math means that 3000 crit = 30% crit chance. Buffs are always percentages between +10% to +50% on attack and/or critical.

I recommend checking out ratsounds' Damage Calculator

Here is the code I used for sending the emails.

MailApp is the class that you use to send the emails.

I think so. Haven't Sniped in a while since i found tanking alot more rewarding.

I use this to estimate cost for mods and weapons but i dont know if its accurate https://script.google.com/macros/s/AKfycbyWXD6zyxh9Gh2kotQsdPWzbNPx2s57L58pEkdvoVWDmD6M5OU3/exec

0.89 credits per shot stock

7.71 credits per shot with just scope (and stock ammo)

10.05 credits per shot with scope, trigger,

12.63 credits per shot with scope, trigger, spring

Source: HnG Weapon Cost Calculator

It's hard to say which costs more to use; a modded M1/M2, or a OHK bolt action (~50 credits per shot for fully modded inf M1903, ~70 credits per shot for fully modded recon M1903

So, you'll want to add

matchupsToSend += "This week's matchups: \n";

to the line right below

matchupsToSend = '';

Here is an example of a file that has it done already!

Having only gold probably isn't enough for Reto to make money. I think the veteran membership is very fair. $20 for three months sounds like a very good deal to me (and I can have heavy set on all my gimmick characters).

Bullet refills are actually the cheapest of all the mod repairs. As you can see here https://script.google.com/macros/s/AKfycbwF7UGqPbT8Ad_PscA2IftxJRh2hDu7Za8tkJ9y2vr7ckZhFsG0/exec?page=WeaponsComparison

I didn't find this thread until I'd already seen DiRaven's script and ran with it. Thought I'd share my take as well, since we ended up coming to some of the same conclusions on how to enhance the script. Plus, your instructions are way better. I added a few other options too, like removing videos from the playlist after a number of days, setting min and max durations for videos to be included, ignoring live stream announcements, etc. If it helps anyone else, great.

Script: https://script.google.com/d/1BXqO_0u_eX_qqPMt9g6RHnBTieczdnnH2bFdjEvOvO5cPStalQoDtY85/edit?usp=sharing

My writeup: http://www.benjaminworrel.com/2016/04/automatically-adding-videos-to-a-youtube-playlist/

The air in Salt Lake is not at 1 right now, the Salt Lake monitor is down. We've got a red day going on.

https://script.google.com/macros/s/AKfycbwzxhzw9IXNugu-A0lpcos7meQnBm9YEuVPxyPO21Q8ow6xlp0/exec

When does your semester start? I'm putting the finishing touches on my app

To use it you put your semester's assignments and due dates into a spreadsheet. The app checks your calendar and plans out when you should work on the assignment based on due date and percentage.

Every day your google tasks gets updated with what you need to do. And if you don't mark it finished it reschedules it, but it warns you if you reschedule too many times.

I remembered this old link from a time ago. It may not be up to date. If it's not, hopefully someone can link to a new tool.

https://script.google.com/macros/s/AKfycbyVSaJC5L7Tj4aTouH0Tc-cflQHzrUdgoVjUjn0A9xQVH99tG0/exec

You input all the abilities you want, and it'll find you the gear that best fits your desires.

Do note that Ninja Squid and Opening Gambit are not possible for sub abilities. If you want them, you have to get them as a main ability.

Do you use Gmail and Gcal? If so I have an app that's even better. Here

Its an app which allows you to batch add tasks to google cal from a spread sheet in Google drive. Soon it will automatically schedule them when you are free and reschedule them if you don't mark them done.

In two weeks I'll push out features where it sends you a daily to do email, and sends emails to people who you designate for certain tasks so they can keep you on track if you put it off too much.

I'm adding integrations to RescueTime and IFTT so you can basically get Rescuetime to start blocking Reddit if you're supposed to be studying. Or at least figure out what you were wasting time on instead.

I wanted something like this as well. I ended up creating a Google Script to modify a calendar to do this.

https://script.google.com/d/1v8WbLSO15Z26ioiI0AvZJxCi6o38YqQ-8DclxP7TxO0UgCcBC2OW6cbG/edit?usp=sharing

I use a separate calendar for it, easier to hide/show IMO. Then any item that has a $ in it will add/subtract from a running total. I set it to trigger every 5 minutes, if it finds a change to the calendar it wipes out all the running totals (only shows a total on days that change it) and recreates them.

This way I manage it on a calendar and 5 minutes later I can see the consequences 6 months out.

I came here hoping for an explanation of how it worked, so I'm linking the code with description if that's okay with you. (Let me know if we need to edit this out to avoid vandalism etc.)

As far as I can tell, the current version counts solutions that have at least 10% of the words from the idea description each appearing for at least 1% of the solution summary, where both of these figures are subject to further tweaking.

In practice, all the solution summaries seem to be well under 100 words, and the idea descriptions are typically around 10-20, so a solution summary containing only one or two words from the idea description would count. I think this means that anything containing "with" would count as a match for idea 1, "Block AK with patronus charm"? Leaving out small/common words, maybe by checking each word against a blacklist, would be an easy improvement.

Alright, so what this person (this guy who made the script) is trying to do is, for a lack of better words, hacky. What I mean by that, is there are many different ways to go about this, and this is an odd way of doing things. That good news is it seems to work fine (with my version, and from what I tested).

The script was throwing an error, so I added a try/catch and it seemed to have fixed it. In order for it to work (the original way), you need to import the required APIs, and the site that this came from doesn't mention that.

So, I've published the script here. Now, all you need to do is go there, select the account you want to authorize, and that's it. If you have multiple accounts (like me), make sure you select an account with an email or the correct email.

If you want to have it automated and not have to add the APIs in manually, something else might need to be arranged, so let me know what you think/how it works out.

I mean, I code every day at work, so there's that, but I have little hobby projects I do in my own time, too.

One is video/GPS processing software that I use to annotate sailing videos (like this one).

One is a google-docs based web app that automatically tracks my commute times.

There are plenty of places you can keep yourself busy writing software of various types.

Hello, I'd like you to upload me the files from the folder C:\Windows\minidump here: https://script.google.com/macros/s/AKfycbzHWA65cJ_0d7lhJ0xXHnKeLBMZZ7-K4zlIh98rrNy26fb12-Xj/exec

Make them into .rar if you want me to debug more of them.

Thank you.

this link is a great tool for figuring out deck improvements.
Personally I think two nightmares is perfect for an attack deck but that Camuila should hold you over for a while. DNP is a cool card but way costly. You might try for a trow since they've dropped in price a lot and make a great 19k atk boost for the last slot. I would suggest NM (replace Chimera), Trow (replace Luci), NM (replace Cam) as your next three attack additions. That's three boosts from NM, NM, Inu and two high atk wings. Then maybe a DNP to replace the Inu. For defense your plan is sound.

Pretty cool looking and definitely not intended behaviour lol. First time this bug happened for me was on my main island. Damage testing on a dummy when the world turned monochrome.

This bug has been reported in the past, but if you'd like to report it officially use this link: https://script.google.com/macros/s/AKfycbyKbpUzz_3nSN1uX6N_urTZFOWumd5UsRhKbBtYRJClMudCoyE/exec?lang=en
The developer does not check this reddit, and thus won't know about any new or reoccurring issues. The link is to a form created by a fellow moderator and community manager, and will send a copy to the discord as well as the devs themselves. This video will help greatly if you send the .mp4 with the report. (All files are uploaded at form submission.)

lol probably because of my website page name. i didnt have a domain nam efor my webpage so, its look something like this,..

wait, i can comment link text as a string right? just without the https part

https://

script.google.com/macros/s/AKfycby4e5YpDMcjOUAYEZC-r40yedUbjiHd3yAGyHuAiucMM7a0LQ4K/exec

let me see if its work

For some reason Reddit keeps auto-removing my original response to you, maybe from too many links, so I'm trying again with fewer links:

Triggers are managed by Google, so you can view all the triggers running for your account here: https://script.google.com/home/triggers

However, I think it's pretty hard to tell what's what in that view. Therefore, I think a more practical way is to open your Google Drive and click Recent, that way you'll see a list of all your sheets that have recently updated.

One other thing to keep in mind is that Google is aggregating usage across all your scripts and add-ons, as well as certain functions like GOOGLEFINANCE, so it could be affected even if you're not running that many updates via API Connector. If that's the case you could consider running your requests under a different gmail account (I could transfer your account for you to see if that helps).

Finally, we've covered most of it here, but you can see a list of tips for dealing with trigger issues in the docs (check the section in the Scheduling article called "Troubleshooting Triggers").

Figured it out if anyone is wondering:

<? currentChains.forEach(function(chain) { ?> <a class="button" href="https://script.google.com/macros/s/abcd1234567890/exec?ssid=abcd1234567890&name=RecentActivities&chainName=<?= chain[0] ?>">Change Chain</a> <? }) ?>

I believe what you are looking at is only applied to those sheet functions. For your needs, use Script Triggers. Go to

https://script.google.com/home/all

Then click on the 3 dots on the right side of the ImportJSON script that is tied to your sheet > Select Triggers > Add a Trigger. And then play around with the time or event based settings.

Because I like both causing chaos and watching it happen:

https://script.google.com/d/13WTNrQd8hp3-UfAdG_yC49O4Eorp0imMTCC7aWqktunrB_Cc76lf0hUl/edit?usp=drivesdk

Copy and use as you see fit

Also, be sure to join the Cult of Billy discord server:

https://discord.gg/EuHF5ZkT

Take a look at the data for Lc0, for yourself.

*Please note that the graphs may take a little time to load, scroll down to get things going if they don't do so within reason.

That's weird, it should be accessible...Did you add everything here between the quotes, no spaces: "M1lugvAXKKtUxn_vdAG9JZleS6DrsjUUV"

Do you have full ownership of the spreadsheet and Google Apps Script page?

Can you access the library here: https://script.google.com/d/1Mc8BthYthXx6CoIz90-JiSzSafVnT6U3t0z_W3hLTAX5ek4w0G_EIrNw/edit?usp=drive_web

I don't think there are any mapped ones. I don't think you can get a very good mining ship in the starter systems anyway. Try this tool (it's a Google script I found over at r/EliteMiners)

I would not go down the publish as an add-on route. A script associated with a worksheet is essentially just a Google project contained in the sheet it is associated with. You can go to script.Google.com and create a project, put the code in it and then either use the google drive api or as TobofCob suggest parameterize it and pass in the name (or object IDs).

So when the link is declared like line = 'https://script.google.com/macros/s/"private GAS id"/exec?Person="User3"&TimeS="00:45"' it still doesn't work?

I don't get your answer here really, but I have a headache and am currently not capable of answering questions. I'll come back later if I remeber, sry :/

TriPN is the Tritium Pathway Network and is a tool to help CMDRs find Tritium overlaps anywhere in the galaxy. it can be found at <https://script.google.com/macros/s/AKfycbx6cEi2RRVZum98jZinXqzyK74RrHPVF71Qlmg8HEE1Z6e-4FLw/exec>

I found links in your comment that were not hyperlinked:

script.google.com

I did the honors for you.

^delete ^| ^information ^| ^<3

Creating shortcuts in Google Drive means that you are just linking to the same file you received. You are still reusing the link.

To get around that, you can simply make a copy to your own drive. For single files, just right click then choose Make a Copy. For folders, you just have to use the Copy Folder tool created by Google itself so it's less hassle (I don't understand why they don't just make this a built-in feature).

Anyway, these are the easiest ways to import the files to your Google Drive and make sure you're not reusing links. Hope that helps!

So how about this post on the front page in there, which points you to this tool, which unfortunately google docs seems to have an outage or something, but how about look through their spreadsheet.

This is a useful tool to check what each weapon mod does and shows how fast you will kill someone, repair cost etc. It might be outdated in many areas but it is still somewhat indicative of the final result. https://script.google.com/macros/s/AKfycbxTRwZ-5OfIeW8Tcef9wPyVB8rYHe7biWCEIcJe6g/exec?page=WeaponsComparison

Hello Everyone,

This is Simple Black a modern hybrid watch face, with a beautiful design that brings an elegant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbzKAelmvGeatpMVBbs0WwPuSYfE9zijrR0nrjp55w/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 50 coupons/country. This is because of the new Samsung policy!

This watch face is not available in China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Simple Black a modern hybrid watch face, with a beautiful design that brings an elegant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbzKAelmvGeatpMVBbs0WwPuSYfE9zijrR0nrjp55w/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 50 coupons/country. This is because of the new Samsung policy!

This watch face is not available in China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Simple Black a modern hybrid watch face, with a beautiful design that brings an elegant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbzKAelmvGeatpMVBbs0WwPuSYfE9zijrR0nrjp55w/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 50 coupons/country. This is because of the new Samsung policy!

This watch face is not available in China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Split a modern hybrid watch face, with a beautiful design that brings a vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbxZzQtquTnMxiW-eG1uDWVAcWFsIOZxyh_VmhzGa_GZKyKs0VNf/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 50 coupons/country. This is because of the new Samsung policy!

This watch face is not available in China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Split a modern hybrid watch face, with a beautiful design that brings a vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbxZzQtquTnMxiW-eG1uDWVAcWFsIOZxyh_VmhzGa_GZKyKs0VNf/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 50 coupons/country. This is because of the new Samsung policy!

This watch face is not available in China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Split a modern hybrid watch face, with a beautiful design that brings a vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbxZzQtquTnMxiW-eG1uDWVAcWFsIOZxyh_VmhzGa_GZKyKs0VNf/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 50 coupons/country. This is because of the new Samsung policy!

This watch face is not available in China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Split a modern hybrid watch face, with a beautiful design that brings a vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbxZzQtquTnMxiW-eG1uDWVAcWFsIOZxyh_VmhzGa_GZKyKs0VNf/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 50 coupons/country. This is because of the new Samsung policy!

This watch face is not available in China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Midnight Business a modern hybrid watch face, with a beautiful design that brings an elegant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbyF4qDx23sj5Y0v9-Hyb5sKnHGFEem58ykU8aerNAEE79ttpivl/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 50 coupons/country. This is because of the new Samsung policy!

This watch face is not available on China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Midnight Business a modern hybrid watch face, with a beautiful design that brings an elegant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbyF4qDx23sj5Y0v9-Hyb5sKnHGFEem58ykU8aerNAEE79ttpivl/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 50 coupons/country. This is because of the new Samsung policy!

This watch face is not available on China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Sure:

curl --location --request POST '[WebhookSubscriptions_URL]' \
--header 'Authorization: Bearer [Token_ID]' \
--header 'Accept: application/json' \
--header 'Content-Type: application/x-www-form-urlencoded' \
--data-urlencode 'object=obj_name' \
--data-urlencode 'fields=field1, field2' \
--data-urlencode 'callback_url=https://script.google.com/macros/s/\[ID\]/exec'

Hello Everyone,

This is Regarder Classic II a modern hybrid watch face, with a beautiful design that brings an vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbzVxrtPLPZ2drjUR6iF6d8lU8lyM9wvD1TM4Srj/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 35 coupons/country. This is because of the new Samsung policy!

This watch face is not available on China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Regarder Classic II a modern hybrid watch face, with a beautiful design that brings an vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbzVxrtPLPZ2drjUR6iF6d8lU8lyM9wvD1TM4Srj/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 35 coupons/country. This is because of the new Samsung policy!

This watch face is not available on China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Regarder Classic II a modern hybrid watch face, with a beautiful design that brings an vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbzVxrtPLPZ2drjUR6iF6d8lU8lyM9wvD1TM4Srj/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 35 coupons/country. This is because of the new Samsung policy!

This watch face is not available on China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Regarder Simplicity a modern hybrid watch face, with a beautiful design that brings an vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbzg0E0eW3jFOgMnyxzJ4j_KGnQkml3ALcXM6P0bEg/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 35 coupons/country. This is because of the new Samsung policy!

This watch face is not available on China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Regarder Simplicity a modern hybrid watch face, with a beautiful design that brings an vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbzg0E0eW3jFOgMnyxzJ4j_KGnQkml3ALcXM6P0bEg/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 35 coupons/country. This is because of the new Samsung policy!

This watch face is not available on China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

Hello Everyone,

This is Regarder Simplicity a modern hybrid watch face, with a beautiful design that brings an vibrant touch to your smartwatch.

Free Coupon Generator:

https://script.google.com/macros/s/AKfycbzg0E0eW3jFOgMnyxzJ4j_KGnQkml3ALcXM6P0bEg/exec

(you will be able to get to Galaxy Store directly from the coupon generator tool)

There are only 35 coupons/country. This is because of the new Samsung policy!

This watch face is not available on China, Romania & Germany (technical issues)

IF YOU LIKE MY WORK, PLEASE SUPPORT ME BY PURCHASING THIS WATCH FACE AND GIVING A RATING & REVIEW IN GALAXY STORE.

THIS WILL HELP ME ON CREATING MORE COOL WATCH FACES.

You might be right. I created a script to calculate FTAs in my runs last week:

Total Hunts: 669

1 FTA in a row: 61, actual %: 9.12, expected %: 11.00
2 FTA in a row: 9, actual %: 1.35, expected %: 1.21
3 FTA in a row: 1, actual %: 0.15, expected %: 0.13
4 FTA in a row: 1, actual %: 0.15, expected %: 0.01
5 FTA in a row: 0, actual %: 0.00, expected %: 0.00

Ok, found the code:

const API_KEY = 'yourKey'; const SCRIPT_PROP = PropertiesService.getScriptProperties(); const WORKBOOK = ''; const SHEET = '';

// https://script.google.com/macros/s/ scriptID /exec?key=yourKey function doGet(e) { if (!isAuthorized(e)) { return ContentService .createTextOutput(JSON.stringify({ "result": "error", "error": e })) .setMimeType(ContentService.MimeType.JSON); } else { return handleResponse(e); } }

function doPost(e) { if (!isAuthorized(e)) { return ContentService .createTextOutput(JSON.stringify({ "result": "doPost error", "error": e })) .setMimeType(ContentService.MimeType.JSON); } else { return handleResponse(e); } }

function isAuthorized(e) { return e.parameter['key'] && e.parameter['key'] === API_KEY; }

You could use a Google Script. Put your spreadsheet data all into one column and create a script to read the next line number every 15 mins and send a webhook to IFTTT to switch on or off. That way you have total flexibility as you can easily edit the spreadsheet to change the timing if needed.

> However not everyone is in the bubble.

I'm afraid you misunderstand the purpose of miner's tool, then. The data in it comes from scouting effort in the bubble.

There's also a section around Colonia but it's not finished and there is only one mention of Tritium so far.

Tritium (or any other) hotspots outside populated areas were never in the scope of the tool.

And I see you've already been told about the TriPN.

Ugh, that sounds horrible.

My script should work for that, just set the Gmail filter to match the email address before sending it to IFTTT to use the Google Calendar QuickAdd Action. I've just had a bunch of work dropped in my lap, so I don't have time to make a cleaned up version right now but my messy script is here if you want to try it yourself. Follow the instructions by /u/Godberd first to allow googlescripts/ifttt to work first.

For references here's the API I used to find the class/methods I needed for my changes: https://developers.google.com/apps-script/reference/gmail Good luck!

Go to script.google.com and create and publish an API Executable. This would help you track how much you are uploading down the to GB

function doGet(){

return HtmlService.createHtmlOutput(DriveApp.getStorageUsed()/(1024*1024*1024));

}

You can see what the methods return in the docs:

https://developers.google.com/apps-script/reference/drive/drive-app#getfolderbyidid

Can you try to run this function:

function testDriveApp() { const docFile = DriveApp.getFileById("1tZcY7ACKsstJ2_xXDMQeHXNa91YhH3jK31ND8wCJtgI"); Logger.log(docFile); }

And paste the logs here? You can get the logs from the script editor directly or from the Apps Script Dashboard here:

https://script.google.com/home

in "My Executions".

- small planets tend to be the most interesting, with more extreme topography

- if you land at geo/bio sites, don't forget to use composition scanner for the codex entry. It's a useful database even if often forgotten

- if you wanna get places fast, get 1kly above/below the galactic plane and plot route with non-sequence stars and jet cone boost enabled

- running something that syncs with EDSM is good, I use EDDiscovery

- if you happen to scan a ring with good tritium hotspot overlap, submit it to TripN

- the Distant Worlds 2 expedition had some choice waypoints, including SagA*

- These days you don't need to cry over a lost SRV if you wanna drive it like a madman somewhere or base jump it... there are many carriers where you're going, and the DSSA I believe is all deployed in core sectors

> This way anyone could find a really good and viable hotspot, and possibly share it with others if they want.

That is exactly what was happening prior to Patch 3. Lots of people hunting for overlaps and posting to TriPN when found.

https://script.google.com/macros/s/AKfycbyEjAUPtNzDoJfVFyl3YrOrOS8-ZUHToMhb5vL1oe_1/dev?p=2

> in the deep space it's unlikely people can find such hotspots

A lot of players are spending a lot of time doing just that. See this map as a reference. Green is all the Tri2s so far found: https://script.google.com/macros/s/AKfycbyEjAUPtNzDoJfVFyl3YrOrOS8-ZUHToMhb5vL1oe_1/dev?p=2

Check the Tritium Pathway Network:

Submit this entry please!

https://script.google.com/macros/s/AKfycbx6cEi2RRVZum98jZinXqzyK74RrHPVF71Qlmg8HEE1Z6e-4FLw/exec

> i can Saw in iftt web that the parámeters are correct, texto=led , number=2

Where are you seeing that? The URL string that IFTTT sends to the Google Script handles the device name and the time, you don't need to put it in anywhere.

The URL you put into the IFTTT web request should look something like this (The **** represent your script key):

https://script.google.com/macros/s/*********/exec?mode=onf&unit=mins&device={{TextField}}&time={{NumberField}}

You'd see the device name and time in the spreadsheet. The Script will send the info back to IFTTT to write into the spreadsheet. That way you have a record of all events and also can check that your voice commands are being heard as you expect.

function doGet(){

return HtmlService.createHtmlOutput(DriveApp.getStorageUsed()/1e9);

}

Go to script.google.com and create and publish an API Executable. This would help you track how much you are uploading down the to GB

the Tritium pathway network has maps of double tritium overlaps people have discovered..should fill up your ship very quickly at one of those

https://script.google.com/macros/s/AKfycbx6cEi2RRVZum98jZinXqzyK74RrHPVF71Qlmg8HEE1Z6e-4FLw/exec

Sure, the voice timer script is here and the instructions on how to set it up are here. And this is what the spreadsheet monitoring looks like. There's examples in the script of building webhooks to send data to IFTTT, and of storing variables as arrays, and of setting script triggers. And the instructions describe how to configure webhooks.

I made a sunrise/sunset daily trigger script using api data as a way to learn how to parse the strings really, tho I might use it for a voice activated sunset timer sometime and I'll post that if I do it. I'm still trying out using preconditions but haven't settled on the best way to implement it. It's easy to make something custom but it would be better to make configurable to be easily used in other things. Like with the voice timer, where it's easy to 'hard-code' webhook timing commands if you need a specific time delay for any other IFTTT functions.

SmartThings code? I'll have to check that out but I like the idea of using Google Apps Script as you can make any function you want with JavaScript and don't have to use pre-configured functions or any other accounts, and as it will connect to IFTTT there's a lot of potential for making some useful and interesting tools.

I agree, as said, it'd be clearer if it was stratified better with the inputs more clearly at the top, so there are a couple of things that could be moved, but it's roughly there, flowing top to bottom. It's just a map I thought would help make it clearer about what connects to what - and how, as it might be useful when deciding the best way to achieve something. I'll tweak it some more, but don't want it to get over-complicated.

The App Scripts enable some extra intelligence to be added to IFTTT functions, like the voice set timers thing that takes the Google voice command asking for 'any device to be set on or off for any time' and processes it into IFTTT triggers. It can also pull in any sort of data from external sources and be used to trigger IFTTT, and you can use it for making simple logic switches like AND/OR gates for IFTTT triggers. It seems a good method as it runs Javascript so has lots of functionality, and it keeps all the processing inside your Google account. I'm not looking for total automation so I think for now it'll do anything I want without needing any extra hardware or software.

So App Scripts can pull in data like sunset times or weather or anything really. I'm going to have a look next week to see if I can use to pull in the Plex 'Play, Pause and Stop' commands to control lights at the same time. I'll post that if it works ok.

BTW, the diagram is made with Lucidchart, which seems fairly intuitive to use. It didn't take long to sketch out the setup. It's of my own setup but that's kinda standard for a lot of people I think, using IFTTT, a Harmony Hub and some WiFi switches (in this case Kasa). After adding in SmartThings it was getting confusing working out all the connection options so I think having a route map helps.

>//Get the row & column indexes of the edited cell
var row = e.range.getRow();
var col = e.range.getColumn();

Hi,

I tried it in the sheet and it does not hide the cells. I then got an email that said:

Your script, para script test, has recently failed to finish successfully. A summary of the failure(s) is shown below. To configure the triggers for this script, or change your setting for receiving future failure notifications, click here.

The script is used by the document script test.

TypeError: Cannot read property 'getRow' of undefined.

I have double-checked that the range is assigned properly.

The ` XFrameOptionsMode ` was already set to ALLOWALL, so yep, it's still the same behaviour..

Maybe I just didn't understand you 🙏 but it's framed as the only element of a page. I just set a CNAME record through my domain provider to direct a subdomain to the `script.google.com/macros[...]/exec` url

I've made the app public (I think), are you able to run this?

function pull() { var url = "https://script.google.com/macros/s/AKfycbxdeZftodmvbzqdNMpOUuA0-vyERH2UQ05hGfH_kXY/exec" var queryString = "?row=2&col=2"; url = url + queryString var request = UrlFetchApp.fetch(url).getContentText(); Logger.log(request); SpreadsheetApp.getUi().alert(request); }

Ok, so that gives literally just 'b' as the output of the web app, which is good I suppose.

But on the spreadsheet side I still don't know how to access 'b'. The code still returns that massive output:

function test() { var url = "https://script.google.com/macros/s/AKfycbxdeZftodmvbzqdNMpOUuA0-vyERH2UQ05hGfH_kXY/dev?row=2&col=2"; var response = UrlFetchApp.fetch(url); Browser.msgBox(response.getContentText()); }

I've made a web app that just queries a cell (by row, col) of a spreadsheet.

function doGet(e) { var sprd = SpreadsheetApp.openByUrl("url"); var dataSheet = sprd.getSheetByName("Data"); var result = dataSheet.getRange("TestRange").getCell(e.parameter["row"],e.parameter["col"]).getValue();
return HtmlService.createHtmlOutput(result); }

If I use the web app url in chrome, https://script.google.com/macros/s/AKfycbxdeZftodmvbzqdNMpOUuA0-vyERH2UQ05hGfH_kXY/dev?row=2&col=2, I can see the correct answer displayed, which is 'b'.

But I don't know how to access 'b' from a script. If I do what you suggested above:

function test() { var url = "https://script.google.com/macros/s/AKfycbxdeZftodmvbzqdNMpOUuA0-vyERH2UQ05hGfH_kXY/dev" var queryString = "?row=2&col=2"; url = url + queryString var request = UrlFetchApp.fetch(url).getContentText(); Browser.msgBox(request); }

I don't know what to do with request. It's just a whole bunch of crap.

if the back-end sheet contains sensitive data, a web app is probably best. I'm no expert, but you could probably do a urlfetch and can send data with the request, which this page has excellent info about sending data,

https://developers.google.com/apps-script/guides/web

such as...

function doGet(e) { var url = "https://script.google.com/macros/s/AKfycbzM7qMyGhxx81FiTqpNjG6Sdr4a1HmiCAVsB3Wahdk/exec" var queryString = "?infoImSending="+theInfoAsVar url = url + queryString var request = UrlFetchApp.fetch(url).getContentText(); //var request will contain the return info }

from there, to get a return string, from the webapp you could end the web app with....

return ContentService.createTextOutput(variable);

which will give the var variable back to the script that called the web app

What is Reddit's opinion of Google Apps Script?
From 3.5 billion Reddit comments

➔ Google Apps Script website

By popularity on Reddit, this Service is:

100 reviews of this app found across Reddit:

What is Reddit's opinion of Google Apps Script? From 3.5 billion Reddit comments

➔ Google Apps Script website

By popularity on Reddit, this Service is:

100 reviews of this app found across Reddit:

What is Reddit's opinion of Google Apps Script?
From 3.5 billion Reddit comments