The issue seems to lie in your script logic and possibly in your understanding of the variable relationship and how question_choice stores data.
Here is a sample query:
(function executeRule(current, previous /*null when async*/) {
// Create a GlideRecord for 'question_choice' table
var type = new GlideRecord('question_choice');
// Add query to find the correct choice based on question and selected value
type.addQuery('question', '3D2826f6164707d214384e47eb616d4357'); // Replace with your actual variable sys_id
type.addQuery('value', current.variables.license_type); // Match the value selected by the user
// Execute the query
type.query();
// If a matching record is found, retrieve the price
if (type.next()) {
var licprice = type.recurring_price; // Ensure you are fetching the correct field (recurring_price in this case)
current.price = licprice; // Set the price on the RITM
}
})(current, previous);
ɪꜰ ᴍʏ ᴀɴꜱᴡᴇʀ ʜᴀꜱ ʜᴇʟᴘᴇᴅ ᴡɪᴛʜ ʏᴏᴜʀ Qᴜᴇꜱᴛɪᴏɴ, ᴘʟᴇᴀꜱᴇ ᴍᴀʀᴋ ᴍʏ ᴀɴꜱᴡᴇʀ ᴀꜱ ᴛʜᴇ ᴀᴄᴄᴇᴘᴛᴇᴅ ꜱᴏʟᴜᴛɪᴏɴ ᴀɴᴅ ɢɪᴠᴇ ᴀ ᴛʜᴜᴍʙꜱ ᴜᴘ.
ʙᴇꜱᴛ ʀᴇɢᴀʀᴅꜱ
ꜱʀᴇᴇʀᴀᴍ
