Hello folks,
I've received a request to create two fields on the incident form - one for Classification, second one for Sub-classification.
They are supposed to be 'linked together', the former decides on what can be shown from the second list.
I've already found that I can achieve this by creating two choice lists on the table, assigning them the Choice type, and enabling Dependent Field on the second one, and creating the required entries.
However, I'd like to eventually automate adding all the possible choices, since it'd take some time.
First I thought of a fix script, but since it's always a risk to do things manually, I then turned towards the import set module.
As I'm not yet very keen with it, I wasn't able to find out a way to split two columns - as seen above - into these two choice lists for the fields I've created.
I'd have to create either a Classification choice record if it doesn't yet exist, or a Sub-classification record if one doesn't exist for the current Classification iteration. Is there a way to use the Import Sets like that, or should I get back to coding?
Apologies if I didn't use the right terms, I'm still learning 🙂
I'll be grateful for your hints.
Hi,
The values have to be loaded in to the sys_choices table.
I am pasting a screenshot of what columns you need. The below screen shot is for subcategory which is dependent on category in incident form.
Regards,
Karthik Nagaramu
The easiest way to do this that I have found is to build it on a small scale manually, then export those results to maintain in a spreadsheet for later import. That way you know the import will map back accurately because it's an export of the real data.
Go to the table sys_choice and note the following columns:
Note that category has no dependent value, but subcategory does. These are the VALUES of the category, not the label - there's a difference.
