Filter results by weekend in timestamp

[jboder2]

Hi, I need to filter results of a report to only those reservations placed on a saturday or sunday. i use a timestamp field which can be formatted the long way for the days. is there a script that can filter our all other days and only show orders containing "Saturday" or "Sunday"?

[CoopperBackpack]

Hello @jboder2,

Basically, we can use a View to filter records https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-filter-data/

In this example, we need only those records where the date in Timestamp is "Saturday" or "Sunday".

My idea is to retrieve the day of the week to use it for filtering records. 

Weekday is not supported in the Formula field:

Therefore, we can use Triggered Actions or Tasks to populate the field with the day of the week. 

1) I added the week_day field to the table (data type is Integer) and created this Trigger:

2) If you need to update this field for existing records, then you may use a Task. Because Trigger works on Insert and will populate the field for the newly created records. 

3) In the View, Criteria should be the following:

In SQL, for the days of the week, 1 stands for Sunday, 7 - for Saturday.

4) Report can be built using this View as a data source.

Hope this solution works for you.

[cheonsa]

Hello!

In addition to the previous comment, here are the helpful articles regarding Triggered Actions and Tasks.

https://howto.caspio.com/tables-and-views/triggered-actions/

https://howto.caspio.com/tasks/