Need an action condition formula
Hi, I am trying to find a formula to make an action (button) available based on a value in another table/column. I thought this might work…
=SELECT(Acq. Chart[Status], AND([_THISROW].[Goal ID] = [Goal ID], [Status] = “Current”))
…but it doesn’t. I get an error message that says the result has to be true, yes/no, ect. I want the action to be available only for current rows that also have a related record in another table (Acq. Chart) with a [Target] with a value of “Current”. Is this possible?
Alternatively, is there a way to make a required column function in a form where the value is selected from a button list? When I set the input type to “dropdown” and there’s no value in the field it returns the appropriate error message, but when the input is “buttons” it doesn’t. It goes ahead and generates the new record without the required field filled in.
I would appreciate any help on this. Thanks