Run bot without filling required fields

AppSheet AppSheet Q&A
,
1

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.

2

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.

1 Like
3

Worked perfectly. Thank You TeeSee1!