Forum Discussion

Re: Cascading Dropdowns

Thank you, Don. Your "Last Steps" were the pieces I was missing, and I have made it work just as I had hoped...

...with one exception. The dropdown menus contain just what I specified EXCEPT for the item at the bottom which allows the user to add a category. I don't want the general user to be able to add a Category 1 or Category 2. We had users being lazy and adding a new category when they had something unfamiliar to them, rather than think through how it could fit into an existing category.

I have hidden the Category 1 and Category 2 tables from the Table Bar so users can't see them, but those dropdown menus are setting me up for trouble with that "add" option. Can I turn that option off?

And, thank you again for getting me over the obstacle.

------------------------------
Rob Vugteveen
------------------------------

3 Replies

  • DonLarson's avatar
    DonLarson
    Qrew Elite
    Rob,

    Users creating bad data and being lazy....   So many stories.

    To prevent this, change the permissions on those two tables to prevent certain User Roles from being able to Add Records.   

    Go to settings for the table in question
    The right hand column is Workflow & Permissions
    The second one down is Access
    This will show you all the roles and the permissions the have in that table
    Uncheck the 4th column from the right, Add

    Do this for both tables Category 1 and Category 2

    Now they can use the data in those tables but not add to it.  I suggest you also take away their ability to Modify.   
    Don't take away View as suddenly they will be unable categorize the Inventory items.




    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
    • RobVugteveen's avatar
      RobVugteveen
      Qrew Member
      Many thanks to Don and Babi for guiding me to success with the cascading dropdowns. My boss is ecstatic to finally have this capability in our inventory system.

      I now face the consequences of that success with another problem, but I'll put that in a separate thread. 
      (one-time internal conversion from the old category method to the new one)

      ------------------------------
      Rob Vugteveen
      ------------------------------
      • BabiPanjikar's avatar
        BabiPanjikar
        Qrew Assistant Captain
        Happy to hear that, Rob.

        Feel free to connect on your further queries.

        ------------------------------
        Babi Panjikar
        ------------------------------