Update boolean field if any related entity dropdown value is ABC

[Marcel]

Hi all,

I have an Entity called Contracts and that has a One to Many relationship to ContractObjects and a many to one relation to customer.

When I now open a contract and create a new relation to a Contract Object where I set the dropdown menu value of a field called usageType to "Owner occupancy" (Or modify the relation) the Boolean field called changOfAddress on the customer Object should be set to true.

Is that somehow possible?

Thanks!

[lazovic]

Hi @Marcel,

Please try to use the following formula script in the Contract Object entity:

if (entity\isAttributeChanged('contractId') && usageType == 'Owner occupancy') {
    $customerId = record\attribute('Contract', contractId, 'customerId');
    record\update('Customer', $customerId, 'changOfAddress', true);
}