Proces flow - open screen after set time or event

Hi all,

I have set up the report generator, which is great. I also have an upload to Azure (developed outside of SF) which updates my Db with an online path to the file in the cloud. All is good. When a client creates a pdf (e.g. an invoice) with a task.

The following happens; 

click task → insert in Table Rpt_queue → file is made. → File is pickup by magic → uploaded to Azure → File path is inserted in an extra column in the rpt_queue. 

An update trigger fires and send the file back to the source table (e.g. invoices) AND to a table 'Document Pool’. The document pool is where we collect ALL files on this account. Invoices, reports, bills, contract, etc.  Anything generated?  → boom, in the document pool. 

So, after the task has fired, we use a process flow to open this document pool in a new tab. All good. HOWEVER, due to the time it takes to generate and handle the file, the doc.pool is not updated yet. This takes on avarage 20secs. 

Is it possible to either delay to process flow with 20seconds?  (with a loading bar if possible - this way the client will think 'oh, the file is on it's way.’ → doc. pool opens with the file in it). 

OR 

Refresh the doc.pool automatically 20secs after opening it (refresh only once)

OR 

Refresh the doc.pool when an insert is done? 

Any takes on this? 

Kind regards, 

Alex  

Mark Jongeling 3 years ago

Hi Alex,

Delaying the opening of a screen is possible by having a task run an SQL function called WAITFOR DELAY inside the process flow as an Execute task. In this task you could have a 20 second timer like this:

Very basic code as follows:

declare @i int = 0
      , @i_text varchar(100)
      , @percentage int = 0

select @i_text = try_cast(@i as varchar(100))
exec tsf_send_progress 'wait_for_second', @i_text, @percentage 

while @number_of_second > @i
or @i > 61
begin
    waitfor delay '00:00:01'

    select @i = @i+1

    select @percentage = 100 / @number_of_second * @i
    select @i_text = try_cast(@i as varchar(100))
    exec tsf_send_progress 'wait_for_second', @i_text, @percentage  
end

You can of course give it a default value of 20 seonds. This way the user has to wait 20 seconds and the process flow will continue after this task ends.

 

The Software Factory also offers an Auto refresh option in the Subject screen under settings. This way the screen will refresh every X seconds, there you could set 5 seconds for example.

Refreshing the screen after the generation process is over is not possible as it is not part of the Process flow.

Hope this helps!

Kind regards,
Mark Jongeling

View original