Create a field in the results page and collapsible group

[anibaldps]

Dear caspio members:

Is there a way to create a new field dynamically in the results page and then group the data by that field?

I created a tabular report with the following fields...

Transaction_Name Employee CustomerNumber

i wish to create a new field that clasifies the transaction name like this:

if(Transaction_Name == "Amendment")

then ("Amendment")

else( if(Transaction_Name <> "Amendment")

then("PD1")

else("None"))

With that new field created I would like to be able to group the data in the tabular report:

Transaction_Type Transaction_Name Employee CustomerNumber

Amendment Amendment Emp12 1111

Amendment Amendment Emp25 2222

Amendment Amendment Emp33 3333

PD1 Renovation Emp48 4444

PD1 New Emp15 5555

PD1 Other Emp40 6666

Any help is appreciated,

Anibal

[Aariel]

hi,

I think, the result page is to display information. You can display more information than in your table by adding HTML Block. It is not a new field in the table.

I suppose, you have to create a field in table for 'Transaction_Type' . Then you can assign the value to 'Transaction_Type' when users enter value to 'Transaction_Name'. (upon submitting the form, if Transaction_Name is .... then Transaction_Type =....)

then in report, grouping can be done by the 'Transaction_Type' field.