Required_if

[provisrudd]

Hello,

I have looked around and could not find an answer. 

If a client wanted to update a form submission, is it possible to make a comment box be required if there are changes being made? I was thinking possibly a required_if based on a time_now column but when the forms submitted its always past the time_now column that would trigger the comment box even-though its a first time form submission. 

[SkrOYC]

You want to make it required just on edit but not when the data is being added to the table?

[provisrudd]

Yes, I would like to make a comment box required when an edit to the row is made. If that makes sense. 

[SkrOYC · Accepted solution]

Sure.

Put this on your Required If:

IN(
  [_THISROW],
  Table[ID]
)

Change the Table[ID] part with your actual Table name and ID column 

[provisrudd]

Is the ID column the Key?

[SkrOYC]

Yes, sorry, I should have told that

[Steve]

Or, more generically:

IN([_RowNumber], Table[_RowNumber])