I'm thinking I should get the currencies sublist, ...
# suitescript
k
I'm thinking I should get the currencies sublist, push all selected IDs to an array, and for any currency not in the array, add it to the sublist. To do that I just need a list of all the currencies, but I can't find currencies in the list of searchable record types. >.<
w
perhaps creating a record with a currency-field and get all the options available? Like a journal or something... maybe there is some better way?
k
I suppose another idea might be to check the available values in the Currency field in the Currencies sublist. I'll try
Field.getSelectOptions()
t
@Kris Wood What about using the query module and this?
SELECT ID, Name FROM Currency
👍 3
k
@tdietrich thanks! I'll try that next.
getSelectOptions says it's not a function. >.<
I guess it doesn't work on native sublist fields?
Query worked, thank you!!!
t
Awesome! I'm glad it worked.