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

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
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!
Photo of Clayton Rountree

Clayton Rountree

  • 264 Points 250 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.
Photo of Clayton Rountree

Clayton Rountree

  • 264 Points 250 badge 2x thumb
That's a great, simple suggestion, thanks!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
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.