Message Box

[Anonymous]

Hi

I have a requirement to display alert message, sometimes the data build fails which result in dashboard displaying old data , so I want a message box to display stating that the data is not latest.

The data updates every Friday , so I will have to check if the data is latest Friday, so I have created a text box with the condition in Layout tab as below :

if(Date(Floor(WeekEnd(Today()) - 9)) = max(date(Date)),0,1)

But I have a filter to select the Date values in the Dashboard which by default is set to show latest Friday date , when the user manually selects a date other than the latest date , the message box is appearing , which i want to avoid . How can i achieve this?

Thanks

[boorgura]

Please try using this:

if(Date(Floor(WeekEnd(Today()) - 9)) = max({1} date(Date)),0,1)

[sunny_talwar]

Try this:

If(WeekEnd(Today()) - 9 = Max({1}Date), 0, 1)

Update: No need to add the extra functions which don't add any value

[alexpanjhc]

there is a function called reloadtime()

Maybe you can show that as a box so people know when this is reloaded last?

[johnw]

Floor() adds value because weekend() returns a timestamp of the last millisecond of the week, which will never equal a date value.

[johnw]

Rather than a text box, you could use an actual alert. The condition can probably be the same, use "On Open" as the event, and put in the message you want displayed. You don't need the {1} then, because the only time it will check the condition is when the app is first opened.

[sunny_talwar]

That's true, thanks for catching that John

[Anonymous]

Please find the attached app .. I used same .. still my text object remains ..instead of disappearing !

TX369  - text object id

[johnw]

You might need to use <> instead of =.

[Anonymous]

This message to alert that the data is not updated , so when max date is equal to Friday's date then I don't want this message to appear , when it is not equal to then I want this message to appear as the data is not updated. Hope it makes sense