Double name columns

I would like to have 2 columns of names in a view. Like names that begin with A thru J in first column and names that begin with K thru Z in the second column. I assume I would use @Left in some type of formula, but I'm not sure how it would be written. Help?
Who is Participating?
CRAKConnect With a Mentor Commented:
Using R6 or up? Perhaps we can fake it:
You could perhaps collect those names in a categorised view where col. 1 =
@If(@Left(Name; 1) < "K"; "First"; "Second")

On a form or a page, you could now create a table, 1 row, 2 cols.
In each of those cells, you embed the view and specify the desired single category, "First" (left) or "Second" (right).

Of course you could do this just as well using 2 different views, without the additional category handling but different selection formulas, based on the names...

Only alternative I can think of is using a computed for display field or computed text, showing the proper set of values retrieved by @Dblookup or @DbColumn....

You are aware that only one document can be shown in a row?

In a 4 document example, following is feasible:
| A |   |
| B |   |
|   | K |
|   | L |

but following (same 4 docs) is not:
| A | K |
| B | L |

I'm afraid the 2nd situation is your objective.....?
If the names field is multi value, we should give that some additional attention: a document COULD require being shown in both columns or views!
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Sjef BosmanGroupware ConsultantCommented:
Notes or Web?
schmad01Author Commented:
Notes client.  Hmm. I have to think about this. Maybe 2 separate views in a split frame?
madheeswarConnect With a Mentor Commented:
But don't you think if a document doesn't have A and have J, then most of the columns will be empty.... it won't look good.

May be you can try having an Embedded view....where, on top, you can place A, B, ....., Z which are Hotspots and on click will set one Field to:
@Command( [RefreshHideFormulas] );

and place an Single category embedded view, and give this field name...

Make sure, your View is sorted and categorized... and have formulae..

@Left(Name; 1)

So.... your view firct column will be categorized as
now, when u click on a Text(which are Hotspots), you are setting the field and refreshing the view.... IN this way, you can display all the documents in a view under that particular Alphabet...

Hope this workaround helps you.

Sjef BosmanGroupware ConsultantCommented:
> I would like to have 2 columns of names in a view...
If that's the solution, what's the underlying problem? Why do you want two columns?
schmad01Author Commented:
I just wanted to have the view printed on one page. I thought 2 columns would accomplish this as opposed to a long single column. The view is a phone list.  Column 1 is name and Column 2 is their extension.
Sjef BosmanGroupware ConsultantCommented:
Printing in two columns... I suppose you could accomplish this using an export to Word or Excel, or with NotesToPaper. Directly from Notes will always be quite messy.
schmad01Author Commented:
I've seen some postings lately mentioning NotesToPaper. What is it? Is it any good? What can be done with it?  expensive?
Any 3rd party will be expensive...

Why can't you export to Word and Print?

or you can use Excel
Sjef BosmanConnect With a Mentor Groupware ConsultantCommented:
It is a very good utility to make superb reports and prints from Notes. See
Not cheap, but if you need high quality printing at a affordable price (to a company).
Steve KnightIT ConsultancyCommented:
Sorry if I've missed this above but how about having a page then with two dblookups in two adjacent table cells


col    name   phone

col is something like @if(@left(name;1)<="K";"1";"2");
and categorise the column

Then first tble cell on page is @dblookup into view for value 1 returning col2 + second dblookup of col 3.

Second table cell same  but lookup  value is 2.

Sorry for not typing full commands out, lots of chars missing from little keyboard on pda...

The above requirement seems for Customer Mgt.,  means.. there will be lots of Contacts which will be stored. In this case, easily, they will hit 64K limit.
Steve KnightConnect With a Mentor IT ConsultancyCommented:
btw he said "I just wanted to have the view printed on one page" so I assumed 64k limit is not an issue.
Sjef BosmanGroupware ConsultantCommented:
If limits are an issue, then don't use dblookup but a script and two rich-text fields.
Hi Netminder,
As PE, I feel that I should point out that we haven't heard from the asker for quite a while. Was there a problem somewhere that we could have helped fixing? Is it solved? If so: how?
Several options were offered by the participating experts and additional info on yet another solution (that was brought in by the asker) was also provided.
In a situation where experts were trying to avoid the infamous "you cannot do that", the motivation "no longer needed" is I.M.O. somewhat of a disappointment!
If I had to make a recommendation as CV, I'd figure out a fair split.....
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.