2 Replies Latest reply: May 15, 2014 10:01 AM by Grant Perkins RSS

    Adding a default field

    Matixsnow _

      What is the easiest way to add a field to a set of data in Monarch where every value in that field is the same for every record?  Right now I go to Data - calculated fields - lookup - select any field for the lookup to reference to and then set a default value.

        • Adding a default field
          Nigel Winton

          Hi There

          It is quite easy, just set up a calculated field and instead of a formula, enter whatever you want to see. This can be of any data type as long as you use the quote marks for text or the {} brackets for dates it will work. Just remember to set the data type for the field and all is well. You can also reference this field in other calculated fields.

           

          Regards

           

          Nigel

            • Adding a default field
              Grant Perkins

              For those with recent versions of Monarch (8 and 9 for sure, I can't remember if 7 as well) you have the "Runtime Parameter" calculated field to play with and the option to retain a value in the Registry for repeated use.

               

              With V9 you also have the "User-edited" option although whether or not that is relevant could depend on the purpose of the field.

               

              Grant