# Adding a dropdown box to a dashboard **URL:** \ **Category:** Epicor ERP 10\ **Tags:** e10\ **Created:** [November 5, 2018, 9:42am UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396 "2018-11-05T09:42:01Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\ **Post date:** [November 5, 2018, 9:42am UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/1 "2018-11-05T09:42:01Z")
Hi all, I am trying to get a dropdown box to display on a dashboard, so far without much luck. I have added it to the BAQ like this; ![image](https://epiusers.help/uploads/default/original/2X/a/af8e4b214ad65a1240ea97250dadfa9420b91eb7.png) The column shows and when I double click I can update it. When I create the dashboard the column shows, but not as a dropdown, and when I test / deploy the dashboard the column is not there at all. I think I may have missed a step or something. Has anyone done this successfully before and can point me in the right direction? Thank you Adrian ---
**Author:** ![A.Baeisa](https://www.epiusers.help/user_avatar/www.epiusers.help/a.baeisa/32/8988_2.png) [@A.Baeisa](https://www.epiusers.help/u/A.Baeisa)\ **Post date:** [November 5, 2018, 11:08am UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/2 "2018-11-05T11:08:43Z")
could you screenshot the field on your updatable dashboard ? ---
**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\ **Post date:** [November 5, 2018, 11:32am UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/3 "2018-11-05T11:32:02Z")
Here is a screenshot of the dashboard in ‘Dashboard’ mode ![image](https://epiusers.help/uploads/default/original/2X/a/a6df2bc768068e7b60af469cace15eed68faa7ca.png) and another showing the deployed dashboard with the missing column. ![image](https://epiusers.help/uploads/default/original/2X/4/4563896049cbbac3933eea0d9005e05841dfb242.png) Thanks Adrian. ---
**Author:** ![A.Baeisa](https://www.epiusers.help/user_avatar/www.epiusers.help/a.baeisa/32/8988_2.png) [@A.Baeisa](https://www.epiusers.help/u/A.Baeisa)\ **Post date:** [November 5, 2018, 1:37pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/4 "2018-11-05T13:37:05Z")
sorry for asking this obvious question…is the field CAD Person marked as an updatable field on the dashboard query properties ? ![image](https://epiusers.help/uploads/default/original/2X/9/9b6fa77055676366c496c8173bb6b7b598212388.png) ---
**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\ **Post date:** [November 5, 2018, 1:51pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/5 "2018-11-05T13:51:11Z")
Hi Al, Yes it is; ![image](https://epiusers.help/uploads/default/original/2X/2/25c10092651756eb291805df2dc985e9f0993536.png) Regards Adrian ---
**Author:** ![A.Baeisa](https://www.epiusers.help/user_avatar/www.epiusers.help/a.baeisa/32/8988_2.png) [@A.Baeisa](https://www.epiusers.help/u/A.Baeisa)\ **Post date:** [November 5, 2018, 2:05pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/6 "2018-11-05T14:05:56Z")
then, my last suggestion is to deploy it again, clear your client cache memory, log off, log back on, then call your dashboard from the dashboard maintenance not form anywhere else, please let me know if that worked ![image](https://epiusers.help/uploads/default/original/2X/5/566a5301feaf1e53825e395ecee82eb04320e0f7.png) ---
**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\ **Post date:** [November 5, 2018, 2:47pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/7 "2018-11-05T14:47:44Z")
Thanks Al, I tried all that but still no sign of the field when I deploy the dashboard ☹ ---
**Author:** ![A.Baeisa](https://www.epiusers.help/user_avatar/www.epiusers.help/a.baeisa/32/8988_2.png) [@A.Baeisa](https://www.epiusers.help/u/A.Baeisa)\ **Post date:** [November 5, 2018, 2:51pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/8 "2018-11-05T14:51:31Z")
unfortunately, i run out of suggestions @Adrian_Mepham, just for me to know, have you used Custom Values on this Epicor version before?, any where else ? if yes is it working?, ---
**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\ **Post date:** [November 5, 2018, 2:57pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/9 "2018-11-05T14:57:47Z")
Hi Al, no I haven’t. This is the first time I have attempted to place a dropdown list in a dashboard. Do you think I should log a support call with Epicor? I’m on 10.1.500.28, maybe a bug in that version? Regards Adrian. ---
**Author:** ![A.Baeisa](https://www.epiusers.help/user_avatar/www.epiusers.help/a.baeisa/32/8988_2.png) [@A.Baeisa](https://www.epiusers.help/u/A.Baeisa)\ **Post date:** [November 5, 2018, 3:16pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/10 "2018-11-05T15:16:56Z")
i never used it, so i can not be sure, it could be a bug, but what i have used in many of my dashboards is a User Code and BAQ options, would you like to try them and see, if CAD person refer to Epicor Users/Employee/ or contacts then i advice you to create a simple BAQ displaying what ever you want to see in your dashboard drop down list then link the dashboard BAQ updatable field to this BAQ query, if not define a user code list and use it…i am interesting to know if this will work in your Epicor environment or not? ![image](https://epiusers.help/uploads/default/original/2X/f/f26162d6bf2ed37e5b4657beedd1745792adaa3d.png) ![image](https://epiusers.help/uploads/default/original/2X/a/aa51cf10b5a1b1e9376e392500d4888cc46d629b.png) ![image](https://epiusers.help/uploads/default/original/2X/7/786fe7aa70b886182a45919fa81303728235db6e.png) ---
**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\ **Post date:** [November 5, 2018, 3:37pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/11 "2018-11-05T15:37:11Z")
Thanks Al, I will try this approach and let you know what happens. ---
**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\ **Post date:** [November 6, 2018, 8:24am UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/12 "2018-11-06T08:24:51Z")
Hi Al, I followed your instructions and got the same result, everything is fine until I actually deploy the dashboard, then the field is gone. I found I could add the dropdown using a tracker but that is not ideal for what I am trying to do. I have logged a support call with Epicor and will let you know how I get on. Regards Adrian. ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [November 6, 2018, 5:11pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/13 "2018-11-06T17:11:23Z")
@Adrian_Mepham make sure that field is set as an Updatable Field in these tabs within the BAQ. ![2018-11-06_1209_001_001](https://epiusers.help/uploads/default/original/2X/d/d61d9cf388ddad076c68d4376d766e7c76c339f3.png) Then when you hit Get List under Analyze, and you click Update will it be a drop-down. **However, ONLY in a Dashboard it will be a drop-down right on the Grid itself**. **BAQ:** ![2018-11-06_1217](https://epiusers.help/uploads/default/original/2X/c/cd07f75950ec38e077186db056bfa527ba4ffa61.png) **Dashboard:** ![2018-11-06_1218](https://epiusers.help/uploads/default/original/2X/e/ed2f8ff1147802f3c585c9f0bb17183e56c13d33.png) * * * Second, Recommendation: if you can do not hardcode those values, make a BAQ and pull those names from where they should come from 🙂 You can name those BAQs XXX-Helper-GetSomething or XXX-zGetCadUsers etc Pull it from UserCodes if you have to 🙂 ![2018-11-06_1211](https://epiusers.help/uploads/default/original/2X/c/cbab081898cb1d2afedee971eb5771b88065d73e.png) ---
**Author:** ![Adrian\_Mepham](https://www.epiusers.help/user_avatar/www.epiusers.help/adrian_mepham/32/6960_2.png) [@Adrian\_Mepham](https://www.epiusers.help/u/Adrian_Mepham)\ **Post date:** [November 7, 2018, 8:35am UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/14 "2018-11-07T08:35:34Z")
Thank you Haso, What you have there is exactly what I have done, using the update in the BAQ works as you describe. It’s just that the field does not come through on the deployed dashboard. I have a support call logged but have not heard anything yet. Best regards Adrian. ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [November 7, 2018, 12:09pm UTC](https://www.epiusers.help/t/adding-a-dropdown-box-to-a-dashboard/49396/15 "2018-11-07T12:09:54Z")
If you have added the field after you have already started on the Dashboard, it will not become automatically visible on the Dashboard, you have to edit the properties (that dialog box that lets you select fields in the dashboard) and typically the field will be all the way on the bottom with the visible checkbox not checked. Sounds good, let us know what you find