Thread

I have two fields, that are set as numbers, in EE 2

I want to add and display the total.

I know I can accomplish this with php, but is it possible to accomplish this natively in EE?

Below is the code that accomplishes this using php

<?="{custom_number_field_1}" + "{custom_number_field_2}"?>

Is it possible to do this natively in EE 2?

I think MX Calculator may do the job.

Perfect, thanks!

{basketball_schedule_score}
    {if "{count}" == 1}
    <table class="basketball-result">
    <tr>
        <th>Team</th>
        <th>1st</th>
        <th>2nd</th>
        <th>Total</th>
    </tr>
    {/if}
    <tr>
        <td>Wolverines</td>
        <td>{first_half_you}</td>
        <td>{second_half_you}</td>
        {if "{exp:mx_calc expression='sum({first_half_opponent},{second_half_opponent})'}" < "{exp:mx_calc expression='sum({first_half_you},{second_half_you})'}"}
        <td class="total">
        {if:else}
        <td>
        {/if}
            {exp:mx_calc expression="sum({first_half_you},{second_half_you})"}
        </td>
    </tr>
    <tr>
        <td>{title}</td>
        <td>{first_half_opponent}</td>
        <td>{second_half_opponent}</td>
        {if "{exp:mx_calc expression='sum({first_half_opponent},{second_half_opponent})'}" > "{exp:mx_calc expression='sum({first_half_you},{second_half_you})'}"}
        <td class="total">
        {if:else}
        <td>
        {/if}
            {exp:mx_calc expression="sum({first_half_opponent},{second_half_opponent})"}
        </td>
    </tr>
{if "{count}" == "{total_rows}"}</table>{/if}
{/basketball_schedule_score}

http://cl.ly/5db9a73634775de69439

Be careful when quoting and bracing conditionals like that, you’re creating a security problem.  See troubleshooting conditionals.

You’ve got quite a few in there, too.

Thanks also for sharing your solution. =)

You are referring to #5 on that page?

5) Are you comparing a quoted variable to a value?  This is not supported and depending on the source of the variable, may even have security implications.  By doing this, you are allowing the tag that “owns” that variable to parse and replace it with its unfiltered contents.  Doing so is trusting that it has no bad characters, no javascript, and no need for error checking that is normally performed when the conditional is used with the proper syntax outline above.

Yep, #5. =)

If I could “guarantee” the value of each field, is only a number and nothing else, then it’d be secure?

Hi, Brad - that’s really something that you have to decide.  If you are sanitizing yourself, or not taking user input, then it may be an acceptable risk.  I’d never do that with something like segment conditionals.

Moreover, there’s no need at all to do it with this:

{if "{count}" == "{total_rows}"}</table>{/if}

=)

{if "{count}" == "{total_rows}"}</table>{/if}

is for the matrix field type.