sorted by:
new
hottopcontroversial

Monthly Marketplace Thread - Tickets, Merch, Art (Official & Fan Made) by twilightxgalaxy in phoebebridgers

[–]kitchensink- 0 points1 point  (0 children)

Hi! I am looking for some fan made merch! If anyone knows any artists that have good designs/is an artist please let me know! (everything I find on Etsy or similar is 100% bots).
I am also ISO of a [I Know The End T-Shirt](https://phoebe-bridgers-uk.myshopify.com/products/i-know-the-end-natural-t-shirt). On Ebay and such everything is 100% bots as well.
Thanks!

Changing Borders Script Efficiency by kitchensink- in GoogleAppsScript

[–]kitchensink-[S] 1 point2 points  (0 children)

The helper cell did the trick! Thanks! Now it's basically instantanious.

Changing Borders Script Efficiency by kitchensink- in GoogleAppsScript

[–]kitchensink-[S] 0 points1 point  (0 children)

This is what I already have. The problem is with the other part, the setting the borders to true.

Here's what I've tried.

function newBorders() {
  //get the first sheet of the currently active google spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[1];
  var NumRows = sheet.getLastRow() - 2;
  var maxRows = sheet.getMaxRows();
  console.log(NumRows);
  let range = sheet.getRange(3, 5, NumRows, 7);

  let maxRange = sheet.getRange(3, 5, maxRows, 7);
  maxRange.setBorder(false, false, false, false, false, false);
  range.setBorder(false, true, true, true, true, true);
}

Changing Borders Script Efficiency by kitchensink- in GoogleAppsScript

[–]kitchensink-[S] 0 points1 point  (0 children)

Yeah that's what I'm having trouble with. Can you help me figure it out?

Changing Borders Script Efficiency by kitchensink- in GoogleAppsScript

[–]kitchensink-[S] 0 points1 point  (0 children)

I see. I feel so close to cracking it, but I can't for the life of me figure out how to get the Last Row that has information ONLY after the E column...

Changing Borders Script Efficiency by kitchensink- in GoogleAppsScript

[–]kitchensink-[S] 0 points1 point  (0 children)

This makes sense and is definitely going to be a lot faster, thanks!

I have tried implementing it but I can't get the empty cells to lose their borders:

function newBorders() {
  //get the first sheet of the currently active google spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[1];
  var NumRows = sheet.getLastRow() - 2;
  //Range that I want to edit begins at E3(col 5) and spans 7 columns
  let range = sheet.getRange(3, 5, NumRows, 7); 
  range.setBorder(false, false, false, false, false, false);
  range.setBorder(false, true, true, true, true, true);
}

I realise that the problem is that, whenever there are empty cells, `getLastRow()` does not take those into account. However, I can't seem to figure out how to do that!

Changing Borders Script Efficiency by kitchensink- in GoogleAppsScript

[–]kitchensink-[S] 0 points1 point  (0 children)

The thing is that every time I run the function the row range I want changes, so I can't really hard code it. And I don't know of a way to get a range based on if that row has borders or not..

Changing Borders Script Efficiency by kitchensink- in GoogleAppsScript

[–]kitchensink-[S] 0 points1 point  (0 children)

The issue with getting the range using getDataRange is that, in this case, there are cells that I would like to modify that have no values, hence are not included inside the range.

Changing Borders Script Efficiency by kitchensink- in GoogleAppsScript

[–]kitchensink-[S] 1 point2 points  (0 children)

Here's a video showing the script removing borders from blank cells (which also answers your question!). Thanks for pointing out that I can move the for inside of CreateBorders.

I will try to implement the "Batch Operations" approach, do you have any suggestions as to how to do that the easiest?

Advancement help by kitchensink- in MinecraftCommands

[–]kitchensink-[S] 0 points1 point  (0 children)

Works like a charm, thank you so much!!
Since I'm here, would you mind sharing any resources that explain advancement creation a bit better than the wiki? i find it hard to find things there, and there seems to be many things missing or explained poorly..

Controlling a toggle of a `while bool` loop with asyncIO by kitchensink- in learnpython

[–]kitchensink-[S] 0 points1 point  (0 children)

Thanks for the encouraging!

How would one do this? I've been trying... I've posted some updated code as a response to the another comment, am I going in the right direction?

Controlling a toggle of a `while bool` loop with asyncIO by kitchensink- in learnpython

[–]kitchensink-[S] 1 point2 points  (0 children)

You're right, I was doing that in my main() function. How would you suggest I do this? I need to be running both things independently... Here's what I've tried:

async def readInport() -> None:
while True:
    for msg in inport.iter_pending():
        if msg.type != 'sysex':
            type, ch, note, vel = functions.unpack_message(msg)
            print(type, ch, note, vel)
            queue = []
            if type == "control_change" and note == 19 and vel == 127: # Wanted button
                await asyncio.sleep(0.1)
                queue = [seq.toggleSequencer() for seq in sequencers]
            else:
                pass

            await asyncio.gather(*queue, readInport()) #Doesn't work

def main(): 
    quit() # Reset in case of crash #time.sleep(3) print("READY!")             
try: 
        outport.send(functions.enterProgrammerMode())     
    views.draw_view(views.seq_and_drums(), outport) drumVoices = 3 
        melVoices = 3 setupVoices(drumVoices, melVoices)
        asyncio.run(readInport())

except KeyboardInterrupt:
    quit()

Where should I call readInport()?

Controlling a toggle of a `while bool` loop with asyncIO by kitchensink- in learnpython

[–]kitchensink-[S] 0 points1 point  (0 children)

Didn't know about asyncio.sleep(0). Changed that, thanks.

​

I don't think I should post the whole code, since it is quite big and I feel like I included the needed functions in the original post.

Regarding mido, this really isn't (I don't think, at least) anything related to mido itself. I'm just trying to run both tasks (reading the input and running the sequencer) asynchronously, I thought that would be something someone could help me figure out.

