I am having an issue with my app, I am getting an error " Value ‘Site Query’ in field ‘Status’ cannot be converted to type 'Enum." I know that this isn’t in the list of allowed values. I thought I could bypass this by adding a valid_if statement for ‘Status’ however this only gets past the ‘Value is invalid’. I also know this can be solved by adding the option to add values to the enum but I don’t want anyone else to be able to do so.
Is there a way to use USEREMAIL() to allow exclusive enum values depending on the email address the user uses? For example:
My Email has the option of ‘Started’, ‘Completed’ and ‘Site Query’.
and other users only have the options of Started and Completed.
I can change status to ‘Query’ through the mySQL database and this runs ok on the app, however I can’t set the value through the app which I want supervisors on site to be able to do. Any help would be appreciated.