Discussions

Expand all | Collapse all

Required Field Desired on Initial Record Creation, but not on subsequent edits

  • 1.  Required Field Desired on Initial Record Creation, but not on subsequent edits

    Posted 05-18-2018 21:37
    I have a few multi-line text fields (tracking history) that when creating a new record in the table I want to be required.  But after initial creation, there may be subsequent edits to the record. For these subsequent edits, I don't want all required fields to require updates (specifically the tracking history ones are requiring me to update them, even if I have nothing to add).

    For example...say I update the date on a record...should I also have to update the comments box, if I don't want to?

    It seems there should be a way to only require the field on initial record creation...is this possible?

    Thanks!


  • 2.  RE: Required Field Desired on Initial Record Creation, but not on subsequent edits

    Posted 05-18-2018 21:42
    No problem.

    Make a new field called record ID mirror and have the formula just be equal to the record ID.

    Then make a form rule that says when record ID mirror is blank require some field.


  • 3.  RE: Required Field Desired on Initial Record Creation, but not on subsequent edits

    Posted 05-21-2018 22:55
    That's a great, simple suggestion, thanks!


  • 4.  RE: Required Field Desired on Initial Record Creation, but not on subsequent edits

    Posted 05-21-2018 23:17
    Thx for letting me know.
    The trick with the [Record ID#  mirror] is required as for some reason,  you may not use [Record ID#] in a form rule.