The M-Files Community will be updated on Tuesday, April 2, 2024 at 10:00 AM EST / 2:00 PM GMT and the update is expected to last for several hours. The site will be unavailable during this time.

This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Metadata Card - Set Employee property automatically from the creator information

I have a property Employee which uses the built-in list Users.

Now I would like to have that when new object is created, the Employee comes automatically from the creator of the object.

I have added the information into the Metadata card like the information below but it still does not give the value automatically.

Also I have tried the setting where ForceSetValue is true but it does not work either.

What is wrong with this?

{ "Group": "XXX", "Property": "1482", "Priority": 500, "SetValue": { "Mode": "Dynamic", "DynamicValue": "%CURRENT_USER%" }, "ForceSetValue": false }

Parents
  • Hello,

    You need to configure a custom placeholder:

    regards,

    Radu

  • Hi.

    I created the placeholder but it is still not working Disappointed

    Here are my placeholder definitions.

    {
        "Group": "XXX",
        "Property": "1482",
        "Priority": 1000,
        "SetValue": {
            "Mode": "Dynamic",
            "DynamicValue": "%CurrentUserEmployee%"
        },
        "ForceSetValue": false
    }
    
    {
        "Name": "CurrentUserEmployee",
        "ObjectType": "MF.OT.xx",
        "Property": {
            "Property": "MF.PD.yy",
            "Value": {
                "Mode": "Static",
                "TypedValue": {
                    "dataType": "lookup",
                    "value": {
                        "lookup": {
                            "item": {
                                "user": "{BA1BCA7E-026B-4260-9D73-2AE593052F6C}"
                            }
                        }
                    }
                }
            }
        }
    }
    

  • "ObjectType": "MF.OT.xx" - this should be the Employee OT

    "Property": "MF.PD.yy" - this should be the PD that points to the User Account.

    otherwise it looks good. it should work.

Reply Children
  • I added the Employee OT and the User account PD but it still does not work. The username does not come automatically.

    [
        {
            "Name": "CurrentUserEmployee",
            "ObjectType": "103",
            "Property": {
                "Property": "1045",
                "Value": {
                    "Mode": "Static",
                    "TypedValue": {
                        "dataType": "lookup",
                        "value": {
                            "lookup": {
                                "item": {
                                    "user": "{BA1BCA7E-026B-4260-9D73-2AE593052F6C}"
                                }
                            }
                        }
                    }
                }
            }
        }
    ]
    

  • Your destination PD must take information for Employee OT, and should not be directly the username.

    So  "Property": "1482" should be the PD that point to the list of employees and not users.

    If it is like that, and still does not work, I don't know how to guide you further. This works perfectly for me.

    Maybe you have other rules that overwrites this one?