Is there any way to add dynamic fields in any table , for ex., incident table

[Ramkumar Rajend]

Hello folks,

Good day!

I am having a kind of requirement to add dynamic fields in any table, say for ex. incident. The idea behind dynamic is, we would like to keep the OOB fields and to have some set of dynamic fields instead of creating many custom fields on incident table(since the dynamic questions may go on 100's count, that is the reason to keep incident table minimal with OOB fields).

Thanks in advance.

[larstange]

Hi Ram

How about displaying your dynamic questions in a related list - that will be able to scale as much as you want and you are able to edit answers via the table inline edit.

You keep the questions in another table and relate them to the incident via a reference field. This will give you the related list "for free"

Alternativly you have to write you own UI macro / formatter to add a dynamic section to the incident form which will then display all of the questions - but you also have to build the logic to update the questions with any changes written in the incident.

[conmic]

Hello Ram,

Try to use variables and the "Variable Editor" formatter.

Variable questions can be set in the table "question" and the link to an incident is made via the table "question_answer".

This comes to what Lars Tange suggested, this however is out-of-the-box and working.

[Ramkumar Rajend]

Thanks for your response Michel, will give a try now

[Ramkumar Rajend]

Hi Michel,

I have added required variables in "question" table and in "question_answer" table linked that question with table name "Incident" and left "Tables sysid" field as blank.

How to show this on incident form either conditionally/unconditionally.

Many thanks in advance.