I’ve been working on a home delivery system within SambaPOS for a cafe who takes orders a few days prior to delivery of the order. A big big thanks to @Jesse for the guidance to help me pass existing barriers.
I’m now at the stage where i’m building a custom report to allow staff to print a report of upcoming orders. I have a ticket tag called DeliveryDate that contains the date of delivery. I was hoping to be able to filter by this tag on the Report screen so staff can select the date and print out a report.
This is what i have so far for the report. Quite simple but it contains the info required.
@JimT you want to make report date filter to work with delivery date instead of ticket date. The only way to do it by creating a custom SQL Script but it will need some parsing and date conversion as we store ticket tags as JSon data format.
Alternatively I’ve demonstrated a new custom report viewer widget feature here.
Hi @emre, Are you able to show me some screenshots of both report viewer and editor widget properties and the settings of the Automation command “Display Delivery Report” from your example setup for “Passing parameters to Custom Report Viewer Widget”
However, I can’t seem to search for orders that were created on a different work period. Is this by design? I was hoping this would allow me to search for orders without being confined to a work period…
It wouldn’t be any more than the last month. @emre so that would be great!
How about the scenario where if i wanted to search for tickets that had a delivery date the following week? E.g On a Thursday they decide to see what deliveries are in the system for a date that happens to be on the following week.“This Week” wouldn’t work for those right?