Skip to main content
Question

Fill Down Without Replacing

  • April 2, 2021
  • 0 replies
  • 26 views
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+14

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
------------------------------
Terms & ConditionsAccessibility statement