Display logo on other entity ??

[abidoss]

I have a custom entity called "Partner" that contains multiple companies, and each company has a logo field of type (image). Is it possible to display the logo/image in another custom entity called "Direction"? I tried adding a foreign key field, but the logo field doesn't appear in the selection

[espcrm]

It is possible, which is viewable in the Relationship Bottom Panel. I use it for my Account > Contact. I haven't use Foreign key yet though.

Maybe someone else can understand what you trying to achieve.

[item]

Hi,
what kind of relation have you between Partner and Direction
i don’t know if foreign field work for image.. must check on github

i think you can achieve this with formula, create a same field in Direction, and set value with same value of Partner.
image field is just a ID if a attachement. (certainly)

[abidoss]

One-to-One Right

[item]

Hi Rabii,

just tested and work like a charm.. every day i am suprised with the power of espoCrm.

[abidoss]

can you help me then ?

[rabii]

you will need to create your own custom field and then another custom field (link) to display the company with its logo on the direction entity.

[abidoss]

The custom field in the "Partner" entity has already been created with the type "image". But what type of custom field should I use for the "Direction" entity?

[rabii]

i meant a custom field (new field) that will use views/fields/image field should implement an upload and an entryPoint to display the field and after that you will need to create a custom link to display the logo near the link name.

[item]

Hi,

create same "type" of field.. i have choose "image" .. same "name" i have choose picture, you choose logo...
just write this in direction entity formula.


pictureId = partner.pictureId;


it's all

You just need to disable "picture/logo" in detail view edit.. make this field conditionnaly read-only.
There i have see maybe a feature request :
why we can put conditianaly read-only field image.. but not in option


Hope Yuri don't see a "design/conception leak".. for me is wonderfull

[espcrm]

Very cool idea using field ID. This way it doesn't duplicate the file.

[rabii]

i think it does duplicate the file. i picture will create a new attachment.

[abidoss]

thank you very much sir

[item]

Hi rabii,
don't see anithing bad, you help many and i use many your tips or code you post.. i will be happy to partage my "little skill"

there are nothing duplicate with this.
all file you uploade is a attachment, with entityType, entityId... if you make a print-to-pdf, it create a attachment.. then you can "download" this, if you do a "export xlsx", it create a attachement, and de download link is the attachementId.

there are 2 direction :

entity -> attachement
attachment -> entity.

in this case,
Partner have uploaded the Picture.. then there are a attachement : entityType = Partner, entityId=?
if i go attachment.. i can see => entityType = Partner.

the solution here.

Direction.. just "point" to the attachementId of Partner.
No duplicate.
it's like a "C++ pointer" .. oufff old learned programming language in school

Just need, if partner->pictureId change... you must update Direction->pictureId and this is possible with Advanced Pack. (but this is the behaviour of all formula without Advanced Pack or custom code)

[espcrm]

You can call me coding master now rabii!

> Very cool idea using field ID. This way it doesn't duplicate the file.

[espcrm]

I finally remember an use for this idea now. I'm currently have "Parent" Account for branch/department. With this trick I should be able to save having duplicate image.

[rabii]

item if partner is deleted then formula should help. something like below:

```

ifThen(!partnerId && pictureId,
record\update('Attachmnet', pictureId, 'deleted', true);
entity\setAttribute('pictureId', null);
)

```

This way crm will check if we have a pictureId and no partner then delete the attachment.

[espcrm]

Here the code I end up using, nothing fancy:

ifThenElse(accountParent.accountsIds==null, , companyLogoId=accountParent.companyLogoId)

Interesting rabii show off his skill, he using "!partnerId" which seem to function the same as ==null?

Being fancy as him I copy, here update.

ifThenElse(
!accountParent.accountsIds && !companyLogoId && accountParent.agreementsIds=='someIDforspecialaccount' &&, , companyLogoId=accountParent.companyLogoId)​

Running into many bug and the final code.

ifThen(
accountParentId!=null && companyLogoId==null && accountParentId!='special_ID_of_Parent', companyLogoId=accountParent.companyLogoId)​

[espcrm]

Now I'm updating all my 'branch' Account so logo will shared. The question is...

My old attachment/logo, does it get delete during some CRON cleanup operation? Or will I have a bunch of 'orphan' photo?