{"id":1830,"date":"2019-03-20T10:04:22","date_gmt":"2019-03-20T09:04:22","guid":{"rendered":"https:\/\/help.cirrus-shield.com\/docs\/fields\/create-formula-field\/"},"modified":"2019-07-05T15:54:25","modified_gmt":"2019-07-05T14:54:25","slug":"create-formula-field","status":"publish","type":"docs","link":"https:\/\/help.cirrus-shield.com\/en\/docs\/fields\/create-formula-field\/","title":{"rendered":"Create Formula Field"},"content":{"rendered":"
\n
\n
\n
\n

Cirrus Shield allows you to create Formula Fields.<\/p>\n

Formulas can help you automatically calculate the value of a field based on other fields.<\/p>\n

1. Create a custom formula field:<\/span><\/strong><\/p>\n

    \n
  1. \n

    Log in to Cirrus Shield with your administrator profile<\/strong>.<\/p>\n<\/li>\n

  2. \n

    Click on your name, then select Setup<\/strong>.<\/p>\n<\/li>\n

  3. \n

    Go to the Object<\/b> tab, find the object on wich you want to add a custom formula field, and click on Details <\/strong>.<\/p>\n<\/li>\n

  4. \n

    Click on the Custom Fields\u00a0<\/strong>(On the top left).<\/p>\n<\/li>\n

  5. \n

    Click on New.\u00a0<\/strong>Select the Formula<\/strong> field data type, and click Next<\/strong>.<\/p>\n<\/li>\n

  6. Insert all the required Details<\/strong>.<\/li>\n<\/ol>\n

    2. Fill details of the Formula Field Data Type:<\/span><\/strong><\/p>\n

      \n
    1. Enter the Label<\/strong> of the Field. The Name<\/strong> is automatically filled.<\/li>\n
    2. Check the box “Blank fields will be considered as zeroes<\/strong>” if you want to see zero when the field is empty or check the box “The Blank fields will be considered as blanks<\/strong>” if you want empty value when the field is empty.<\/li>\n
    3. Select the desired Return Data type\u00a0<\/strong>(or the data you expect returned from your formula):<\/li>\n<\/ol>\n
        \n
      • The Checkbox<\/strong> : Returns a true or false value. The field appears as a checkbox in record detail pages and reports.\u00a0<\/li>\n
      • The Currency<\/strong>: Returns a number in currency format.<\/li>\n
      • The Date<\/strong>: Returns data that represents a day on the calendar.\u00a0<\/li>\n
      • The Date\/Time<\/strong>: Returns data that represents a moment in time. A date\/time field includes the date and also the time of day including hour, minutes, and seconds.\u00a0<\/li>\n
      • The Number<\/strong>: Returns a positive or negative integer or decimal.\u00a0<\/li>\n
      • The Percent<\/strong>: Returns a number in percent format.\u00a0<\/li>\n
      • The Text<\/strong>: Returns a number of characters.\u00a0<\/li>\n<\/ul>\n

        \u00a0 \u00a0 \u00a0 \u00a04. Use the Fields<\/strong>, Operators<\/strong> and Functions<\/strong> tabs to create your formula.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/p>\n

        \u00a0 \u00a0 \u00a0 \u00a06. Select the right field and use the Operators<\/strong> and Functions<\/strong> to complete your formula:\u00a0<\/p>\n

        \u00a0 \u00a0 \u00a0 \u00a07. Once your formula is ready, check it using the button Verify Formula<\/strong> on the right, then click on Save<\/strong>.<\/p>\n

         <\/p>\n<\/div>\n<\/div><\/div>\n<\/section>\n

        <\/p>\n","protected":false},"author":1,"featured_media":0,"parent":213,"menu_order":8,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_tag":[],"class_list":["post-1830","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/1830","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/comments?post=1830"}],"version-history":[{"count":68,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/1830\/revisions"}],"predecessor-version":[{"id":2128,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/1830\/revisions\/2128"}],"up":[{"embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/213"}],"next":[{"title":"Create Date and Date\/Time Field","link":"https:\/\/help.cirrus-shield.com\/en\/docs\/fields\/date-date-time-field\/","href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/5969"}],"prev":[{"title":"Create Multi-Relationship Field","link":"https:\/\/help.cirrus-shield.com\/en\/docs\/fields\/create-multi-relationship-field\/","href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/1817"}],"wp:attachment":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/media?parent=1830"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/doc_tag?post=1830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}