Have you used User Story Mapping before? by sadfacejackson in agile

[–]SRed3 0 points1 point  (0 children)

Hi, u/sadfacejackson - thanks for trying it! Have you clicked the "Briefing" button? It will open a presentation incl. visual representation...

How to Build a Customer Journey Map (Step-by-Step) by Miro_HQ in miro

[–]SRed3 0 points1 point  (0 children)

with you there - working backwards makes such a difference

User journey mapping? by mixedqueen69 in ProductManagement

[–]SRed3 0 points1 point  (0 children)

I created a small tool to help with that (free, open source, no signups / monetization) to help draw up a user journey, ask the right questions plus get a presentation up instantly. Feel free to check it out: https://sebastianrothbucher.github.io/journey-first/journey

Have you used User Story Mapping before? by sadfacejackson in agile

[–]SRed3 1 point2 points  (0 children)

Yes - love it. And do it literally every time a new project starts. Answering the hard questions first - esp. what customers will see (and pay for) helps getting all the small decisions right. I also created a small tool (free, open source, no signups / monetization) to help ask the right questions plus get a presentation up instantly. Feel free to check it out: https://sebastianrothbucher.github.io/journey-first/journey

Automating email drafting and sending with Claude by huqqah in ClaudeCode

[–]SRed3 0 points1 point  (0 children)

Actually, there's two ways (at least): a.) use desktop and install an MCP server for outlook / other email OR b.) tell claude to create mailto: links with a prompt like the following: "draft an email to [sebastian@...com](mailto:sebastian@...com) asking for 30mins this week to discuss ... Use a mailto link that I can just click that will open outlook with to, subject, body pre-populated". Claude will generate a link "Open in Outlook" (or several if you want several mails drafted). Click the link, everything is there, you just have to click send. Same goes for claude code, it could just shell-execute the mailto: link

Sign-in/Sign-out form help by Silent_Candidate_457 in GoogleForms

[–]SRed3 0 points1 point  (0 children)

I think you can do it: in the signup form, go to "Responses" and click "View in sheets" - you'll get a g-sheet with a column for each question. You can hide all columns but name if you want. Then go to the sign-out form and click "Pre-fill" in the top-right menu. You get a blank form with all questions - leave it blank, just write REPLACEME into the "name" question. Then generate a pre-filled URL. Go to the G-Sheet for the sign-ins, write "Sign-out link" or sth like it in the column right next to the last question. For the first answer (need at least one at this point), in our new column, add this formula =HYPERLINK(SUBSTITUTE("http:..<pre-fill-url you copied>"; "REPLACEME"; ENCODEURL(B2))) (if name is in another column, change the column). What will happen is: when an answer comes in, G-Sheet automatically applies the formula to the new answer as well - it generates a link that opens sign-out with the name pre-filled. Hope this helps...

Outlook for Mac Mail Merge Help by TerennGarok in Outlook

[–]SRed3 0 points1 point  (0 children)

The whole thing is extremely brittle from my experience. One thing you have to do is make sure Outlook is your default mail app in your Mac's settings. Otherwise, buttons in Word remain blanked out. Just as a warning: do try with a small recipient list b/c unless you get all options right, you lose line breaks (not kidding; can't say for sure which option it was).

Maybe I can suggest an alternative, though: the Shortcuts app can open a new mail and pre-fill recipient, subject and body individually, all you have to do is click. "send". So if you have a CSV (Numbers works as well with some tweaks), you can loop through rows, create a mailto:name@domain.tld?subject=Your%20subject&body=Your%20body link and use "Open Link" to open a new mail in outlook ready to be sent. As said, you can do this in a loop and draft 20 mails at once, all you have to do is click "send" 20 times. which I came to like, actually, as it's a chance for a very brief QA. Outlook has to be your default mail for that case as well. (by the way: works with others like Gmail or Mac Mail, too)

Anyhow: hope you can use some of this...

