on 05-27-2014 9:35 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It turned out to be an issue with the add-on directly. FMS is working as designed elsewhere in the system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It turns out it was an issue with the add-on, not the FMS. Thanks for all the responses.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.