Alert_Issue

[#1]

I have created a alert message which will display the information of data updated date

for this i use this expression:

='Data as on ' & max(date)

But the  problem is, if a user for example select 2014 and Apr and save and close the application

Next time once he/she open the app it will display the max date of previously  selected and save month & year

(i.e max date on Apr 2014 rather than Jun 2014)

Is there is any other way ,so that whenever the user open the app it will always display max date instead  of  selection inn the field

[#2]

Hi

why don't you use month(today() & year(today())

best regards

Chris

[#3]

Actually the sometimes data not updated daily most of the times  it display the data of Day-1 or Day-2

[PrashantSangle]

Hi,

Try triggers,

Go to Sheet Property->Triggers->OnActivateSheet->Add Actions->Add->Action Type(Selection)->Select in Field->Ok.

Then in Field column ->write field name.

Search Field->write field which you want to select on open.

In your case it should be max(date)

Regards,

[nagaiank]

Try the following expression:

='Data as on ' & max({1} date)

[#6]

No it will not work

Let take an example in one of my dashboard data is updated till 30-apr-2014 .But once i manually reload it, its reload time and max({1}date) will give the same output as 09-06-14

Similar in other dashboard date updated sometimes as day-1 or day 2 or on daily basis

If i use max (date) ..it will result in a problem that once as user open the app and select feb-2013 and save as close  the app ,next time when the user open that application ,it will give max date of feb month i.e 18 feb

that is wrong,it should display 09-06-14

[#7 · Accepted solution]

I resolved  the issue and the solution is

go to Document property-Trigger- Document open trigger - On open -Add Action- Max(Year) or MaxString(Year) (i.e. based on your data)

add one more trigger- clear other field and write field name  as Year

Apply same logic  for month and create a trigger for month as well

Now it will work fine