I had thought that this would be as simple as creating a calculated column and referencing that - but you cannot reference calculated columns without writeback being enabled and you can enable writeback on a calculated column...
So how can I capture username?
Anyone help please - my version is 18.104.22.168.5 - I am sure this used to be easier on version 10...
p.s. Any tips to make the writeback grid look less like a dogs breakfast would also be appreciated, with long columns it is less than attractive...
We have a function in the analytics.
answers-->column fx tab-->functions-->system--->user
It will display the currentuser.
You can also use the session variable USER.
mark if helpful/correct..
yes - I know about both of the variables my question is how can I capture them such that either writeback in the form can pass them to the XML template, or the XML template can reference them directly?
I found a workaround.
As posted originally if you try to add a pure function based column then the write back property disables itself and will not be re-enabled, nor can you reference the column in question in the XML template insert / update statements....
However, if you take the original column and put this logic around it, then it seems to 'fool' the writeback and allow you to use the user variable.
Having done this just hide the column in question and reference in your XML template as before - job done.
case when 1=2 then "My Folder"."My User Name Column" else user() end
Hope this is useful to someone else....