Jump to content

Search the Community

Showing results for tags 'multiple filters'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 1 result

  1. I'm creating an appointment request form but I've run into a problem I can't seem to figure out. I'm trying to figure out how to filter a dropdown/picklist based on multiple criteria. Criteria # 1 Office location. - Client selects an office location first, so I used it as the parent field of my cascading dropdown Criteria # 2 Is the date of the requested appointment (Date_Requested) the current date or date in the future Criteria # 3 If the date of the requested appointment is the current date, filter by appointment slots greater than 2 hours. The dropdown list is another table in my system which contains the following fields. Office_Location Timeslot (ie. 8 am-9 am) Appt_Hour (this is the hour of the time slot, ie. 8 am - 9 am shows as 08) Current (this is a y/n field) Basically what I need to happen, is that when a user selects the facility and the requested date of appointment, *if the requested date is after today, they will be shown all appointment slots for that facility that are marked "N" in the Current field *if the requested date if for the current date, it will show only appointment slots that are marked "Y" in the current field and who are greater than 2 hours in the future. ie. if they request an appointment at 10:30 for the same day, the available appointment slots are 1pm-2pm, 2pm-3pm, etc. Any assistance would be greatly appreciated. Thank you
×
×
  • Create New...