Forum Discussion

KaitlynStanley's avatar
KaitlynStanley
Qrew Trainee
2 years ago

Multiple Choice From Another Field Help

I am running into an issue with using shared values from one field to another.

I have a field on App One, Table A, called, Facility. It's Text - Multiple Choice. It uses From List to display the options. The checkbox is selected to use the values as a source in other fields. The app chosen is the same app, App One.

On Table B, the field Facility Assigned, is setup for input type From another field. App: App One, Field: Table A: Facility.

I changed the values in Table A: Facility, but values in Table B: Facility Assigned is showing the original values prior to my change.

It looks like Table B: Facility Assigned only pulls values that are already selected for a record from the original field. So if Facility1 and Facility2 are selected on records, then the Field only pulls those, doesn't matter if I remove those values from the original field or add new ones, if they're not selected to a record, it doesn't list them.



------------------------------
Kaitlyn Stanley
------------------------------

3 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    in my experience, when you use values from a other field, it will present the unique choices in the data, as opposed to the choices in the multiple choice field itself.  Can you add an occurrence of the missing data choice as a record in Table A and see if that solves the problem.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • KaitlynStanley's avatar
      KaitlynStanley
      Qrew Trainee
      I did go ahead and add the missing choice to a record and it does solve the problem. I just wasn't sure if there was a way around it. So that all choices are shown whether it's used in the data or not.

      ------------------------------
      Kaitlyn Stanley
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        No, that's how it works. You might also making a proper table of the choices, making the text field for the choice the Key Field and then making a relationship to pull the choices.

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------