Sort Names in a Form

HCL Domino Domino Forum
1

Hello

I have following question:

I have a view with sorted user names.

I have a form which takes those names (@DbLookup) and adds them into different fields so I get a actuel form with all the users. I use a keyfield to get those names.

ex. Key 1 gets name 1 into field 1.

I could not find a way in formul language to say put first name in this view into field 1, second name into field 2.

I guess it can be done in scripts… anyway an idea?

Thxs for helping me out!

Mark

2

Subject: Sort Names in a Form

I think it can be done by use iterative statements , like @DoWhile, @While and @For. Look in DD help for details.

Konrad

3

Subject: RE: Sort Names in a Form

I am checking this.

Do you know something like:

  • Goto first line ; @Setfield(x1 ; thisentry)

  • Goto next line ; @Sefield(x2 ; thisentry)

and so on…

4

Subject: RE: Sort Names in a Form

There isn’t Goto statement in @Formula.I’m not sure if I understand good what do you want to achieve, but maybe that helps:

Users:=@DBLookup(…);

@For(n := 1; n <= @Elements(Users);

n := n + 1;

@SetField( “Field” + @Text(n); Users[n] ) ;

Konrad

5

Subject: Sort Names in a Form

HiSince release 6 there is a formula available called @Sort. Maybe this helps.

:slight_smile: