Solved

Adding user_def fields

  • 1 February 2021
  • 7 replies
  • 264 views

Userlevel 4
Badge +7

Hi,

Can anyone please suggest how we can create additional user def fields in FSM.

Suppose I need extra user def fields in task or request table how can we add it in custom metadata without disturbing existing metadata.

Thanks

Ramya

icon

Best answer by PROHARIHP 1 February 2021, 13:27

View original

This topic has been closed for comments

7 replies

Userlevel 2
Badge +6

Hi Ramya,

You can use an Extension table for the FSM metadata tables if you need more columns, for that, you need to create a new table “YOURPRIMARYTABLENAME_EXT” and join that table in Relation def of your Primary table with the relation type as Extension.

Thanks,

Hari

Userlevel 4
Badge +7

Many Thanks @PROHARIHP 

Userlevel 3
Badge +6

Hi Ramya,

 

if the amount of the existing user def fields are not enough, you need to create an extension table.

Example for Request:

Create new Custom Metadata C_Extension_Request1.

After that ,you need to create the relationship.

 

One remark, fields of an extension table will not be displayed on the mobile client. Therefore you might need to change the baisc user def field information with some of the extension table.

Best regards,

Sven 

Userlevel 4
Badge +7

Hi @Sven Paul,

Thanks for the reply,

Can you please provide more details on mobile client part, How the configured new fields in  smart client will be reflected in mobile. 

 

Best Regards,

Ramya

 

Userlevel 3
Badge +6

Hi Ramya,

 

the mobile client can only work with fields from the basic table.

You have two options to reflect the new required field on the mobile client

  1. You need to rearrange the existing fields 
    1. example: you have used an user def field for an special sales number which should be visible on the web client but not necessarily on the mobile client. Then you need to use the user def field from the extension table for this number and so on
  2. You can create a custom table and create a parent relationship table with the request table. Any fields of the custom table can be reflect on the mobile client. But in this case the key field need to be custom key field like an internal automated id

This is by the way the same for an new custom status which should be visible on the mobile device. This will be only visible on the mobile client if the task has been already sent to the mobile client. But not if this is the first assignment to the mobile client.

Hope this helps Ramya :-)

Best regards,

Sven

Userlevel 4
Badge +7

@Sven Paul Thanks for your detailed information.

Userlevel 2
Badge +4

Apart from the limitations for the mobile client, the additional fields added this way are also not useable in sorting/ordering the list view of the primary table.