How to change format in SmartList.

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Folks,

I have to change format of Social Security Number in SmartList but didn't find any way to do this. Please help me. Moreover we have only SmartList Designer not SmartList Builder.

Thanks & Regards,

Amir Reza.

K.S.A

*This post is locked for comments

All responses (3)

Answers (1)

Suggested answer

coquisalsa 2,725 on at

Like (0)

Report

RE: How to change format in SmartList.

You can also try:

A SmartList calculated field

SmartList Export Solutions

SmartList Designer to Refreshable Excel Reports in Dynamics GP 2015

Thanks

Jorge
Community Member Microsoft Employee on at

Like (0)

Report

RE: How to change format in SmartList.

Thanks Jorge,

Someone suggested me above solution. Could you suggest me any other way. Actually I want to modify existing view. as you mentioned above there are few other ways plz let me know other ways. Thanks so much for your kind support.

Thanks ,

Amir Reza.

K.S.A
Verified answer

coquisalsa 2,725 on at

Like (1)

Report
RE: How to change format in SmartList.

There are few ways to do this, here there is one way to meet your requirement:

Create a SQL view and using SQL build a column with the formatted Social Security Number

Link the above SQL view to the SmartList

Expose the new column in your SmartList

Thanks

Jorge