cancel
Showing results for 
Search instead for 
Did you mean: 

Auto Refresh for FMS not working

Former Member
0 Kudos

I have created an FMS for an existing field on an add-on to be triggered by change of an existing column, but while the column changes, the only way to get the FMS to activate is to click on the magnifying glass.  Any ideas?

Here is the FMS Query...

SELECT CAST(CAST(DATEPART(YYYY,GETDATE()) as Nvarchar(30))

+ CASE

WHEN CAST(DatePart(MM,GETDATE()) as NVARCHAR(30)) < 10

THEN '0' + CAST(DatePart(MM,GETDATE()) as NVARCHAR(30))

ELSE CAST(DatePart(MM,GETDATE()) as NVARCHAR(30))

END + CASE

WHEN CAST(DatePart(DD,GETDATE()) as NVARCHAR(30)) < 10

THEN '0' + CAST(DatePart(DD,GETDATE()) as NVARCHAR(30))

ELSE CAST(DatePart(DD,GETDATE()) as NVARCHAR(30))

END as NVARCHAR(8)) AS UpdateDate

FOR BROWSE

And attached is a screenshot of the FMS setup...

Any help is greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Donald,

Please close form after allocation of FMS.

Open form again and then check that you are getting Auto Value in Column or not.

Hope this help

--

--

Regards::::

Atul Chakraborty

Former Member
0 Kudos

Atul,

Thank you for your response.  I did that.  I even logged out and back in and the behaviour remained the same.  If you have any other thoughts or recommendations, I would greatly appreciate them.

Answers (3)

Answers (3)

Former Member
0 Kudos

It turned out to be an issue with the add-on directly.  FMS is working as designed elsewhere in the system.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Thanks for feedback.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

It turns out it was an issue with the add-on, not the FMS.  Thanks for all the responses.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please close this thread with helpful answer.

Thanks & Regards,

Nagarajan

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

The above FMS is working for me.

1. Make sure job no is changed while adding document

2. Try with another field for auto refresh.

3. Remove "For browse"  and try.

Thanks & Regards,

Nagarajan