I am attempting to set a cascading dropdown names City in an Expense Claim RS using the Destination cities from a Travel Request RS
A request is made to travel to the following destinations
The Expense Claim RS Country field should only display Guatemala and Australia, which would filter the city to Flores or PERTH WA
what is the actual issue here? Is it that when you select the country, the next lookup doesn't automatically select a city from that country?
If you're trying to get it pick a city automatically, isn't that kind of dangerous when it comes to something like expenses or travel, because it would let the user be lazy and not set the actual city themselves, which would result in potential errors in the data they are submitting.
What if you had a rule for the city and the country, that they were "Required" fields and the user must select them, themselves. That would reduce the number of submissions that had mistakes in them.
eg. What if everyone who was travelling to Guatemala, had "Flores" in their city, but half were actually going to Guatemala City, but they didn't pick that because the form looked like it was completed?
Thank you for reaching out :)
I need to ensure that only the Destination cities that the employee is travelling to can be selected,
This is to ensure that when they are specifying days and entitlement, the Per Diem rate is accurate in order to prevent an employee claiming more than they are entitled to.
In the example below the Per Diem Rate differs between Cordoba and Marsa Matrouh, then the sub total is calculated using the following formula
sum(if(Breakfast, 0.2, 0) + if(Lunch, 0.3,0) + if(Dinner, 0.4,0) + if(Incidentals, 0.1,0)) * Days * PerDiemRate)
as Entitlement equates to a percentage of the Per Diem Rate - Breakfast 20%, Lunch 30%, Dinner 40%, Incidentals 10%.
In Cordoba the Employee has specified that they will only be taking Breakfast and Lunch so 50% of $75 * 5 days can be claimed where as for Marsa Matrouh 100% of $38 can be claimed for the 2 days
I hope this makes sense and explains why employees must only choose cities that they are travelling to.
I look forward to your advice to resolve this issue
Thanks for all your help on previous posts
I believe I may have worked around this by dragging the Per Diem repeating section into the Travel Itinerary as below and linked the Per Diem Rate calculation directly to the Destination City Field which in this case is Bridgetown.
Few questions -
Thanks for your help