Need to add column

[Community Alums]

Hi all,

We got one requirement we need to add one field in list view which is not part of that table is it possible?

if yes can anyone provide me the solution?

In above scenario the table in screenshot is sysapproval_approver table &  we need add the field author  which is not in sysapproval_approver table currently it is in kb_knowledge table  is it possible to add that field in sysapproval_approver table.

Thanks

[Sankar N]

you want to add the "author" field from the "kb_knowledge" table to the "sysapproval_approver" table. Here are the high-level steps you can follow to achieve this:

1. Create a new reference field on the "sysapproval_approver" table that references the "kb_knowledge" table. This can be done by navigating to "sys_dictionary" table and creating a new field of type "Reference" with the "kb_knowledge" table as the "Reference" table.

2. Create a new field on the "sysapproval_approver" table that displays the value of the "author" field from the "kb_knowledge" table. This can be done by creating a new field of type "Formula" with the following formula:

   current.kb_knowledge.author

   This formula assumes that the reference field created in step 1 has the name "kb_knowledge".

3. Add the new field to the list view by modifying the list view configuration. This can be done by navigating to the list view for the "sysapproval_approver" table, clicking on the gear icon in the top right corner, and selecting "Configure > List Layout". From there, you can add the new field to the list view by dragging it from the "Available" column to the "Selected" column.

Once these steps are complete, the "author" field from the "kb_knowledge" table should be displayed in the list view for the "sysapproval_approver" table.

[Community Alums]

Hi @Sankar N ,

I have tried the solution it is not working can you give some screenshot how to create "formula" for the filed created

Thanks

[Sankar N]

Can you please below steps to add the "Author" field from the "kb_knowledge" table to the "sysapproval_approver" table list view,

1. Open the "sysapproval_approver" list view that you want to modify.
2. Click on the gear icon in the top right corner and select "Configure".
3. In the "Configure List Layout" form, scroll down to the "Related Lists" section.
4. Click on "New" to create a new related list.
5. In the "New Related List" form, fill out the following fields:
   • Related List: "kb_knowledge" (the table containing the "Author" field)
   • List Title: "Knowledge Article"
   • List Field: "Author" (the field you want to add to the list view)
6. Click on "Submit" to save the related list.
7. In the "Configure List Layout" form, drag and drop the new related list to the desired location on the list view.
8. Click on "Save" to save the changes to the list view.

After completing these steps, the "Author" field from the "kb_knowledge" table should be displayed as a related list on the "sysapproval_approver" table list view.

[Albert Joy]

Hello Pavithra813,

I believe this is a scenario where you could use reference fields and perform dot-walking for this field in list view to display what you are looking for.

Please try the steps below and let me know if it helps.

1. Create a new reference field in the sysapproval_approver table. (Use 'type' as 'Reference'). 
2. Name it KB Author or something meaningful. 
3. Use table 'kb_knowledge' in the 'Reference' option in 'Reference specification' tab while creating this new field. So new field referencing the Knowledge table. Save it.
4. Now go to 'Layout list' in your sysapproval_approver table. 
5. Select the correct list View name in which you want to display this column.
6. Now click the newly created reference field. There should be a [+] next to it. Click the 'expand selected reference field' button.
7. Now select 'Author' from the displayed list and add it to the right side 'Selected' columns list. Make sure to place it where you want to display it. Then click Save.
   Now if you go to the table list view and use the view name that we just edited, it should display the column as KB Author.author. Im unsure how you will be using it in your organization but this would work in this case. 

Please mark it as the solution if it works out for you!