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