Discussions

 View Only
  • 1.  Unable to Select Shared Field for Multi-Select Text Input Field

    Posted 05-10-2023 11:11

    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
    ------------------------------


  • 2.  RE: Unable to Select Shared Field for Multi-Select Text Input Field

    Posted 05-10-2023 13:12

    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
    ------------------------------



  • 3.  RE: Unable to Select Shared Field for Multi-Select Text Input Field

    Posted 05-10-2023 13:48

    Hi Mark,

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



    ------------------------------
    Peter Ohashi
    ------------------------------



  • 4.  RE: Unable to Select Shared Field for Multi-Select Text Input Field

    Posted 05-10-2023 15:02

    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
    ------------------------------



  • 5.  RE: Unable to Select Shared Field for Multi-Select Text Input Field

    Posted 05-10-2023 15:06

    ... or maybe just delete that field and make a new field from scratch.



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