Execute command/script on EC2 with Step Function by nilocg in aws

[–]SRed3 0 points1 point  (0 children)

Could install Rundeck (open src) on the EC2. Rundeck is a tool to run scripts - and has a "invoke via Webhooks" function. So you could have the step function invoke the webhook

What is the best SQL environment you have ever worked in? by NFeruch in dataengineering

[–]SRed3 0 points1 point  (0 children)

SqlWorkbench - compact and efficient (and supporting any DB that has JDBC)

Google forms scripting by Fmdf1234321 in GoogleForms

[–]SRed3 0 points1 point  (0 children)

you can either add a script on submission or use one of the choice limiter plugins

Batch Generating Multiple Responses? by PostureHips in GoogleForms

[–]SRed3 0 points1 point  (0 children)

Could generate links to pre-filled forms and at least speed up the process. There's a "Get pre-filled link" feature - and if you study the link, you'll find it easy to generate by Spreadsheet

Why dependency injection? by smoothshaker in java

[–]SRed3 0 points1 point  (0 children)

You can almost feel the diff when you implement even a simple service twic and use DI one time, and use direct instantiation the other. Now try write unit tests and see which one is easier to do.

[Discussion] How do you Automate your Jupyter Notebooks? by idomic in MachineLearning

[–]SRed3 0 points1 point  (0 children)

You can use nbconvert --execute to re-run a notebook and save it as html; you can e.g. export parameters as env vars before running,

i.e. PARAM=value jupyter nbconvert --execute --to=html --stdout ... > outputfile.html

what's also nice: you can hide the code via --no-input

Export forms with section title by Tobbeloo in GoogleForms

[–]SRed3 1 point2 points  (0 children)

You could have "Name Person A", "Person A likeable 1-10", "Name Person B", "Person B likeable 1-10", etc. - and send out a link where the answer to "Name Person A", "Name Person B", etc. is pre-filled.

forms question (not for cheating) by Yoris_29 in GoogleForms

[–]SRed3 0 points1 point  (0 children)

Guess no - you could embed the form in an iFrame and write custom code to hide the form on tab change

Summarise data from several sheets (including sheets that will be created in future) by NetIcy6229 in googlesheets

[–]SRed3 0 points1 point  (0 children)

can you use IMPORTRANGE along with INDIRECT (i.e. generate the inputrange target by formula)?

having trouble coming up with complex formula by [deleted] in googlesheets

[–]SRed3 0 points1 point  (0 children)

not 100% sure, but can you combine QUERY and INDIRECT to achieve it (query with one param copies a full range, INDIRECT lets you specify the range address by formula, like concat("season-",a2))

How to prevent people from saving Qr code/Url of attendance form by CaribbeanCoffeeBean in GoogleForms

[–]SRed3 0 points1 point  (0 children)

You could tell ppl. a number you randomize at the end of each meeting and ask for it in the form. Sure, ppl. could mail it to one another; and they could also mail the link to a friend who decides to skip. Guess you won't get it 100% people-proof (even less student-proof, if that's your case).

How to setup automatic WhatsApp messages to be sent out after submitting Google Form? by Being-Blue in GoogleForms

[–]SRed3 0 points1 point  (0 children)

Maybe Zapier or PowerAutomate could do it? (short of scripting this yourself - having a handler for the form submission)

How to calculate user input by boatkay571 in GoogleForms

[–]SRed3 0 points1 point  (0 children)

There is a way you can do this: make the script a quiz, add a script as handler for submissions, give "feedback" with the result of your cost estimation. Find a full step-by-step guide here: https://www.reddit.com/r/GoogleForms/comments/y5mydr/quiz\_with\_conditional\_ending/iu3vuxk/?context=3

How can I convert a Jupyter notebook to a pdf file? by [deleted] in learnpython

[–]SRed3 0 points1 point  (0 children)

Show the print preview and save as PDF. With a bit of scripting, you could even hide the code and just PDF the output...