Form Field Value determined by another Field

Try using CustomerEvaluating.Value == "Customer"

That doesn't work either unfortunately. Couple of things I've noticed.

One, existing records if re-saved do not get macros applied, only new records.

Two, the documentation here https://docs.kentico.com/display/K81/Reference+-+Field+editor#Reference-Fieldeditor-Settingdefaultformfieldvaluesthroughmacros says macros can be applied on form submission, this does not appear to be the case as I was unable to get it to work using the example in the documentation {% CurrentUser %}. I was however able to get a default value from a macro applied on initial load using the "Edit Value" method. This however does not work as I need the value to be calculated either on dependent field change or on form submit.

My workaround was to use a drop down list form control and use the macro (or SQL) option in the "Data Source" property to select only a single value (from a table or in-line) conditional upon other form field values).

if (CustomerEvaluating == "Evaluating") { 
  return "eval@domain.com"
}
else {
  return "cust@domain.com"
}

Ideally, the textbox form control should allow for macro expressions to set the value conditionally (not just as default) the same way drop-down/multi-select form controls allow.

Are you entering the macro value into the macro editor? I have tried to place the macros in the field itself, without clicking the arrow icon and expanding the macro editor, and it hasn't worked in some cases. The sytax seems like it should work.

Hi Brendon! (And Brenden... ☺)

You are right about the MacroExpressions not being supported in the 'Default values' of fields. Well at least not the ones dependent on another value from the same form.

What exactly are you trying to achieve by that? I mean... Surely the ultimate purpose isn't to have an e-mail stored in the database.

Of what sort is your form? Is it a Custom form, a class' form a page(document) type's form? These have different options. Either way, there's always the option of hooking up a piece of code to a global event fired when the form is submitted, but I'd suggest taking a step back, taking a broader look at what you're trying to achieve here (I understand if you're not willing to share that even if it's just because it's not easy to explain...) and trying to take a different approach to the problem.

If some of I have writen doesn't make much sense to you, it might be because I'm assuming you are working with the latest released version of Kentico. Correct me if that's wrong.

@Joshua - If entering the value into the macro editor, it works, but then it only triggers on form "save". Entering into the non-macro editor, it does not. As you suggest, it appears not all macros work using this method described in the documentation https://docs.kentico.com/display/K81/Using+macros+with+forms

@Vilem - The purpose of this use case is to send the form to a different email address based upon a selection in the form. The only way I found this to work with out-of-the-box forms is to save the value of the field selection (i.e. eval@domain.com) into another field "SendTo" (hidden) and then set the "To email" (under Email Notifications) using a macro with the value of this hidden field {%SendTo%}.

Thanks Vilem. That would work and I've marked as correct as it is the simplest solution and utilizes macros efficiently. For this scenario, we're going to stick with storing the email value in the database (for now) for reference so we have a history of where it went.