Working with Views in Lotus Notes Designer

90 pts.
Tags:
Lotus developers
Lotus development
Lotus Notes
Lotus Notes View
Notes Designer
Hi,

I have two forms with two views. That needs to access data from one another.

I have a view that has been categorized and computes the total value per data. My problem now is, on a separate view, I need to extract the subtotals from view #1.

For Example;

On View #1, I have columns named Country (C1), State/City (SC) and Population (P1). So I have multiple State/City that are categorized by Country.

On View #2, I have columns named Country (C2) (different field name from View #1) and Population 2009 (P2).

Now I need to get the total from View #1 per Country. That needs to appear side by side on the same level as View #2 and do subtraction on the 3rd column. I can't seem to rack my brain how to do it. Since I'm using two different forms.

Sample View:

View #1 (taken from Form #1)

[table border="0" width="357" cellpadding="0" cellspacing="0" style="width: 268pt; border-collapse: collapse;"> [colgroup][col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;">[/cOLIST][col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;">[/cOLIST][col width="25" style="width: 19pt; mso-width-source: userset; mso-width-alt: 914;">[/cOLIST][col width="184" style="width: 138pt; mso-width-source: userset; mso-width-alt: 6729;">[/cOLIST][/colgroup] [tbody] [tr height="20" style="height: 15pt;"> [td height="20" width="77" style="width: 58pt; height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl65">[strong]C1[/strong][/td] [td width="71" style="width: 53pt; background-color: transparent; border: #f0f0f0;" class="xl65">[strong]SC[/strong][/td] [td width="25" style="width: 19pt; background-color: transparent; border: #f0f0f0;" class="xl65">[strong]P1[/strong][/td] [td width="184" style="width: 138pt; background-color: transparent; border: #f0f0f0;" class="xl66">[strong][/strong][/td] [/tr] [tr height="20" style="height: 15pt;"> [td height="20" style="height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl66">Japan[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">Tokyo[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">100[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">[/td] [/tr] [tr height="20" style="height: 15pt;"> [td height="20" style="height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl66">[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">Kyoto[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">150[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">[/td] [/tr] [tr height="20" style="height: 15pt;"> [td height="20" style="height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl66">[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">Yokohama[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">200[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">[/td] [/tr] [tr height="20" style="height: 15pt;"> [td height="20" style="height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl66">[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">450[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">(total computed by Lotus Notes)[/td] [/tr] [tr height="20" style="height: 15pt;"> [td height="20" style="height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl66">Philippines[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">Manila[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">100[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">[/td] [/tr] [tr height="20" style="height: 15pt;"> [td height="20" style="height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl66">[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">Cebu[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">200[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">[/td] [/tr] [tr height="20" style="height: 15pt;"> [td height="20" style="height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl66">[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">300[/td] [td style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">(total computed by Lotus Notes)[/td] [/tr] [/tbody] [/table] View #2 (taken from Form #2, except Population 2010) 

[table border="0" width="198" cellpadding="0" cellspacing="0" style="width: 149pt; border-collapse: collapse;"> [colgroup][col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;">[/cOLIST][col width="64" span="2" style="width: 48pt;">[/cOLIST][/colgroup] [tbody] [tr height="20" style="height: 15pt;"> [td height="20" width="70" style="width: 53pt; height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl65">[strong]C2    [/strong][/td] [td width="64" style="width: 48pt; background-color: transparent; border: #f0f0f0;" class="xl65">[strong][/strong][/td] [td width="64" style="width: 48pt; background-color: transparent; border: #f0f0f0;" class="xl65">[strong]P2          P1[/strong][/td] [/tr] [tr height="20" style="height: 15pt;"> [td height="20" style="height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl66">Japan[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">200[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">450[/td] [/tr] [tr height="20" style="height: 15pt;"> [td height="20" style="height: 15pt; background-color: transparent; border: #f0f0f0;" class="xl66">Philippines[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">200[/td] [td align="right" style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent" class="xl66">300[/td] [/tr] [/tbody] [/table] Hope you guys can help me. I'm a newbie in this. Thanks in advance!



Software/Hardware used:
Lotus Notes Designer

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • jane0323
    Sample View: View #1 (taken from Form #1) Country State Population 2010 Japan Tokyo 100 Kyoto 150 Yokohama 200 450 (total computed by Lotus Notes) Philippines Manila 100 Cebu 200 300 (total computed by Lotus Notes) View #2 (taken from Form #2, except Population 2010) Country P2 P1 Japan 200 450 Philippines 200 300
    90 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following