Outlook Custom Form Field Not Updating

Hi, AWSA.

How is the value of the State field calculated?

That should be Stage not State.

Right now I am using a simple "if-then" type function.  I have also used the Choose function.

Below is the function:

IIf( [Department]="1", "1-Executive", IIf( [Department]="2", "2-Legal", IIf( [Department]="3", "3-Marketing", IIf( [Department]="4", "4-Sales","Need Stage"))))

And where is this function at?  Is it in the set initial value of the field?

I have the function in the "Stage Field"

I am not clean on what you mean by is it in the set initial value of the field...what does this mean?

Yes you are correct the function is located in the "Set Initial value of the field".

Where should the function be located.  If you use the validation function it will tell you that there is an error when you change the entry from a "2" to a "3".

Any comments appreciated....

Which radio button is selected: Calculate when compose, or Calculate automatically?

Calculate automatically

I assume that Department is user-defined field that exists in the folder.  Is that correct?

Department is not a user defined field.  It is the Department field from the Contact Fields list.

Sorry about not being able to respond back earlier today.  I should be here for the rest of the afternoon.

Oh, then this is a custom contact form, not a custom email.  Is that correct?

Correct, this is a custom contact form.

BlueDevilFan was very responive and brought the solution down to a level that I could understand.

Thanks.  Glad I could help.

Can you give me some idea about how the Experts Exchange works?  I am a "novice" that is trying to tweak my outlook system and came across Experts Exchange that had an answer to one of my questions so I signed up.

How do you get paid?
Why wouldn't I always give the full 500 pt each time I had a question?

Any comments appreciated.....

Sure. EE is a community of volunteers.  The experts don't get paid, other than an occasional t-shirt for achieving various ranks (point levels).  Beyond that we get free access to ask our own questions.  Anyone can start answering questions and eliminate the need for a paid membership.  All you need is to be well versed in one of the many topic areas on the site.  Once you achieve 10,000 points you're considered an expert and can ask questions at no charge.  You then have to maintain your expertise by answering 3,000 - 4,000 (can't remember the exact value) points worth of questions per month.  I joined because I had a few questions I wanted to ask and answering questions struck me as a fair trade.

The point value you assign to a question is supposed to be a reflection of how difficult you believe the question is and how fast you want an answer.  It used to be that memberships had a limited number of points per month, so a 500 point question represented something the asker thought was very difficult or that they wanted an answer to quickly.  Experts used to jump on a 500 point question because they were somewhat rare.  Now that there are unlimited points per month a lot of people do just assign 500 points to everything.  It's purely up to the question's author.  Most of the experts are more interested in the questions than the point value, although they may complain a bit if the question is hard or will take a lot of time to answer and the point value is very low.  I've seen some fairly complex questions that they author was only offering 50 points for.  Those typically don't get answered.  

Do you ever get in a situation where you end up calling someone on the phone to discuss the issue.  It would seem that would be ealser in some instances?

There's currently no provision for that and working on an EE question outside of EE is officially prohibited by EE's rules although I suspect it does occur sometimes.  The reason for the prohibition is that other experts, i.e. the ones that didn't get on the phone with the asker, would be at a disadvantage and a phone conversation wouldn't be memorialized on the site making it more difficult for someone who finds and reads the question later to figure out what was done to solve the issue.  EE has added the ability to do a screencast and has discussed adding a remote support feature (e.g. like VNC).  A remote control capability could potentially include a voice chat capability.  EE might be okay with a voice chat if one of the parties recorded the conversation and uploaded it to the question.  EE's concern is to make a level playing field for anyone who wants to work on a question and to enure that the details are recorded for anyone who reads the question later.

So when I completed my question with your answer there was a box that indicated whether the dialogue could be published and I unchecked the box.  Does that mean the question and response will not be available for all to see?

I'm not sure what that box is for.  The question should be visible to everyone on EE.

Thank you very much for your assistance.  You made a difference today for me by answering my questions.  Have a great evening.

You're welcome!  Glad I could help out.  Thanks, you too.

BlueDevilFan,

I have another question and I know  you can asnwer this one.

I have a custom contact form.  I have some values that are calculated in the form and I want to put those values into one field.  For example I calculate a value for A, B & C with formulas.  I want to take the values for A, B & C and put them into one text field called Summary the will read as follows:

Value for A = (the calculated amount)
Value for B = (the calculated amount)
Value for C = (the calcuated amount)

The problem is that when I put a referenced to a caluculated field in the Summary field the values do not get updated.

Any thoughts?  Do I need to start a new question?

Yes, please start another question.  I'll watch for it.

I just started another question under the following name:

"Displaying Formula Values in Custom Contact Forms".