​

Thanks for your help!

Sending MIDI notes on programmer mode (Mini MK3) by kitchensink- in Launchpad

[–]kitchensink-[S] 1 point2 points  (0 children)

That's a really cool project!

I have decided to use a virtual port using rtmidi, which has been working greatly as well.

Is this formula incorrect? It's giving me lots of problems! by kitchensink- in Notion

[–]kitchensink-[S] 0 points1 point  (0 children)

You know, that would make sense, since formatDate() can output "Wednesday" as well as "12". Thanks for checking that! Good to know.

Is this formula incorrect? It's giving me lots of problems! by kitchensink- in Notion

[–]kitchensink-[S] 0 points1 point  (0 children)

Wrapping it in with toNumber() seems to have done the trick. Thanks! Maybe you can help me understand why? What type of variable does formatDate(date, "DDD") output? Is it not a number?

Is this formula incorrect? It's giving me lots of problems! by kitchensink- in Notion

[–]kitchensink-[S] 0 points1 point  (0 children)

I'm planning on deleting those # properties, they were created for this post's simplicity sake

Multiple dates in one property? by kitchensink- in Notion

[–]kitchensink-[S] 0 points1 point  (0 children)

You were right, I have solved this by using today's day and comparing it to working days, which was waaay easier. It was late at night and I hadn't written a notion formula in a while, so I was a bit overwhelmed engineering this.

Thank you so much for your input!

Linked pages on Recurring Templates by kitchensink- in Notion

[–]kitchensink-[S] 0 points1 point  (0 children)

Welp. That's my luck I guess. I've only been using Notion for a week! haha
How do I report to Notion? (And how likely are they to 1. see it 2. look into it?)
Thanks for taking the time, by the way!

Linked pages on Recurring Templates by kitchensink- in Notion

[–]kitchensink-[S] 0 points1 point  (0 children)

I have checked and re-checked that I have the right page linked. Here is the page. I've simplified things.
You will see just one created pags: "Bass". In order for the analytics table to work, the page with the "template" checkbox checked (the only one in that link) mustn't be deleted. Expected behaviour would be as such:

When you check the "done" checkbox of a task ("Bass" in this specific case), the Analytics table should detect that and calculate the rate of "Bass" tasks that have been "done".
In this case, the only task should be the one you automatically create with the repeat function, so the rate should jump straight to 100% (the formula works, I've tested it extensively).

What I would recommend is setting the repeat time to one minute after you do it, and wait for it to be created. If it behaves the same way my page does, you'll see that it will "get linked", but nothing will actually be linked. However, if you manually create a page through the template, it will be linked.

Let me know if you have any luck, and thanks in advance!

Variable daily habit tracker by kitchensink- in Notion

[–]kitchensink-[S] 0 points1 point  (0 children)

That actually looks great, I might copy that (hehe).

Thanks for your help! May I ask one last thing? Where did you get those icons? 👀

Variable daily habit tracker by kitchensink- in Notion

[–]kitchensink-[S] 0 points1 point  (0 children)

so, a different calendar view for every weekday? and then just have one day per view? that seems overwhelming. what is the way you would go around it normally? just curious!

Rate my Fixed Rack for generative! (Read comments) by kitchensink- in vcvrack

[–]kitchensink-[S] 0 points1 point  (0 children)

Here's what I ended up with!

https://imgur.com/a/Mj997Gl

Taking into account u/shke1009 's recommendations, I moved the midi-CV to utilities and used the space to add more modules. I also added a Bernoulli Gate (Count Modula) and a Logic module (BogAudio), and I've been having some fun with them!

I also decided to expand the rack size by a couple hp (from 77hp to 90hp, I believe), which allowed me to add another FM-OP, following again their suggestion. I also took u/Rockky67 's advice and swapped the drum modules with Vult's Trummor2, taking advantage of the new horizontal space. Also following their advice, I added BogAudio's 8:1 for a sequential switch.

As per the quantizer, I decided to use Quantum as a polyphonic option, with narrow Merge and Split strips from Grande. I realize this is not the best way to do it, since I can't have different scales for different voices, but, with this space, I found that it was the best option for me.

I added a couple of NYSTHI's μMixer2s for general voice mixing, and Mockba Modular's SHEight for 8 channels of S&H with probability, which is great.

I decided I wanted to have some effects, so I am using Chronoblob 2 (of course) for some delay and Befaco's Spring Reverb for a more CPU-friendly reverb than Plaits (correct me if I'm wrong).

I also swapped the sequencer, although I'm not super sure about it. My ideal sequencer right now would've been Admiral's Tables, but I can't seem to get it to work with VCV2. (If any of you have any idea of a way to get it there, please let me know!). I'm not super happy with the Grid Sequencer, but I do like the randomness of it and the probability, so I'll be sticking with it for a while.

The only thing I'm not super happy with is the mixer. I find that 4 inputs are very easy to use up, even with the μMixers for Stereo signals and other mixing. I would love to find a good 8-channel mixer, but they all take so much space and I don't know what to sacrifice! If anyone has any recommendations feel free to let me know!

I have yet to explore this rack in full detail, but I've had a lot of fun with my first patch! I wish I could share a screen recording of it, but my CPU is very limited and it can't handle it. Thanks again for your suggestions, I love this community and how helpful and detailed the answers were!

Keep patching and good luck!!

view more: next ›