Need Help w/filtering drop-down box options (date comparison) - InfoPath Dev
in

InfoPath Dev

Need Help w/filtering drop-down box options (date comparison)

Last post 09-09-2016 03:13 PM by Agent-311. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-07-2016 04:41 PM

    Need Help w/filtering drop-down box options (date comparison)

    Scenario: 

    1.  User puts in a start date, end date, and model#

    2.  External Data Connection is queried for existing reservations (model, start date, end date display in a repeating table)

    3.  Drop-Down Box displays all the ID's for the selected Model, not just the ID's available during that time.

     

    Problem:  I want to reduce the drop-down box options to only show those without a schedule conflict. Please help convert my "Exclude" statements below to "include" statements InfoPath supports

    1.  Exclude if desired Start date is in existing reservation range (after external start date and before external end date)

    2.  Exclude if desired End date is in existing reservation range (after external start date and before external end date)

    3.  Exclude if the desired reservation starts before & ends after existing reservation


     

     

     


     

    Filed under: , , ,
  • 09-09-2016 03:13 PM In reply to

    **Update** 

    I couldn't figure out how to reduce the drop-down box options as needed, but was able to apply rules to a button so that they can't proceed if they selected an invalid entry.

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.