Conditional Dropdowns, Cascading Dropdowns and Cascading Permissions

Question

Howdy,&nbsp;I have a budget application. In my budget application, I have Budget Areas, Accounts, Categories, and Expenses.&nbsp; I also have employees/budget managers.&nbsp; Basically, I want my budget managers to enter expenses on the expenses form. When they click on Area,&nbsp; I want them to see only areas that they are assigned to. Then, based on what area they choose, they can pick from a list of accounts. Based on the budget manager/area/account relationship, they see a limited number of categories.&nbsp; I think I probably need to add some sort of many to many assignment table.&nbsp; So for example, Mike is the budget manager for both Business Solutions and Administrative Services.&nbsp; When he goes to enter Expenses, he should only be able to see these two areas.&nbsp; &nbsp;Then, based on which area he sees, he will pick from a specific list of accounts related to that area and a specific set of categories that are related to that area/account combination. I've tried following the instructions for cascading dropdowns, as well as creating the "assignment" relationship and following the instructions in the Cascading Permissions videos and can't quite get the limitations to work the way I would like. I'm not sure if I need to do something with formulas or if I'm just haven't cascaded the correct lookups and/or using the correct reference/proxy fields in creating the conditional dropdowns.&nbsp; &nbsp;The employee in the employee table is a user field as I was hoping to be able to use that in the roles to limit areas, etc.&nbsp; I've attached the current structure --&nbsp;Any suggestions are welcome.&nbsp;Thanks!Andrea------------------------------Andrea Johannes------------------------------

markshnier__you · Answer

OK, Let's eat this elephant one bite at a time.When they click on Area,&nbsp; I want them to see only areas that they are assigned to.A low tech solution here is to have a list user field on the Areas table and assign the area to the correct manager(s).Then you can have a report where the assigned managers includes the current user and change the form properties to use that report for the drop down list of areas.Then, based on what area they choose, they can pick from a list of accounts.&nbsp;You already have a Relationships where one are has many Accounts.&nbsp; Great.&nbsp; When they enter an expense the record will know the Area, so set the Field Properties for Related Account on the Expense table to be conditional on first selecting an Area.&nbsp;&nbsp;

Conditional values
The values in this field depend on a selection in another field

and a specific set of categories that are related to that area/account combinationSo One account has many Categories.&nbsp; You should be able to set the field Property for Related Category on the Expense record to be (similar to the above)&nbsp; conditional on first selecting the account.&nbsp;Conditional Drop downs are super powerful and perform really well for the user experience, so you are on the right track here.&nbsp;Post back if you get stuck.&nbsp; This is really classic sweet spot stuff for Quickbase.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

andreajohannes · Answer

Thank you, I will give that a try.Andrea------------------------------Andrea Johannes------------------------------

Forum Discussion

Conditional Dropdowns, Cascading Dropdowns and Cascading Permissions

2 Replies

Related Content

Conditional Dropdown to MultiSelect

Specific permissions needed to run a copy master and detail button?

Conditional Dropdown showing too many choices

Broken Conditional Dropdowns After Update

Conditional Dropdown Working from Grid Edit, but Not working from Form

Recent Discussions

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns

Quickbase JMP connection