Forum Discussion

PeterOhashi's avatar
PeterOhashi
Qrew Member
2 years ago

Unable to Select Shared Field for Multi-Select Text Input Field

I have a table that consists of different department tags, such as HR, Operations, Research, etc. I have a separate table that has projects that get tagged to multiple departments. I want to create a multi-select text field that uses the "Department" text field in the other table as a source field. When I try this the pop-up opens and I am able to select the correct field, but when I click "Ok" the field does not update.



The "Select shared field" option is now grayed out and when I try to save I get the following message:



Any and all suggestions welcome!



------------------------------
Peter Ohashi
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    The source field for a multi select field may not be another multi select field.  is that what you are trying to do?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • PeterOhashi's avatar
      PeterOhashi
      Qrew Member
      2 years ago

      Hi Mark,

      No, the source field, "Department", is just a simple text field. 



      ------------------------------
      Peter Ohashi
      ------------------------------
      • MikeTamoush's avatar
        MikeTamoush
        Qrew Commander
        2 years ago

        Not sure if it is the same root cause, but I just had an issue where I was trying to change my shared field, and it would simply not recognize my choice. No matter if I changed to 'From List' or even selected a different shared field, it was somehow 'stuck' thinking I still had my old shared field selected. 

        I worked with customer support, and they went in and had no issue with it. I went back in and it was suddenly just fine (of course, customer support thought I was crazy lol). I'm not sure if it was a caching issue or what? My guess was the simple act of some other admin opening it and saving it somehow corrected the issue. Do you have a second admin that can try to edit the field and save it? 

        If not, maybe try customer support to see why the button is grayed out.



        ------------------------------
        Mike Tamoush
        ------------------------------