Custom field type like Phone

[krishnapriya]

Hi,

I am trying to create new field type like phone / email(multiple add option).

Do we need to create the relationship table like entity_phone_number at the backend or it is automatically generated with the code?

If automatic, where can I find the code to create table?

Please help.

Thanks.

[tanya]

Hello

application/Espo/Core/Utils/Database/Orm/Fields/Email.php

[krishnapriya]

Hi,

I got the realtion table o rebuild.

Field is visible on create but failed to save values to db.

Giving error => Column not found: 1054 Unknown column 'relationName.name' in 'field list'

[krishnapriya]

Hi,

I copied the same way as application/Espo/Core/Utils/Database/Orm/Fields/Email.php and application/Espo/Core/Utils/Database/Orm/Fields/Phone.php

I that relation emailAddresses need to define in any other files other than application/Espo/Core/Utils/Database/Orm/Fields/Email.php

Confused. Please help.

Thanks.

[tanya]

application/Espo/Repositories/EmailAddress.php storeEntityEmailAddress
and check where does it call

[krishnapriya]

Hi,

Tried to create 2 functions=>

1. handleListItemParams($params)() in handleSelectParams()

2. processListItemSave(Entity $entity) () in afterSave() of RDB for the new field type

Both gives bad server response.
No call reaches storeEntityListItem

Please help.

[krishnapriya]

Hi,

It is working now.

Error was I tried to create them with "notCreatable": false so that they became available in entity manager fields, but giving error on save.
Any way is there to make phone or email field creatable from the entity manager?

Please help.
Thanks.

[tanya]

notCreatable ?
this parameter is used only on client side (client/src/views/admin/field-manager/list.js)
if you want don't create a column, you need to use notStorable

[krishnapriya]

Hello,
What I mean is how can I add phone to Add Field drop down of entity manager? Is that possible?
This was what I tried.

[tanya]

This field is better to add manually. To make field type visible, set "notCreatable": true.
Don't remember the reason, why these fields were hide, but I'm sure, the reason exists. Better don't make these fields visible in the list

[krishnapriya]

Yes Tanya that worked.

[krishnapriya]

But we have to use same name phoneNumber for the field, otherwise it will save only first value in the list.

[krishnapriya]

Hi,
Can we set name of a field automatically by program ?

[tanya]

client/src/views/admin/field-manager/edit.js
search populateDefaults
you can set the name in this area

[krishnapriya]

Thanks tanya. That worked.