Working with Views in Lotus 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
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
ASKED:
August 27, 2010 2:53 AM
UPDATED:
August 27, 2010 12:56 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
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