Jump to content
  • 0

Create a field in the results page and collapsible group



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")



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,


Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0


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.


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...