I have a button that disables if the current user isn’t listed on a table. (Below is the button Disable Formula. The last “OR” does this)
thisRow.HiddenDateSubmission != “” OR thisRow.[Quote Received] = “False” OR
thisRow.Approver.Contains(User()) = False
I have a column (Approver) that filters from the “People Quality Issues table” only people that have a slider marked as true. Here is the formula:
Filter([People Quality Issues],[Approve Labor] = true)
The formula works great, but for some reason the “Approver” column isn’t being treated like a people column (although its selected as one) which means the disable if formula doesn’t work. If I remove the formula and manually select people from the dropdown box (using a lookup to the People Quality Issues table) it works fine.
Any ideas what I’m doing wrong?