Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
here is the general idea - I am creating a status page where I get basic statistics of prior day data load.
I am wondering if it is possible to create in QV a pop out msg that would inform user in case load was not complete ( a simple condition if prior day sum of sales is less than last 60 days avg ) that would inform user that data is incorrect?
User would have to close the window to move forward?
is it possible something like that in QV? any similar examples?
You can use Alerts and put the condition of sales<60.
have you seen any simple examples of alert function?
I got it to work. so I get the alert box.
Prior day data is missing for Source Transaction file XXXXXXX from ERP XXXXXX. We will contact IT Person XXXXXX and Business Contact XXXXXXX to resolve the problem.
I am working on text msg and how to make it work.
Hi Rafal,
Go to Tools --> Alerts or simply by ctrl+Alt+A.
You can add the condition, message as well as the Mail recipient if you want to send the alert mail.
Hope this helps..
Is this what you looking for?
= 'Prior day data is missing for Source Transaction file' & <YourExpression/Field>XXXXXXX> & 'from ERP' & <YourExpression/Field>XXXXXXX> & '.' & 'We will contact IT Person' & <YourExpression/Field>XXXXXXX> & 'and Business Contact' & <YourExpression/Field>XXXXXXX> & 'to resolve the problem.'
yes - but I cant get it to work with my object.
how do you attach QV file on here so I can show you the object and expressions ?