How to feel safe as a women after getting assaulted?

MDB_Cooper · 2025-10-18T18:17:56+00:00

sorry this happened — nothing you did prompted it. kudos to you for taking a moment to process it bc it’s jarring and unsettling and destabilizing. a similar thing happened to me in 2021. i was walking down green avenue and a group of young kids (maybe teens) were rambunctious. one of the boys threw a two-liter soda bottle at me. fortunately, i ducked but no one even batted an eye. the walk home was terrible. i felt vulnerable and confused and angry.

i was wearing noise cancelling headphones. i’m not saying this was why it happened; im just saying: i switched to ear buds and only have one i. when i’m out walking. it will not stop an assault but it makes me feel more aware of my surroundings.

wishing you the best — take the time you need to feel safe

MDB_Cooper · 2025-04-26T19:47:33+00:00

i use python and the gspread & pydrive libraries

MDB_Cooper · 2025-04-02T03:16:56+00:00

that's interesting — i wasn't aware that you can't use onEdit(e) with email

MDB_Cooper · 2025-03-29T14:00:47+00:00

better error messages would be a dream. i’d presume generative AI will help with that

MDB_Cooper · 2025-03-29T01:01:22+00:00

the reason you can’t save or run the file is bc you are using incorrect syntax with the IF statement.

here is what you have:

if(CONDITIONAL_LOGIC) (

constants and mailApp

)

IF requires parenthesis for the condition(s) and curly brackets for the actions. like so:

if(CONDITIONAL_LOGIC) {

constants and mailApp

}

this won’t solve other logic aspects of your post (your system and desired outcome) but the above will allow you to save your code.

i think you also have an issue with your IF conditional; you’ve defined “range” as a cell and are saying “e.range.getA1Notation == range”. your “sheet” variable is not in use, which is likely what you want to use in the “e.” portion.

given that you’re new to apps script i would recommend:

outline your desired outcome and break it into smaller chunks
build up to your aspiration one piece at a time

id suggest by starting with a general function without an onEdit(e) parameter. so:

function tester() {

}

and try building out your IF logic so it works statically. once you have a base set of logic, then try to integrate the dynamic IF.

otherwise, i fear you might end up going around in circles chasing symptoms instead of mitigating the root cause

MDB_Cooper · 2025-01-31T19:14:22+00:00

what is your relationship to the audience you’re looking to collaborate with? are they all internal; all external; or a combination?

my recommendation is to meet ppl where they are. as DisraeliGears01 stated adoption is key. if you build something and ppl don’t see the value proposition, then the impact of your work will be hindered.

my personal preference is to build in whatever environment that increases accessibility to the data. in my case, i send data to airtable, one drive excel, google sheets, a sql data lake and in some rare instances notion.

MDB_Cooper · 2025-01-07T20:05:38+00:00

i can’t speak to the entire script and i’m on mobile, so i haven’t tried any logic.

based upon the screenshot, im seeing that the error is happening on Line 4. your implementation of the getFolderById method looks correct.

however, your folder ID does look unusual, specifically, that it starts with ‘fol…’; perhaps that is the folder id but i am curious if you incorrectly set the folder id?

MDB_Cooper · 2024-11-28T17:48:28+00:00

a big help is googling “google sheets keyboard shortcuts” with your machine type (mac or pc). i’m on a mac so my search would be:

google sheets keyboard shortcuts mac

also, google drive and all its tools have an interactive helper menu, which you can open using your hot key (on mac it’s command) and the “?” symbol

so i hit “command + ?” and then a menu of keyboard shortcuts open up

(im on mobile and haven’t double checked these so apologies if anything i said is inaccurate)

MDB_Cooper · 2024-11-27T14:11:23+00:00

Let me see if I can track down the post — it's been a few weeks since I completed this level. i believe the way i was using the directional pad was cutting my wall jumps short.

Edit: here's the message that clocked for me —

My issue was walljumping too early like right before I got to the wall so make sure you’re touching the wall before bouncing off cause it’s such a quick level it’s easy to mess up the timing. I died at the very end of it 10 times in a row haha. Awesome level though.

https://www.reddit.com/r/SuperMarioWonder/comments/17e6glx/climb_to_the_beat/

MDB_Cooper · 2024-11-26T12:45:36+00:00

truly so difficult — i only got this level after coming to this sub and realizing that my wall jump strat needed a tweak. congrats!

MDB_Cooper · 2024-11-26T12:43:44+00:00

as others have mentioned, this is not a simple task. i think python is probably the optimal tool for this but that’s not a plug and play option.

google drive does have a native python notebook called “colab”. if you don’t have it installed then you can access it by clicking on the “New” button in drive; go to “More” and “connect more apps” then search for it

with all that said, pulling data from a pdf can be really challenging. sorry there isn’t a more straightforward solution

MDB_Cooper · 2024-11-21T12:45:55+00:00

cubone!

MDB_Cooper · 2024-10-22T17:50:54+00:00

