WSS, doc libs & listi, Kolonni kkalkulati jinvolvu [Me]

Someone on the Internets was asking about how to create a calculated column on a list that would show a value formatted as "[User] – [Status] – [Post]" as in "Paul Galvin – Xorb [ħielsa] Beer – The Beach".

Paul would go in and update his entry in the list and the calculated column would update appropriately. The [User] għandu default għall-utent jidħol / taġġorna l-lista tal-.

A calculated column cannot use "volatile" funzjonijiet bħall- [Me] jew [Illum]. I solved it in a test environment with these steps:

  1. Create a text column named "Current User".
  2. Issettja valur default tagħha li [Me]
  3. Create a calculated column called "Calc Test".
  4. Issettja l-valur tagħha = [User attwali]

I marru fil-, Żied punt mal-lista u maħduma.

9 ħsibijiet dwar "WSS, doc libs & listi, Kolonni kkalkulati jinvolvu [Me]

  1. Richard Harbridge

    Hello Paul,

    Mingħajr ma noqgħod naħseb li inti biss dehret mod biex tikseb madwar InfoPath / SharePoint kwistjoni serja I ġew jkollhom.

    Bażikament I jistgħu jiksbu l-dominju username tal-utenti iżda mbagħad ma tistax tuża [Me] filtri u l-funzjonalità oħra SharePoint qawwija. Iżda bl-użu xi ħaġa bħal din, għandha taħdem madwar din il-kwistjoni, billi jippermettu lili biex iqabblu żewġ kolonni test (linja waħda) minflok in-nies u gruppi kolonna.

    Ħin li jipprova hu.

    Grazzi,
    Richard Harbridge

  2. Christophe Humbert
    Am I xi ħaġa nieqsa? Eżempju tiegħek turi l-isem l-utent fil-ċar ("Paul Galvin"), iżda meta I ttestjati dan I attwalment jiksbu l-login (li b'xi mod tkisser il-għan, as announcing that "DOMAIN\username is drinking a beer" doesn’t sound that cool…).
  3. Ebda isem
    Hello.
    Jien jippruvaw jużaw mistoqsija CAML kontra s-servizzi tal-web Sharepoint sabiex jiffiltraw l-oġġetti modifikati mill [Me] u xi għażliet oħra. Taf kif għandek tagħmel dan minħabba I ma sabu xejn s'issa?.
    I’ve tried GetListItems with the filtering query and a view that has a filter with Modified By = [Me], iżda l-fehma hija injorata meta jużaw query.
    Grazzi.
  4. Patrick Rote
    Jien għamilt tirck Paul tiegħek.
    Imma meta i tara l-lista i ara biss [Me] u mhux username tiegħi.
    Meta i ħoloq il-kolonna kkalkulata i stabbilit li [User attwali] permezz tal-formula buttuna żid.
    Huwa dak id-dritt?
    Let me know
    Grazzi
  5. Paul Galvin
    Sfortunatament, I don’t see any way to do that without writing an event handler. Even If change the presentation of the "Person or Group" to simple "Name" (as opposed to the more complex "Name with Presense") għadu ma tintlaqax.
    –Paul Galvin
  6. Drew

    Paul,
    Thank you for that solution. It worked great. Expanding on your solution, kieku għandek xi idea kif jitwaqqfu test calc = User kurrenti jekk inti tixtieq utent attwali li jkunu qasam Picker Nies ma 'nies biss magħżula?

    Grazzi għal darb'oħra.

    Drew

Ħalli Irrispondi

Your email address mhux se jkun ippubblikat. Meħtieġa oqsma huma mmarkati *