Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

Using column value in another column

I have a categ column which can contian multiple values - An array of assignee and delegate.

I would like to create another category, grouping the documents as assigned or delegated (amongst other groups)

To do this, I need to know, what the respective value is in the previous categ column.

Found some info re programmatic use name - but can't figure out how it fits it..

please help!!

Any alternative is welcome.
0
miklesw
Asked:
miklesw
  • 5
  • 3
  • 3
  • +2
3 Solutions
 
mbonaciCommented:
0
 
mikleswAuthor Commented:
not sure i understood how this fits it..

$Column1
-----------------------
@Explode(@Name([CN];AssignedTo) +@If(@IsAvailable(Delegate); +"~" + @Name([CN];Delegate);"");"~")

$Column2
@If(Handback="1";"Handback";@If(Assignedto=$column1;"Assigned";"Delegated"))



So basically i want:


Michael
0
 
mbonaciCommented:
you want Michael :)
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
mikleswAuthor Commented:
sorry hit submit by mistake

Michael
   Assigned
         call1
   Delegated
         call2
Marco
   Assigned
         call 2
   Delegated
         Call 1


0
 
mbonaciCommented:
miklesw,
sorry, Sjef or Maryling will provide you an answer, I didn't participated in that question and don't have time to study the thread now.

Marko
0
 
mikleswAuthor Commented:
k tnx
0
 
cezarFCommented:
possible for colunms with single value not with multi-value.  had the same prob before --> http:Q_21586969.html
0
 
mikleswAuthor Commented:
I gave up.. i'm jsut going to have 2 embedded views

0
 
Sjef BosmanGroupware ConsultantCommented:
Hi miklesw,

Sorry, I don't read questions a second time. If I see a "good" reference and there seems to be little I can contribute, I move to the next question.

Did you really give up, or do you still want your solution? I'm not saying it can be done, but I don't mind to try with you.

The view you want is:
> Michael
>    Assigned
            call1
>    Delegated
            call2
> Marco
>    Assigned
            call 2
>    Delegated
            call 1


Cheers!
0
 
Sjef BosmanGroupware ConsultantCommented:
Now I hit Submit too early...

Possible solution is without categorization:

First column, hidden, sorted ascending, show multiple values as separate entries:
    a:= @Name([CN];AssignedTo);
    d:= @Name([CN];Delegate);
    @If(a!=""; a + "|Assigned"; ""): @If(d!=""; d + "|Delegate"; "")
Second, not sorted, show multiple values as separate entries:
    @Left($Column1; "|")
Third, not sorted, show multiple values as separate entries:
    @Right($Column1; "|")
Fourth column:
    CallName

I can't get it to categorize properly, I'm sorry
0
 
marilyngCommented:
Mike, can you include a sample of field names relative to the view:

Michael
   Assigned
         call1
   Delegated
         call2
Marco
   Assigned
         call 2
   Delegated
         Call 1

Is Michale field = name, single value?  for instance?
0
 
mikleswAuthor Commented:
I am working ok with the embedded views .. but i'm willing to give it a shot..

Assignedto = "Michael"(single value names)
Delegate = "Marilyn" (single value names)
ProblemSummary = "My mouse is not working" (text)

Assignedto = "marilyn" (single value names)
Delegate = "" (single value names)
ProblemSummary = "can't print" (text)

Assignedto = "marilyn" (single value names)
Delegate = "Michael" (single value names)
ProblemSummary = "call1" (text)



0
 
marilyngCommented:
So, sorry.. forgot this was here.  The examples in the previous question, are these on ONE form, or three different forms.

Ok, here's your solution :)

On your form create two computed fields at the bottom, text,allow multiple values, separate all by new line.
First Field: "AssignedList"  formula: @If(AssignedTo !="";AssignedTo + "|" + Problem;"")
Second Field: "DelegatedList"  formula: @If(Delegated!="";Delegated + "|" + Problem;"")

Ok, then your view.  Two Columns.
First Column, Sorted, Ascending, Categorized.
Formula:
AL:=@Word(AssignedList;"|";1) + "\\" + "Assigned";
DL:=@Word(DelegatedList;"|";1) + "\\" + "Delegated";
AL:DL


Second Column, sorted, ascending.
Formula:

AL:=@Word(AssignedList;"|";2) ;
DL:=@Word(DelegatedList;"|";2);
@Trim(@Unique(AL:DL))

viola!  Can't believe I got this on the first try... hmmm.. was too simple, so it must not be the solution... hmmmm...
0
 
Sjef BosmanGroupware ConsultantCommented:
Viola? What viola? Da gamba? Please look at http://www.vdgsa.org/

*grin*
0
 
marilyngCommented:
aw, stuff it.    typo.   voilà?  making me look up my extended keyboard characters, too.

At least I don't pepper my responses with anagrams and cellphone instant-messenging-speak.   Honestly, I have to re-read stuff that goes: u r ok,
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 5
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now