Setting linked record does not link properly

[hrdy90]

I'm using the following formula with "Case" entity and Trigger type: After record saved:

$message = (description);

$apartmentidLine = string\match($message, '/LägenhetsID\: (.*)$/m');
$apartmentid = string\substring($apartmentidLine, 13);

realEstatePropertyId = $apartmentid; 

A case description might look like this:

Description:
Test!

LägenhetsID: 644a42027d091dd82

This does add "644a42027d091dd82" in the correct place, but it does not lookup or link correctly. If I update the case manually it does however reapply the link and it works as expected. What am I missing?

[Kharg]

try to also send the name, not only the id

[hrdy90]

But realEstatePropertyId with ID 644a42027d091dd82 already exists with all that information. Clicking the link "644a42027d091dd82" takes me to that object where apartment name and other details already are set.

And updating the case manually makes the link "644a42027d091dd82" become correct "Ramvägen 8, Stockholm". So it does understand the ID 644a42027d091dd82 correctly - it just does not create the link correctly unless I manually update the case record.

[Kharg]

if you check the network tab in developer tools you will see that when you select "Ramvägen 8, Stockholm" the request will both contain the apartment name and the apartment id.

[hrdy90]

You are very correct! I will set realEstatePropertyName manually for now then. But is there no way to work around this? I.E to make it do the lookup after record is updated?

Thank you!

[hrdy90]

Well, I did as you suggested:

$message = (description);

$addressLine = string\match($message, '/Gatuadress\: (.*)$/m');
$address = string\substring($addressLine, 12);

$apartmentidLine = string\match($message, '/LägenhetsID\: (.*)$/m');
$apartmentid = string\substring($apartmentidLine, 13);

realEstatePropertyName = $address;
realEstatePropertyId = $apartmentid;​ 

Case description:

Gatuadress: Ramvägen 8
Beskrivning av felet:
Test!

LägenhetsID: 644a42027d091dd82

But it is unfortunately still only showing as "644a42027d091dd82" unless i manually click edit followed by save somewhere in the case.

[Kharg]

The name has to be the same name of the linked record. Why don't you fetch the name using the record id?

https://docs.espocrm.com/administration/formula/record/#recordattribute

[hrdy90]

Did not know "record\fetch" was possible. Not available for me yet. Just upgraded to v7.4.4. According to the documentation it is/will be available as of v7.5. But yes, great idea - will try to do that instead!

[Kharg]

hrdy90 use record\attribute(ENTITY_TYPE, ID, ATTRIBUTE)