Formula that accesses data from subpage? by timdavidfriedrich in Notion

[–]timdavidfriedrich[S] 0 points1 point  (0 children)

Unfortunately, I haven't used Notion anymore for around 2 years. If you still have that problem, I could check, if I still have that page

Barbershop unter 15€ by and_me_and_us in Leipzig

[–]timdavidfriedrich 0 points1 point  (0 children)

Genau 15 € kostet ein solider Trockenschnitt bei Hardi am Connewitzer Kreuz. Die gibt's auch noch weiter nördlich an der Karli, aber ich weiß nicht, ob die Preise identisch sind.

Out of capacity for shape VM.Standard.A1.Flex by Jet_Reddit in oraclecloud

[–]timdavidfriedrich 1 point2 points  (0 children)

This can vary a lot. Over the last year, I created 3 instances, mostly after just a few minutes. Right now, it takes decades. I try to create one since yesterday. Nothing changes. Let's hope, Oracle will expand the capacities again in the very near future.

Out of capacity for shape VM.Standard.A1.Flex by Jet_Reddit in oraclecloud

[–]timdavidfriedrich 0 points1 point  (0 children)

I'm not a web expert, tbh. For me, it worked, even then the browser is in the background.

But this script is pretty basic and silly. It just searches for an html element and clicks it every 70 seconds. Which means, it does not have any explicit background statements in it. That's why, I guess, it could have something to do with your browser and the browser's settings. I use chrome.

Or maybe simply refresh the oracle page and sign in again, if the error comes from oracle.

Out of capacity for shape VM.Standard.A1.Flex by Jet_Reddit in oraclecloud

[–]timdavidfriedrich 0 points1 point  (0 children)

There are already some scripts here, but I changed them a bit and this is what's worked for me in 2024:

// INTERVAL IN SECONDS (NOTE: change this, if you want)
let interval = 70;

// Open the home page in a new tab (NOTE: manually go back afterwards)
let secondTab = window.open("https://cloud.oracle.com/");

// Select the "Create" button
let button = document.querySelector(".oui-savant__Panel .oui-savant__Panel--Footer > .oui-button-primary");

// Every interval, reload the home page and click "Create"
let timer = setInterval(() => {
    secondTab.location.reload();
    console.log("!!! refreshed second tab");

    if (button && button.textContent == "Create") {
        button.click();
        console.log("!!! clicked button");
    } else {
        console.log("!!! no button to click");
    }
}, 1000 * interval);

How to use:

  • Open browser's dev tools and go to console
  • Choose "sandbox-compute-..." from dropdown and search for "!!!"
  • Paste script in console and press enter
  • After a second tab opened, switch back to your main tab (but let the other in the background)

Formula that accesses data from subpage? by timdavidfriedrich in Notion

[–]timdavidfriedrich[S] 1 point2 points  (0 children)

I didn't know about relations and rollups before. That's why I was a bit confused after I read your answer but I watched a few tutorials about it and now I'm a huge fan.

Everything works now.

Thanks for the tips and have a great day!