Discussions

Expand all | Collapse all

validate date fields before saving

  • 1.  validate date fields before saving

    Posted 04-23-2017 12:59
    I want to record the dates on which a boat will be leaving and returning to their dock.  I don't want the return date to predate the departure date.  I see how I can use a dynamic message to warn the user of invalid dates, but it lets them save it anyways.  (Seems to me that "prevent save" would be a good action to include in dynamic forms.)  But that doesn't seem to be an option.  I thought maybe a formula field holding the duration between the two dates would also work, but I don't see how the calculated field would be validated.  Am I missing something, or is this a glaring gap in the product design?


  • 2.  RE: validate date fields before saving

    Posted 04-23-2017 13:17
    I suggest using a dynamic form rule.

    When the record is saved

    In the following conditions are true

    Departure date is less than an arrival date

    Action

    Abort the save with the following message

    Sorry but the record was not saved. The departure date is before the arrival date. Please correct your data and try again


  • 3.  RE: validate date fields before saving

    Posted 04-24-2017 02:37
    Ah, I didn't see notice that I could include conditions other than those related to field actions.  Thanks.