Form Dropdown Filtering

[PapaBear9420]

I have a work order app that has a "New Task" view form. One of the drop-downs is titled "Task Type". The intent is for the user to select either "Development", "Maintenance", or "Tech". The form is a view of a "Work Orders" table. The column is titled "Task Type" and it is a ref column to a "Roles" table. There are a total of 11 roles but 8 of those roles should not be available options for users to select from as they are not roles that should receive work orders. I have found a multitude of formulas/ways to filter the options to the 3 that I desire. However, when I am successful, the result is that I get the yellow warning signs by each selection and the app gives me the error message of "Unable to add row to table 'Work Orders'. → Invalid request provided to AppSheet database". What I am missing that is causing this? Thank you in advance!

[Benny_E]

I think you set your "work orders" table to read only. I suggest you create categories in "Roles" table so whenever you want to add another roles in "Work orders" table for users, you can add it in "Roles" table with categories. the categories help you to classify the assignment of your roles to the users. I hope that helps.

[Steve · Accepted solution]

Part of the problem is that you're using AppSheet Database. It's a half-baked piece of junk developed by people who likely don't use AppSheet itself in any meaningful way. Google Sheets is a much better alternative.