I have spent close to 200 hours trying to understand and figure out one feature which should be simple and I cannot figure it out for the life of me. It doesn't matter which videos I watch/form I read/AI prompt I type, I just keep hitting a brick wall.
I am trying to build a work order app. There are 3 kinds of potential work orders: Development, Maintenance, and Tech. We have about 20 different properties and the user needs to be able to select the correct property for the work order request. However, there are properties within our organization that we do not want all users to know about/have access to (we house DV victims similar to WPS). How do I create a "New Work Order" form with a dropdown that will only display the properties the logged-in user can access. Every formula I try seems to come back with an error.
I have data tables for properties, employee info, and work orders and have created probably a dozen other tables just trying to experiment with how to make this work. Is there any way someone would be willing to walk me through this and help me understand what I am doing wrong? Our organization does not have an Enterprise Account, therefore, Domain Authentication is not an option.
LinkedIn
Twitter