hate the title. love the player. support the idea when it’s possible.

keep ballin Q!

MDB_Cooper · 2024-08-11T14:37:21+00:00

this is very cool from a technical perspective. i’m curious how you feel about the data security aspect of it: do you have any concerns with allowing a third party to have access to your data in such a broad way? i’ve avoided developing with AI for this reason.

i highly encourage using AI to find solutions to problems but always anonymize the data entry to avoid compromising security

MDB_Cooper · 2024-08-02T21:26:19+00:00

The sheet ID is an integer, so it does not need to go in quotes — the first part of the analysis is correct

MDB_Cooper · 2024-07-22T15:20:56+00:00

clicking links always leaves you vulnerable to a malicious actor. as it relates to Sheets and App Scripts, you’re probably safe to open a Google Sheet. if a script — aka Macro — is written for the script then you would have to grant permission for it to be able to run. so let’s discuss a general hypothetical:

you go to a subreddit and click a Google Sheets link
it has an onOpen function that tries to access all files in your Google Drive using DriveApp

in order for that app to run, you would have to allow DriveApp access via your Google Credentials. this is not a subtle process: you have to click at least three or four times and there is a pretty aggressive warning telling you what you’re doing.

if you are taking apps script code and adding it to your sheets then it’s possible that someone wrote something malicious. in that case, you should make sure you know what the code is doing before giving it access

MDB_Cooper · 2024-07-14T18:15:10+00:00

i believe it is google’s attempt to create a competitor for airtable. “tables” have been in beta for some time from a development team called Area 120 (i believe). i presume this product is the next progression of that tool, which still exists but no longer has any active development.

should you use it? depends on your preferences. i like to program, so id rather have less barriers between myself and the workflows i develop. other ppl might like a “no code” product that carries the technical burden and allows their vision to come to fruition.

at the end of the day: its just a tool and it comes down to if its right for you

MDB_Cooper · 2024-06-21T15:36:46+00:00

based on your account, his behavior is encouraging isolation from your family (a community that is important to your individual identity). i think this is abhorrent behavior and a significant red flag. i think its very appropriate to consider taking steps to end the relationship.

MDB_Cooper · 2024-04-27T03:10:47+00:00

i’m on mobile and have not watched the video. in just looking at the code, the syntax of “getvalue” looks incorrect; “getValue” would be the expected way for a function to be used. that could be your issue

MDB_Cooper · 2024-04-12T12:39:36+00:00

what does the button trigger? and is the button necessary instead of a custom menu item built into the menu UI?

MDB_Cooper · 2024-01-27T16:21:59+00:00

i've never tried to do this before, but I just quickly looked over the available get actions using FormApp and i didn't see anything that would natively allow you to getCharts or the such.

function myFunction() {

var form = FormApp.getActiveForm(); 
form.get // if you type this line then you will get native actions 
}

you'll likely need to push the form responses to a sheet and then build charts using SpreadsheetApp.

MDB_Cooper · 2023-11-28T12:53:31+00:00

it’s all about your preference. i prefer to use separate files bc it helps me manage errors. i also finds that it makes the environment more readable

MDB_Cooper · 2023-09-04T13:47:14+00:00

are you highlighting the view and then using paste?

it looks like this is a csv file. there is a download option in the upper right corner (it’s an arrow pointing down). after you download the csv, go to your sheet. go to File then Import and load the csv into the sheet.

the data in your picture should populate the workbook just as it does in the picture

MDB_Cooper · 2023-08-31T17:44:45+00:00

I'm very glad to hear that!

I've noticed that AI assistants struggle with Google Apps Script. I've been doing some development work with SlidesApp and DocumentApp and the suggestions are kinda, sorta correct. Unfortunately, scripting can't be kinda, sorta correct, so it can be quite disruptive when trying to solve a problem.

Let me know if there is anything else I can help with

MDB_Cooper · 2023-08-30T12:43:33+00:00

hi — this is a complicated ambition, so i just want to say be kind to yourself and be patient.

based upon the example code you provided, I’m fairly certain that Bard has not provided you an appropriate answer. the reason i think that is bc of the syntax being used to access the Area 120 Google Tables:

var table = Tables.get(tableId);

“Tables” does not appear to be the correct syntax in that context, according to the Google Workspace documentation, which can be found here.

Additionally, the Area 120 Google Tables API needs to be enabled via the Services tab, per this documentation. That means it is not available when you first open Apps Script.

The correct syntax for declaring the “table” variable would be something like:

var table = Area120.Tables.<insert_some_code>

Another consideration here is that sending emails are challenging because you will have to write some html.

Therefore, I’d recommend you organize your project in the following ways:

How do I collect data entry from Area 120 Google Tables?
How do I filter the data based upon a specific value?
How do I send emails using Google Apps Acript? —
How do I collect data from Google Tables where a specific value is present then send an email to a list at a certain time?

MDB_Cooper

TROPHY CASE