How to configure a formatter on the idea form

[Siris]

Hi, I want to configure a formatter on the Idea form, which shows comment related to that Idea dynamically.  These comments are not OOB ones, and these are stored in a separate cf_comment table.  I tried to build a UI macro, but the issue is it is not dynamic and the not retrieving dynamic sysid of the Idea to add comments.

[yashkamde]

Hello @Siris ,

The reason may be your UI Macro feels static is because it doesn't automatically know the current record context. By using g_form.getUniqueValue() (on forms) or passing the Idea sys_id explicitly (in portal), you ensure the comments are tied to the correct Idea dynamically.

refer this may it help :

https://www.servicenow.com/community/developer-forum/process-flow-dynamicly-shows-a-process-formatte... 

If my response helped mark as helpful and accept the solution.

[Ankur Bawiskar]

@Siris 

instead why not show those Comments in related list of that Idea record?

If the "cf_comment" table has field referring to Idea table then you can simply configure Related list and add

if not then you can create a defined relationship and then add that on form

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

[Siris]

@Ankur Bawiskar Hi, yes the comments are dynamically linked to IDEA.  Yes, adding as a related list quick solutions, but I want to add a formatter that shows the comments.  The main issue is formatter does not get the sysID of the idea dynamically.  With change of the record its not triggered.

[Ankur Bawiskar]

@Siris 

you can try to see some OOTB UI macros how they are doing.

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