Agentry : List selection edit type

Experts,

I have a list selection Edit type for a transaction property "WorkDate". I would like to restrict the dates in this calendar to LTEQ to system date. I have defined an include rule to restrict the values however, that doesn't seem to work as expected.

What am i doing wrong here? Any pointers will greatly help.

workdate.jpg (88.6 kB)
reference-rule.jpg (223.0 kB)
rule.jpg (33.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 31, 2017 at 07:34 PM

    I was still a bit confused so I pulled up the definitnions. The WorkDate field you are looking at that is defined as a list selection is not the field you see on the screen. If you check the Rules / Hyperlink / Special Value tab you will see its hidden rule is Always Hidden. Meaning it will never be shown. The field you see on the screen is WorkHrsDate which is defined as a date field. Date fields cannot be restricted during date selection. If you want to restrict a date entry you will need to use validation rules.

    List selection does have an include rule which functions as you describe but the user interface for that is a list control not a date picker.

    --Bill

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 02:17 PM

    Are you sure you are looking at the right field? The workdate.jpg image shows the date as a date field not a list selection. I would recommend simply including a validation rule to ensure the date selected is not in the future. That way the user will be able to use the calendar picker to set the date.

    If you want to use a list selection you will need to populate a collection with all dates less than the current date and the user will be able to click on a date value from the list.

    --Bill

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 05:59 PM

    Thanks Bill.

    That's a good idea, i could use a validation rule. I would however like to know how to restrict values in the calendar. The WorkDate field shows date as date field but the edit type is list selection. I understand that there is an "Include" option for list selection that checks for each record in the object and if it matches a rule. Is this something i can use?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 09:51 PM

    Thanks Bill. I have used validation rule for this as suggested.

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content