Calculated SP Field

Forums Dynamic Forms for SharePoint Calculated SP Field

Viewing 1 reply thread
  • Author
    Posts
    • #35887
      Sanchez
      Participant

      I have a Calculated Column that helps me capture the current fiscal quarter when a form is submitted. Seems like Calculated fields aren’t visible in DFFS New Form. Is there a way to make a calculated field visible on a form? If not, is there a formula I can use on the ‘Set field value’ rule of a text field that could return the same value? or a Custom JS I can plug in?

      Current formula I’m using in the standard Calculated field is:
      =YEAR(Created)&”Q”&CHOOSE(MONTH(Created),1,1,1,2,2,2,3,3,3,4,4,4)

      It returns as “2022Q2” format

      Calculated field name: QtrCal
      Text field name: YrQtr

    • #35888
      Alexander Bautz
      Keymaster

      Calculated columns are only visible in DispForm in SharePoint – this is not specific for DFFS.

      Even if the column is not visible, the value in the calculated column will be properly calculated when you save the form.

      Alexander

Viewing 1 reply thread
  • You must be logged in to reply to this topic.