Forum Discussion

HarrisonRay's avatar
HarrisonRay
Qrew Member
4 years ago

Fill Down Without Replacing

Hello!

Does anyone know of a way to fill down in grid edit on a multi-select text field, but instead of deleting and replacing any existing data, it simply adds data? So if there are already several selected options in the multi-select field and I want to "check" another option on all the records on a report (each record containing a different set of selected options), it will just add the intented option without deleting all the others?

For complicated reasons, I'm unable to import from a csv.

Thanks for any insight!

------------------------------
Harrison Ray
------------------------------
Ask about Quickbase functionality
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    4 years ago

    I don't know of a way using fill down, and I haven't tested this but I suspect you could make a field called [Selection to Add], make that a multiple choice field with the same options as the multi-select field.

    Then make another formula field that is [Multi Select and Selection to Add] with the formula list(";",[Multi-Select field],[Selection to Add]). Essentially, concatenate those two fields.

    Fill down on your selection to add. Then copy paste everything from the formula field, to the multi-select field.



    ------------------------------
    Mike Tamoush
    ------------------------------
    • HarrisonRay's avatar
      HarrisonRay
      Qrew Member
      4 years ago
      Mike, 

      Really appreciate all your help! This sounds like an effective method for accomplishing what I need. We have some old custom code from when our app was built several years ago, so I want to make a copy of the structure of the app in order to test this method before applying it. We don't have sandbox functions.

      My app is relatively active with users. We have anywhere from 10-20 users at once, most working hours of the day. So when I go to make a copy, I need to make sure it doesn't disrupt current app use at all. I'm assuming copying the app with data would cause a momentary delay, but if I copy just the structure, would that cause any momentary pauses in the app at all?

      Thanks!

      ------------------------------
      Harrison Ray
      ------------------------------
      • MichaelTamoush's avatar
        MichaelTamoush
        Qrew Captain
        4 years ago
        Not my forte, but I can't imagine any reason making a copy of an app would have any affect on the initial app.

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