Seems like this should be doable, but Im struggling to figure out the right way to accomplish...
<<over-simplifying my example>>
I have a table with Status and Notes. When Status is 'Closed', the Notes field should not be editable. Easy, I added the necessary formula on the Editable? setting for the Notes field. That works fine.
Now I have an action button that should do two things... (1) change the Status field to 'Open' , and (2) Prompt for Notes entry via the Input function. This is where Im stuck.
Without any additional modifications to the Notes field Editable? formula, the user gets the pop up but the Notes field is still locked from editing. (I would assume because the Status change does not become official until I fully complete the action).
Anyone have an idea on how I can modify that Editable? formula so it allows the input like I want it?
LinkedIn
Twitter
