I am designing a form about meeting scheduling and a meeting can be scheduled at a given start and end time. I am generating a unique code by combining values from date, time and location the user has selected and saving in calendar list on form save. The problem is i want to check whether the selected time, date and location does not conflict with previously selected time, date and location.
I have tried using calculated value field and used lookup but it only returns the first value 'location3' and not returning the location2 value
I get not wanting to use and workflow, but you are just overcompicating your form 5o avoid using a more robust logic engine such as a workflow to do this for you. Not wrong, just not the easiest and best route.