2 Replies Latest reply on Jul 27, 2014 2:39 PM by philmodjunk

    delete contents of multiple cells

    KathyDavie

      Title

      delete contents of multiple cells

      Post

           I'm new to FM, and I want to know if I can select multiple cells in a column and delete the contents.

        • 1. Re: delete contents of multiple cells
          FentonJones

                

               I'd say "no", you must select each "field" ("cell"), select entire entry (unless you've told it to do this for that field, on that layout), then clear it.

                

               However, if this is something you do often, you could write a script to do this; create a button to run the script, and put it on the "record" ("column").

                

               Clear Fields (name of script):

                

               Set Field [ 1st field; "" ]

               Set Field [ 2nd field; "" ]

               Set Field [ 3rd field; "" ]

                

               The "" can clear any type of field.

               You'd want to put this button just after the fields you mean to clear.

               Possibly some other way to let you know which fields.

               If necessary, a dialog to ask whether to "Clear", and tell them which fields.

               Unless it's just for you, and you remember all that :-|

          • 2. Re: delete contents of multiple cells
            philmodjunk

                 Replace Field Contents can clear a field for all records in the current found set.