Conditional Values - Reference Fields

Question

Hello,&nbsp;
I have position field that is based on a selection in my department field. I'm running into an issue with the display of my position field. When I click on Department, the list of positions for that department show, however, when I select the position name, the value displays blank.
This is only happening for certain positions. I've tested and around 80% of the position names show when selected and the others do not.&nbsp;
I've attached a few screenshots.&nbsp;
------------------------------Erika Brown------------------------------

markshnier__you · Answer

Erika,&nbsp; I know that you are working on new forms and I'm more familiar with old forms so I will give you an old forms answer. Hopefully it's the same my new forms. You should be able to take note of the report which is used to drive that drop down. It will be a property of the form. It will either be the record picker report or an actual report. Regardless of which one it is when viewing a record in edit mode what will show up in that field is going to be the very first field on either the record pickers that you have selected in the advanced properties for the table or else it will be the first column of the report that you have designated to be used for the drop-down list. Check to make sure that is the correct field because perhaps it is showing a field which is blank on some records.&nbsp;&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

erikabrown · Answer

Hi Mark, I'm wondering if this is a bug in the new forms. I tried this out in the old forms and it's working perfectly. I tested the steps you suggested, and some values are still showing blank while other are not.

------------------------------
Erika Brown
------------------------------

markshnier__you · Answer

I agree.&nbsp; &nbsp;It sound like a support ticket.&nbsp; We would all be delighted if you would post back with what they tell you.&nbsp;&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

erikabrown · Answer

I've submitted a support ticket. I'll post back with an update!------------------------------Erika Brown------------------------------

erikabrown · Answer

I haven't heard back from Support but, I was able to figure out the issue. I looked at the positions that weren't showing when selected to find a pattern, and it was all positions with the "&amp;" symbol. I swapped out the "&amp;" with "and" and the positions are showing now. Definetly a bug in the new forms.&nbsp;------------------------------Erika Brown------------------------------

Forum Discussion

Conditional Values - Reference Fields