How to use a foreign property in a MAC policy?

Hi all,

I've tried to convert a foreign property to a string on a Document Item Type as foreign properties aren't compatible with MAC policies, but I'm not getting very far.

The current thinking is:

  1. Create foreign property "input"
  2. Create string property "output"
  3. Write server event OnBeforeAdd to get value of "input", and set value of "output" to the "input" value as a string
    1. something along these lines: Me.setProperty("output",Me.getProperty("input") As String)

Doesn't seem to be returning anything as the "output" property remains blank.

FYI, the foreign property in this instance is a property of created_by_id. Is it something to do with when the creation is actually being registered?

Your help's much appreciated!

Thanks,

RB