Latest Contributions by Katie_Clark

I think you want an and instead of or in your statement? ... View more

I did a bit of testing, and as far as I can tell it seems like the constraint_message column in the XLS form doesn't recognize conditional logic. However, there are a couple ways you could achieve this. First off, I put this in the constraint column (these conditions must return TRUE for the entry to be valid) ${cab_year} = 9999 or (${cab_year} <= number(format-date(today(), '%Y')) and ${cab_year} > 1000) Then, in the constraint_message column, you could just have a more general error message. "Please make sure you have entered the year in the correct format (YYYY) and it is not greater than the current year."   Additionally, you could have note fields with null in the bind::esri:fieldType column that conditionally display if a certain condition is met. So something like this: In the label: <font color = 'red'>Year input cannot be greater than current year with the exception of 9999.</font> In the relevant column: ${cab_year} > number(format-date(today(), '%Y')) And then you'd add another note field the exact same way, but with a different label and condition in the relevant column. Hope that helps! ... View more