Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

Formatting a view

I have 2 fields in my form that appends data.  Here is an example

when the document is created

ModAction = Created
ModDate = 07/13/2007

as the document continues more info is appended to the field

ModAction = Created, Save and Notify, Save and Notify, Approved
ModDate = 07/13/2007, 07/14/2007, 07/15/2007, 07/18/2007

Now I need a view that will seperate the values and display them.

View Header
ECR Number |        ModAction    |     ModDate

1000               Created                     07/13/2007
                       Save and Notify        07/14/2007
                       Save and Notify        07/15/2007
                       Approved                  07/18/2007

1001               Created                     07/20/2007
                       Save and Notify        07/20/2007
                       Save and Notify        07/22/2007
                       Approved                  07/26/2007

Etc.

Right now it looks like this

View  Header
ECR Number |                        ModAction                                           |                  ModDate

1000          Created, Save and Notify,Save and Notify,Approved       07/13/2007,  07/14/2007,07/15/2007
1001          Created, Save and Notify,Save and Notify,Approved       07/20/2007,  07/22/2007,07/24/2007              
                             

0
Jaziar
Asked:
Jaziar
  • 2
1 Solution
 
Bill-HansonCommented:
First, you can only display up to 9 rows this way.  If that's ok, then here's how ya do it...

There are 2 ways to store the data, so I'll describe both.

In the 1st method, you store a comma separated string in a single-value field.  Each value in the field is separeted by a comma.  From your posting, it looks like this is how you are doing it.  If you are storing the data as CSV, do this:

(1) On the view properties style tab (3rd tab).  Set "Row Height" to 9 lines and enable the "Shrink rows to content" property.
(2) For each column that displays a MOD field, set the "Multi-value separator" property to "New Line".
(3) For each column that displays a MOD field, change the formula to @Explode(FIELDNAME; ",").  Example: @Explode(ModAction; ",").

Using the 2nd method, you would append item values to a multiple-value field.  If you are storing the data as multiple values, try this:

(1) On the view properties style tab (3rd tab).  Set "Row Height" to 9 lines and enable the "Shrink rows to content" property.
(2) For each column that displays a MOD field, set the "Multi-value separator" property to "New Line".
(3) That's it.  Since the values are already separate elements in the field, we don't need to explode the values.
0
 
JaziarAuthor Commented:
Or even like this

Now I need a view that will seperate the values and display them.

View Header
ECR Number |        ModAction    |     ModDate

1000               Created                     07/13/2007
1000               Save and Notify        07/14/2007
1000               Save and Notify        07/15/2007
1000               Approved                  07/18/2007

1001               Created                     07/20/2007
1001               Save and Notify        07/20/2007
1001               Save and Notify        07/22/2007
1001               Approved                  07/26/2007
0
 
Bill-HansonCommented:
Did you get my response?  Let me know if you need more help.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now