Calculated SP Field

Forums Dynamic Forms for SharePoint Calculated SP Field

Viewing 1 reply thread
  • Author
    • #35887

      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:

      It returns as “2022Q2” format

      Calculated field name: QtrCal
      Text field name: YrQtr

    • #35888
      Alexander Bautz

      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.


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