Scoped Application custom table formatter help

Moedeb
Tera Guru

I have a new scoped app, with a custom parent table that is extended to an incident like table.

For example:

Table1 (make extensible = true)

Table 2 (extends table = Table1)

 

There is no interaction/relationship to the Task table at all.

 

I have an Additional Comments and Work Notes fields and have added the Activities formatter, however when a comment or note is added they do not at all appear in the activities formatter.

 

This is my first time trying this stuff, so would someone be able to assist with this please? I will need pretty clear instructions.

2 ACCEPTED SOLUTIONS

@Moedeb 

the table and the fields needs to be audited.

is that enabled?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

Moedeb
Tera Guru

Ultimately I have found that if I add the Additional comments and Work Notes fields with the same name as the OOTB fields 'comments' and 'work_notes' then I can use the OOTB activity formatter and it works exactly as wanted / expected.

View solution in original post

10 REPLIES 10

@Moedeb 

to enable auditing at table go to the Collection type dictionary entry and click Audit checkbox

AnkurBawiskar_0-1767940574259.png

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Thank you.

I have now made sure that audit is turned on for everything and still does not show anything in the new formatter that was created

@Moedeb 

did you clear instance cache using cache.do and then logout and login and then add some comments or work notes?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ankur Bawiskar
Tera Patron

@Moedeb 

Ensure both the fields are of type Journal Input and not Journal

I was able to show OOTB Activities Filter in form view and it started showing me activity log for my custom table which is not task extended

Only enabled Audit on table and not fields

see below outcome

AnkurBawiskar_0-1767949923320.png

 

custom non task extended table activity log.gif

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Moedeb
Tera Guru

 

Ok, So I've cleared the cache, checked the field types and as you can see below they are both Journal input

 

Moedeb_0-1768172594545.png

 

Also here are some screen shots of what I have done in following the steps that were outlined, if you can see anything incorrect, please let me know.

 

  1. Navigate to System UI > Formatters.
    1. Click New.
    2. Enter a name for the formatter, such as Activities (task).
    3. Select a Table.
    4. Enter xmlin the Formatter field.
    5. Leave the Type as Formatter.
    6. Click Submit.

 

 

Moedeb_5-1768172754998.png

 

  1. Open the form on which the new formatter should appear.
    1. Right-click the form header and select the appropriate option for your version:
      Configure > Form Layout
    2. Add the new formatter to the form.
    3. Right-click the Activityheader in the form and choose Personalize Activity to select the fields of interest.
    4. Step C I have not done as I do not know what it means?

 

Moedeb_2-1768172688761.png

 

 

 

  1. Then we have to create system property.
    1. Create a system property from sys_properties table.
    2. with the Suffix as:
      glide.ui.[custom application table name]_activity.fields

Moedeb_3-1768172688763.png