OK. Please let Support know about the bug and ask Support to confirm that they agree that it's a bug. Support will also tell you if it is a known bug or you were the first to report it.
Original Message:
Sent: 09-15-2023 18:11
From: Erika Brown
Subject: Conditional Values - Reference Fields
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 "&" symbol. I swapped out the "&" with "and" and the positions are showing now. Definetly a bug in the new forms.
------------------------------
Erika Brown
Original Message:
Sent: 09-15-2023 17:27
From: Mark Shnier (Your Quickbase Coach)
Subject: Conditional Values - Reference Fields
I agree. It sound like a support ticket. We would all be delighted if you would post back with what they tell you.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 09-15-2023 17:25
From: Erika Brown
Subject: Conditional Values - Reference Fields
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
Original Message:
Sent: 09-15-2023 16:48
From: Mark Shnier (Your Quickbase Coach)
Subject: Conditional Values - Reference Fields
Erika, 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.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 09-15-2023 15:20
From: Erika Brown
Subject: Conditional Values - Reference Fields
Hello,
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.
I've attached a few screenshots.
------------------------------
Erika Brown
------------------------------