Add new Foreign field type WYSWIG

[Russ]

Hey guys, I assume we can't add a foreign field type WYSWIG?

Asking just to make sure I am not missing a point.

Thanks!

[yuri]

Hi, I believe you are right. Here's the full list of support types: https://github.com/espocrm/espocrm/b...reign.json#L21

[Russ]

Hi, I believe you are right. Here's the full list of support types: https://github.com/espocrm/espocrm/b...reign.json#L21

thank you

[victor]

Russ,

There is a pretty good workaround.

For example, we have a Test Wysiwyg field in the Account entity, and we want the data from that field to be passed to the Test Wysiwyg 2 field for the Testevententity (of course, we already have a relationship between Testevententity and Account).

1. We already have a Test Wysiwyg field in Administration > Entity Manager > Account > Fields (screenshot 1).
2. We create Test Wysiwyg 2 field in Administration > Entity Manager > Testevententity > Fields (screenshot 2).
3. In Administration > Entity Manager > Testevententity > Formula > Before Save Custom Script we create a simple formula:

testWysiwyg2 = account.testWysiwyg;

- The Test Wysiwyg field in the Account entity looks like is shown in screenshot 3.
- The Test Wysiwyg 2 field in the Testevententity entity looks like is shown in screenshot 4.

[Russ]

Russ,

There is a pretty good workaround.

For example, we have a Test Wysiwyg field in the Account entity, and we want the data from that field to be passed to the Test Wysiwyg 2 field for the Testevententity (of course, we already have a relationship between Testevententity and Account).

1. We already have a Test Wysiwyg field in Administration > Entity Manager > Account > Fields (screenshot 1).
2. We create Test Wysiwyg 2 field in Administration > Entity Manager > Testevententity > Fields (screenshot 2).
3. In Administration > Entity Manager > Testevententity > Formula > Before Save Custom Script we create a simple formula:

testWysiwyg2 = account.testWysiwyg;

- The Test Wysiwyg field in the Account entity looks like is shown in screenshot 3.
- The Test Wysiwyg 2 field in the Testevententity entity looks like is shown in screenshot 4.

Victor, thanks for this deep explanation with screenshots and text, it helps to understand and try.


However, the actual workaround is not helpful because when let's say account's status is updated, you will still have 300 (example) contacts linked to that account with an outdated field until you will re-save them, or recalculate formulas for all.

Anyways, thank you for your help!

[victor]

Just recalculate formulas for all records in Testevententity. And the Test Wysiwyg 2 field in all newly created records in Testevententity will be filled in automatically, if of course these records have a relationship with Account.

In the case when you need to react to a change in the Account status and only then change the Test Wysiwyg 2 field for the Testevententity, you can use a simple workflow:
1 screenshot - general view of the workflow
2 screenshot - Trigger Type > After record updated and Conditions
3 screenshot - Actions