Calculated fields in forms | Community
Skip to main content
H
HeatherTe1
October 27, 2023
Question

Calculated fields in forms

  • October 27, 2023
  • 2 replies
  • 730 views

Is there a way to create a form with weighted values for each answer to calculate a "score" on the total?

 

I have a form where some questions are more important, and others are less important. They have Yes/No response choices. But I want the score to reflect higher on 'yes' responses for questions that are of greater importance.

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

2 replies

skyehansen
Community Advisor
skyehansenCommunity Advisor
October 28, 2023

Chloe posted a similar formula as a response to this post, maybe it will give you some ideas?

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/has-anyone-built-a-calculated-field-using-ifin-formula-for-a/m-p/504032/highlight/true#M35782

    N
    nryan2
    Level 3
    October 30, 2023

    I don't know if you have tried this, but you can add values to the Yes/No choices in the custom field and then use text mode to display them in a report. And you should also be able to create another calculated custom field that adds up that value to the responses to all the questions. 

     

    Here's the code to display the value in a project report. Just change the name of the field to the name of your custom field.

    displayname=Yes/No (returns value)
    linkedname=direct
    namekey=Yes/No with Values
    querysort=DE:Yes/No with Values
    textmode=true
    valueexpression={DE:Yes/No with Values}
    valuefield=Yes/No with Values
    valueformat=HTML

    Terms & ConditionsAccessibility statement

    Loading footer...