Welcome to Portal

?Unknown\pull-down

Welcome to Zoho Cares

Bienvenido a Soporte de Zoho

Search our knowledge base, ask the community or submit a request.

So, I have a form. For simplicity, lets say that this form only has a job_name field, a room_name field, and a order_number field. (the order_number field is to input a number for sorting purposes)

On the report, I have it set to group by job_name, and to sort the records within the groups by the order_number field.

It sorts the groups alphabetically by default.

I would like it to sort the groups by last opened. So for example, when I edit a room on a job that is at the bottom of the report, the rooms on that job would now appear at the top of the report.

What is the best way to accomplish this?

1 user has this question.
3 Replies
Reply
  • Zoho MVP
  • 12 days ago

You could sort by the Modified Time column if you want to know when the last change was made. If you need to know the last time each record was "Opened", regardless whether it was updated or not, you could add an "On Edit -> On Load"  workflow and fetch and update the record. Something like:
  1. //
  2. fnRecord = Form_Name[ID = input.ID];
  3. //
  4. fnRecord.Last_Opened = now;

Thanks for the reply!
So, I want the rooms within each job to sort by the order_number field. 

The rooms would all be grouped by job name.

The job/room group which I opened a room on most recently would show up on top.

So, it's not necessarily putting the most recently opened room on top, but more so the room group sorted by the order number.

  • Zoho MVP
  • 12 days ago

You have to order by the Group, you cannot group on one field and order on another.

You could look at using a formula field and have the field concatenated with the Date Time and Group Name, then group on that

Reply to Jonathan SteuryA
/* */
  • 12
  • Insert
  • Plain text
Add Comment
(Up to 20 MB )