Forum Discussion

ClaytonRountree's avatar
ClaytonRountree
Qrew Cadet
7 years ago

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

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!

3 Replies

  • 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.
  • 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.