How do I schedule my queries to run every hour or day?

[minijohn]

Thanks for the follow up @Kiersten, very eager to have a play with it.

For anyone stumbling on the problem of "Periodically running JS Queries", my workaround is creating a blank DB query with a period interval and adding the JS query as a success trigger to that query.

[anadkat]

Hi @Kiersten ! Would love to participate in the early access for scheduled queries. Let me know I can get involved

[Kiersten]

Just followed up in our email thread!

[betterplace_sg]

Hi Kiersten! Same here. Would you be so kind to involve us as well?

[szabon]

@Kiersten We would love to be early access as well! This would really amp up our capabilities!

[ben.courts]

@Kiersten can you provide me with early access to this feature? Thanks!

[jmc]

@Kiersten I am also interested! Thanks.

[eduardogarza]

Hi @Kiersten
I also would love to participate in the early access for scheduled queries. Let me know I can get involved

[maxbaluev]

Hi @Kiersten I would like to participate in early access!

[Kiersten]

Hi there, community! For anyone who is following this thread, we have been hard at work testing this functionality with a closed group of customers. We're excited to keep partnering with you all in future iterations!

While our current group of testers is at capacity, we will be creating a more formal standby list as the offering develops and enters its next stages of adoption. If you would like to join our waitlist, whether you're interested in participating in our next phase of testing or want to be sure you hear when this product is generally available, please fill out this form. If you have already expressed interest in this thread, you will be automatically added to our standby list. Again, thank you all for your continued engagement!

[Kowshik_Bokka]

@Kiersten

fast approaching our early access program for this feature.

While I believe I reached out to everyone who has commented until now, if you're interested in participating (or even just chatting with our engineers and seeing a demo), feel free to message me here or reach out via email at kiersten@retool.com. Tha

Hello Kiersten,

Is this feature available or can I signup for it?

[victoria]

Hi @Kowshik_Bokka!

While our current group of testers is at capacity, we will be creating a more formal standby list as the offering develops and enters its next stages of adoption.

If you would like to join our waitlist, whether you're interested in participating in our next phase of testing or want to be sure you hear when this product is generally available, please fill out this form!

https://retool.typeform.com/to/lyky5R1b?typeform-source=community.retool.com

[ScottR]

@justin @victoria - is this feature still available for postgres sql queries? I don't see it under advanced tab - running cloud instance.... thanks!

[victoria]

Hey @ScottR - this feature is actually still behind a waitlist and hasn't fully launched to Cloud yet!

[ScottR]

@victoria - thanks for letting me know... appreciate it. - hopefully it's soon

[ricardoguerreiro]

hey! I too was looking for scheduled triggers and until resolved by retool, this is doing it for me. the JS script does the calculation to know how many milliseconds will be in between now and the trigger date/time, that way it doesn´t have to test every second or minute. you can input as many requests as you would like...the only limitation is not refreshing or closing the browser where it was configured until the scheduled triggers run.

var attributes = {"webshopId": textInput1.value}
var endpoint = select1.value

function nightPull() {
  Internal_API_Request.trigger({additionalScope: {endpoint: endpoint, request_body:  								{"data":		{"attributes": attributes}} }});
}
var timePull = new Date(dateTime1.formattedValue).getTime(),
    timeNow = new Date().getTime(),
    offsetMillis = timePull - timeNow;
		setTimeout(nightPull, offsetMillis);

[sctdan]

Any update on when this might be GA? This is the only thing preventing my org from using this service, though we're also not sure what to make of this feature being in beta for 2+ years. Technical challenges? Low priority?

[sctdan]

edit; nevermind, i see that's for scheduling a trigger, not an actual refresh cycle

Thanks

[awilly]

Hello! Checking in on the status of this. We have a commercial app we'd love to replace with a Retool solution, but it has at least one unattended process.

[victoria]

Hey @awilly! Thanks for asking

Public beta launch for Workflows is coming very soon. If you're interested sooner, we do have a waitlist in the meantime.

Let me know if you have any questions!