Filter a Table with a Date Calendar + Hour and Minute Dropdown
I would like to filter a table with a date calendar and an hour/minute dropdown multibox.
1. I have created a variable, vStartDate, to hold the selected values
=Timestamp(Date+MakeTime(Hours,Minute))
2. In the variable event triggers, I have added an On-Change trigger with the following information to filter the table with the selected date and time
Actions : Select in Field
Field : deldate
Search String: ='=' &vStartDate
However, whenever I try to select a date/time, the "deldate" doesn't filter. I am thinking it may have something to do with the date/time format which is not the same as the "deldate" format.
Why you are not using normalize structure. You can easily get your result by redefining field name / table structure at script level which helps you to create relationships.
Also See the table structure from table viewer on design pannel. OR use the delivery date in the dropdown field.
