Filter by Time

[NeoInJS]

I have report which shows that list of the trips of my drivers. Currently, I have two shifts for my drivers- Morning (7am-7pm) and Night (7pm-7am). My issue is I want to show a report where, when my night shift driver searches all his trips for a specific date, it will show me all the trips made from 7PM of the chosen day until 7AM of the next day.

I am hoping for your assistance.

[Alison]

Hi NeoInJS,

You can achieve such a search with using Record Level Security. So you need to create a field in the table, for example, Shift. And the values for this field can be DayShift and NightShift. And then on the" Search and Report Wizard - Search Type" screen, you can restrict record access based on that field.

These links can be useful:
https://howto.caspio.com/getting-started/record-level-security-stamping-new-records/
https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/restrict-access-to-data-by-user-or-role/