link entity by formula

[hi-ko]

I have an entity 'Revision' with a n:1 relationship with User as 'revisionApprover' and I try to set the approver by formular but can't get it to work. There is a entity\addLinkMultipleId but I need the same for a 1:n relation so I tried record\relate in both directions. I get always 'true' as response but the Revision is not being updated with that userId on the field defined in the relation.

output\printLine(record\relate('Revision', id, 'revisionApprover', $approverId));

Setting the id directly is also not available.

What is the supported way to set a n:1 or 1:n relation by formular?

[lazovic]

Hi hi-ko,

You can use the following formulas:

For Revision:User as N:1 in Revision Formula:

revisionApproverId = 'user-id';

For User:Revision as 1:N in User Formula:

revisionsIds = array\push(revisionsIds, 'revision-id');

Please keep in mind that linking / unlinking records to each other is best tested immediately in the Formula of a particular entity.

[hi-ko]

Why make it simple when it can also be made more complicated?

I read somewhere that setting the id directly is no longer supported and from the fields menu / autocomplete the id field is not offered.

The obvious way, by just assigning the id (still) works ...

Thanks lazovic