Ref with auto fill

AppSheet AppSheet Q&A
,
1

Hi there,

I’m trying to get a “ref” field to have auto fill for when creating the form, but later editable by the admins when required. So when creating the form it’ll say “proccessing” to the foreman (cannot be changed by the foreman), then later on when the order is done it can be edited to “ordered”, “out for delivery” and “completed”, which will be done by the admins.

Thanks in advance.

2

Intial Value

"proccessing"

Editable IF

OR(
   ISBLANK([_This]),
   [User]="Admin"
)

Valid IF

OR(
   [Status]="proccessing",
   AND([User]="Admin",[Status]="ordered"),
   AND([User]="Admin",[Status]="out for delivery"),
   AND([User]="Admin",[Status]="completed")
)

Simon, 1minManager.com