Solving delay in pipelines

Question

Is there any way to solve delay in pipeline ?
Users of our app in a particular step will create records for a trigger in pipeline and then they will have to move next part of the job, where they go to table "xyz". Table "xyz" must be now filled with records as a result of the pipeline I mentioned earlier. The users are going to work on this newly created record by pipeline. But sometimes this pipeline do not get triggered very soon after we create trigger record. This delay can lead to additional errors and confusion for users when they check the table "xyz".
Is there any way to notify users about this delay in execution of pipeline ?

------------------------------
Aswin Babu
------------------------------

evanmartinez · Answer

Hi Aswin,Pipelines make requests of Quickbase while moving around data much like a user does, and as a result there can be some delays if your app is having traffic or if the Pipelines have to run through some complex logic on their own. One trick that can be helpful is to use a code page to create a delay of a few seconds with a message to users to give Pipelines a chance to run and complete. One of our team members here at Quickbase made an article where he walked through how you can use this technique&nbsp;right here.&nbsp;It can also be handy other places you are using integrations like an API call that need time to run their logic. You can give users some feedback and set expectations to remove confusion. I hope this suggestion is helpful Aswin.------------------------------Evan MartinezCommunity Marketing ManagerQuickbase------------------------------

winss · Answer

Thank you i will check it out------------------------------Aswin Babu------------------------------

winss · Answer

Hi Evan,I tried to replicate steps on the article that you gave me. I was able to make URL field but couldn't figure out where to add javascript. I simply pasted that code into page2.html (page id = 6) which didn't work and then I tried renaming the page to page2.js this too didn't work.&nbsp;Please guide me on how to add these js piece to&nbsp; an HTML page.------------------------------Aswin Babu------------------------------

evanmartinez · Answer

Hi Aswin,Most likely what you just need to do rather than keep the pageid=6 in the example formula is to look at the page id of the html page you made and substitute your html pages page number for the example in the formula (it might be a different page number in our example because pages are numbered as they are created not by naming them). I have included a screenshot of an example where you will find the page number on your Pages table in your application settings. I hope that helps Aswin

Here is a help document on how to create code pages------------------------------Evan MartinezCommunity Marketing ManagerQuickbase------------------------------

winss · Answer

There was already an empty page already with page id =6. What I'm not able to figure out is how to use the javascript code
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;let&nbsp;urlParams&nbsp;= new&nbsp;URLSearchParams(window.location.search);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; let&nbsp;url&nbsp;=&nbsp;urlParams.get('url');&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fetch(url, {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; method: 'post',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mode: 'no-cors',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; headers:&nbsp;{ 'Content-type': 'text/plain' }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }).then((response) =&gt; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;setTimeout(function () {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;window.location.href&nbsp;=&nbsp;document.referrer} &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , 2500); // # of milliseconds to pause for, 2500 = 2.5 seconds&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; })
How should I copy this code in the page id=6 . Isnt there a format for writing javascript inside HTML ?Please guide me on this------------------------------Aswin Babu------------------------------

Forum Discussion

Solving delay in pipelines

Related Content

Three Words of Advice on Pipelines

Solved - Help with a formula

Pipeline Not Triggering

Three Words of Advice on Building Pipelines - Brittany Scheid

Solving delay in pipelines