how long before custom fields are available for calculation | Community
Skip to main content
KristenS_WF
KristenS_WF
Level 6
July 29, 2024
Question

how long before custom fields are available for calculation

  • July 29, 2024
  • 1 reply
  • 939 views

I'm playing around with some custom fields in our Sandbox Preview environment.  I created 4 custom fields in a project-based custom form.  I'm now attempting to create a calculated field that uses those 4 custom fields.  In the past, I know you had to save/close out of the form and reopen it before newer custom fields would show as available in the Calculation Editor.  I've done that several times now, and I've also refreshed my browser, but the fields do not appear.

Is this a problem with the new form builder?  With the test environment?  How long does it take for these fields to become available?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    KristenS_WF
    KristenS_WFAuthor
    Level 6
    July 29, 2024

    Well, I can manually add the fields to the editor; I just can't select them from the dropdown list.  I guess that's better than nothing.

      quarkmage
      quarkmage
      Level 3
      July 29, 2024

      Do you happen to be working on any custom field calculations that are date-based? Just curious. I continue to look for easy ways to calculate turn-around-times from existing reports, but calculating difference between dates seemed previously outside of workfront's capability, but i am not sure how accurate or current that information is.  Thanks.

      KristenS_WF
      KristenS_WFAuthor
      Level 6
      July 30, 2024

      Not currently.  But I do recall in the past having to create some custom calculated date fields that use the CLEARTIME function.  I was trying to do a conditional formatting comparison of dates in a report, and the timestamps kept screwing things up.  I needed calculated fields that cleared the timestamps in order to make the comparison work.

      There are date/time functions you can use to calculate the differences between dates.  I believe they work both in calculated fields and in reports/views: https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions#date-time-calculated-custom-fields 

        Terms & ConditionsAccessibility statement

        Loading footer...