How to import Excel data into Question Choices of catalog variables without using a table

nakamura323
Kilo Guru

Hello.

I would like to use Excel data as a catalog variable selection.

I think it is possible to import it into a table and refer to that table, but I would like to avoid using a table if possible. What other methods can you think of?

 

Is there no option but to manually add it to Question Choices?

スクリーンショット 2024-03-06 114514.png

 

thank you.

1 ACCEPTED SOLUTION

Harish KM
Kilo Patron
Kilo Patron

Hi @nakamura323 In servicenow every record is stored in a table, so not possible to store choices with out using question_choice table in this case,

How ever you can display choices in script without using table, but it will not be stored at backend i.e once you submit the record the choices will be blank since there is no real value to it.

Regards
Harish

View solution in original post

1 REPLY 1

Harish KM
Kilo Patron
Kilo Patron

Hi @nakamura323 In servicenow every record is stored in a table, so not possible to store choices with out using question_choice table in this case,

How ever you can display choices in script without using table, but it will not be stored at backend i.e once you submit the record the choices will be blank since there is no real value to it.

Regards
Harish