People commonly ask about using a column of data type "Person or Group" in another column of data type "Calculated".
Bottom line, hii haina kazi katika WSS 3.0 (au MOSS).
Wakati kuongeza safu ya mahesabu, WSS shows the list of fields it allows you to use for the calculation. If you type in the name of a column that is not in its list, ni atakwambia:
Marejeo safu moja au zaidi hawaruhusiwi, kwa sababu nguzo hufafanuliwa kama aina data kwamba si mkono katika formula.
Workaround: Use an event handler. The event handler fires when the user saves the item. It performs the update you would have wanted the calculated column to do for you.
Muhimu viungo kwenye mashamba mahesabu kwa ujumla:
- Kutumia [Mimi] katika safu ya mahesabu
- Mifano ya maneno formula (hisani ya http://jopx.blogspot.com/2007/10/calculated-fields-in-windows-sharepoint.html)
Haraka Kanusho: Naamini hapo juu kuwa ni kweli na sahihi, lakini nimeona tricks wajanja kutosha hapa na pale katika MOSS / WSS kwamba mimi bila kuwa na kushangazwa sana (agog kama wewe) if someone has figured out a way to do this without resorting to code. If you’ve figured out clever work-around or know someone that did, tafadhali napenda kujua!
Nini kuhusu kutumia workflow na SharePoint designer? I could put person or column of data type "Person of Group" katika safu na workflow. Kama unataka kupata taarifa zaidi kuhusu hii, tafadhali tuma barua pepe yangu. 🙂
hojun00.kim@samsung.com
Hii ni ajabu kabisa — kuwa na uwezo wa kuhesabu au kuendesha mtu habari katika safu ya mahesabu itakuwa muhimu kabisa, na ni disappoint kuona kazi alipendekeza kuwa karibu kupelekwa kwa kanuni na desturi. Natumaini hii ni iliyopita katika toleo la pili ya Sharepoint.
Asante kwa habari, Paulo!
http://blogs.msdn.com/brianwilson/archive/2007/03/05/part-1-event-handlers-everything-you-need-to-know-about-microsoft-office-sharepoint-portal-server-moss-event-handlers.aspx