I'm attempting to set the value of the below cascading lookup field based on a choice field in the below form to request approval to travel.
I have set-up the below section of the form using cascading lookups to filter the list of cities when a country is selected for both Departure and Destination.
My issues started when I attempted to
a) Prevent the selection of identical countries when Flight Type = International
b) Set and disable the Destination country when Flight Type = Domestic. I am unable to filter the Destination country using rules or by calculated values, and I created a new field for the domestic city which is conditionally hidden based on Flight Type however when hiding fields on this form, field layout went a little haywire.
c) I also need to prevent the date of departure being set to prior to the current date, also when add new row is selected It would be useful to set the date to the previous date of departure + 1
This is a complex form with many sections which I really need assistance with.