Doing math in contact forms

[Walter Bianchi]

I have a contact form that contains various financial data about my
customers. Is there a way to set up a field to contain the total of, say, the
husband's income and the wife's income? Both incomes are separately entered
as currency and I would like to see a total calculated automatically.

Thanks,

Walter

 

[Sue Mosher [MVP-Outlook]]

Use a field with a formula like:

[His Income] + [Her Income]

 

[Walter Bianchi]

Thanks, Sue ... worked like a charm.

A follow up please:

I am trying to calculate the monthly principal and interest payment given
inputs of the loan amount, the loan term and the interest rate.

The financial functions include one as follows:

pmt(rate, nper, pv, fv, due)

Since only the first three variables are needed to calculate the amortizing
monthly payment, what do I do with the last 2 variables? I have tried setting
them to zero in the formula and this did not work.

Thanks,

Walter

Use a field with a formula like:

[His Income] + [Her Income]

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

I have a contact form that contains various financial data about my
customers. Is there a way to set up a field to contain the total of, say, the
husband's income and the wife's income? Both incomes are separately entered
as currency and I would like to see a total calculated automatically.

Thanks,

Walter

 

[Sue Mosher [MVP-Outlook]]

Have you tried just omitting them? Values of 0 should also work. If they don't, maybe the problem is with one of the other terms.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

Thanks, Sue ... worked like a charm.

A follow up please:

I am trying to calculate the monthly principal and interest payment given
inputs of the loan amount, the loan term and the interest rate.

The financial functions include one as follows:

pmt(rate, nper, pv, fv, due)

Since only the first three variables are needed to calculate the amortizing
monthly payment, what do I do with the last 2 variables? I have tried setting
them to zero in the formula and this did not work.

Thanks,

Walter

Use a field with a formula like:

[His Income] + [Her Income]

I have a contact form that contains various financial data about my
customers. Is there a way to set up a field to contain the total of, say, the
husband's income and the wife's income? Both incomes are separately entered
as currency and I would like to see a total calculated automatically.

Thanks,

Walter

 

[Walter Bianchi]

Thanks Sue ... got it working.

I followed the instructions and published the form (after first creating an
additional contacts folder in which this form will be applicable).

How can I use this form in the main Contacts folder?

Walter

Have you tried just omitting them? Values of 0 should also work. If they don't, maybe the problem is with one of the other terms.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

Thanks, Sue ... worked like a charm.

A follow up please:

I am trying to calculate the monthly principal and interest payment given
inputs of the loan amount, the loan term and the interest rate.

The financial functions include one as follows:

pmt(rate, nper, pv, fv, due)

Since only the first three variables are needed to calculate the amortizing
monthly payment, what do I do with the last 2 variables? I have tried setting
them to zero in the formula and this did not work.

Thanks,

Walter

Use a field with a formula like:

[His Income] + [Her Income]

I have a contact form that contains various financial data about my
customers. Is there a way to set up a field to contain the total of, say, the
husband's income and the wife's income? Both incomes are separately entered
as currency and I would like to see a total calculated automatically.

Thanks,

Walter

 

[Sue Mosher [MVP-Outlook]]

EIther publish it to the main Contacts folder or to your Personal Forms library.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

Thanks Sue ... got it working.

I followed the instructions and published the form (after first creating an
additional contacts folder in which this form will be applicable).

How can I use this form in the main Contacts folder?

Walter

Have you tried just omitting them? Values of 0 should also work. If they don't, maybe the problem is with one of the other terms.

Thanks, Sue ... worked like a charm.

A follow up please:

I am trying to calculate the monthly principal and interest payment given
inputs of the loan amount, the loan term and the interest rate.

The financial functions include one as follows:

pmt(rate, nper, pv, fv, due)

Since only the first three variables are needed to calculate the amortizing
monthly payment, what do I do with the last 2 variables? I have tried setting
them to zero in the formula and this did not work.

Thanks,

Walter

:

Use a field with a formula like:

[His Income] + [Her Income]

I have a contact form that contains various financial data about my
customers. Is there a way to set up a field to contain the total of, say, the
husband's income and the wife's income? Both incomes are separately entered
as currency and I would like to see a total calculated automatically.

Thanks,

Walter

 

[Walter Bianchi]

yes, I did that and when I open a new contact form the new tab is there, as
expected. However, when I open an existing contact the new tab is still
missing.

Walter

EIther publish it to the main Contacts folder or to your Personal Forms library.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

Thanks Sue ... got it working.

I followed the instructions and published the form (after first creating an
additional contacts folder in which this form will be applicable).

How can I use this form in the main Contacts folder?

Walter

Have you tried just omitting them? Values of 0 should also work. If they don't, maybe the problem is with one of the other terms.

Thanks, Sue ... worked like a charm.

A follow up please:

I am trying to calculate the monthly principal and interest payment given
inputs of the loan amount, the loan term and the interest rate.

The financial functions include one as follows:

pmt(rate, nper, pv, fv, due)

Since only the first three variables are needed to calculate the amortizing
monthly payment, what do I do with the last 2 variables? I have tried setting
them to zero in the formula and this did not work.

Thanks,

Walter

:

Use a field with a formula like:

[His Income] + [Her Income]


I have a contact form that contains various financial data about my
customers. Is there a way to set up a field to contain the total of, say, the
husband's income and the wife's income? Both incomes are separately entered
as currency and I would like to see a total calculated automatically.

Thanks,

Walter

 

[Sue Mosher [MVP-Outlook]]

To change existing items so that they display using a published custom message form, you need to change the value of the MessageClass property on each item so that it points to the published form's class, e.g. IPM.Contact.MyForm. The page at http://www.outlookcode.com/article.aspx?id=39 has links to scripts and tools to do this.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

yes, I did that and when I open a new contact form the new tab is there, as
expected. However, when I open an existing contact the new tab is still
missing.

Walter

EIther publish it to the main Contacts folder or to your Personal Forms library.

Thanks Sue ... got it working.

I followed the instructions and published the form (after first creating an
additional contacts folder in which this form will be applicable).

How can I use this form in the main Contacts folder?

Walter

:

Have you tried just omitting them? Values of 0 should also work. If they don't, maybe the problem is with one of the other terms.

Thanks, Sue ... worked like a charm.

A follow up please:

I am trying to calculate the monthly principal and interest payment given
inputs of the loan amount, the loan term and the interest rate.

The financial functions include one as follows:

pmt(rate, nper, pv, fv, due)

Since only the first three variables are needed to calculate the amortizing
monthly payment, what do I do with the last 2 variables? I have tried setting
them to zero in the formula and this did not work.

Thanks,

Walter

:

Use a field with a formula like:

[His Income] + [Her Income]


I have a contact form that contains various financial data about my
customers. Is there a way to set up a field to contain the total of, say, the
husband's income and the wife's income? Both incomes are separately entered
as currency and I would like to see a total calculated automatically.

Thanks,

Walter