Run bot without filling required fields

[d-grigsby]

I am sure this has been answered before and my apologies for not being able to find it, but how can you run a bot without filling required fields so that the bot makes a new row and when a user edits this row they have to enter the data in the required field.  "Date" for example is one of the columns I would need the bot to leave blank and the user would have to fill out when editing the row. 

[TeeSee1 · Accepted solution]

Try setting something like below in the Required_if property of the field.

ISNOTBLANK(
 FILTER(
  "your table",
  [key column]=[_thisrow]
 )
)

This means the filed is required only if a row already exists and is being edited but not required when a row is first created and saved.

[d-grigsby]

Worked perfectly.  Thank You TeeSee1!