Hi Everyone,
I'm trying to set the expiry date in ...
# suitescripts
sai
01/31/2022, 5:15 PMHi Everyone,
I'm trying to set the expiry date in credit card detalis sublist under customer record, but getting the issue. Can anyone help me with this,
n
NickSuite
01/31/2022, 5:24 PMTry to set it manually in the UI.
s
sai
01/31/2022, 5:28 PMit's setting
b
battk
01/31/2022, 5:35 PMthe usual is to load an existing record with the field set
battk
01/31/2022, 5:35 PMand use getValue or getText to see how its set
battk
01/31/2022, 5:36 PMbe sure to use the matching setValue and setText
battk
01/31/2022, 5:36 PMwhen you are setting
e
Eric B
01/31/2022, 6:38 PMIt should be in mm/yyyy format.
s
sai
02/01/2022, 1:05 PMI'm setting like mm/yyyy format only.
sai
02/01/2022, 1:09 PMI'm trying setting in credit card line in the customer record
sai
02/01/2022, 1:11 PMvar exp_date=exp_month+'/'+exp_year;
var formattedDateString = format.parse({
value: exp_date,
type: format.Type.MMYYDATE
});
student_rec1.setCurrentSublistText({
sublistId: 'creditcards',
fieldId: 'ccexpiredate',
value: formattedDateString,
ignoreFieldChange: true
});
b
battk
02/01/2022, 1:12 PMthat looks like an attempt trying to mix up the types
battk
02/01/2022, 1:13 PMsetValue and setText accept different data types on the more complicated field types
battk
02/01/2022, 1:13 PMuse getValue and getText to see which data types go in each
battk
02/01/2022, 1:14 PMand set with a matching data type
s
sai
02/01/2022, 1:37 PMok,let me try
sai
02/01/2022, 1:39 PMbut, that is sublist field
b
battk
02/01/2022, 1:41 PMthere are sublist equivalents
s
sai
02/01/2022, 2:30 PMi got the object
{"id":"ccexpiredate","label":"Expiration Date","type":"mmyydate"}
b
battk
02/01/2022, 2:39 PMyou want the value or text
battk
02/01/2022, 2:39 PMthe field type doessnt really help you unless you already know what goes in mmyydate fields
s
sai
02/01/2022, 2:40 PMi want to set the value
b
battk
02/01/2022, 2:40 PMthats not what your code does
battk
02/01/2022, 2:40 PMit tries to set the text
s
sai
02/01/2022, 2:40 PMsame issue getting for value also
b
battk
02/01/2022, 2:41 PMwhat issue are you facing for getting the value?
s
sai
02/01/2022, 2:42 PM Copy code
{
"type": "error.SuiteScriptError",
"name": "USER_ERROR",
"message": "Please enter a valid expiration date",
"stack": [
"anonymous(N/serverRecordService)",
"createtionofEnrollPaymentRecord(/SuiteScripts/CreationofEnrollPaymentRecord_SL.js:632)"
],
"cause": {
"type": "internal error",
"code": "USER_ERROR",
"details": "Please enter a valid expiration date",
"userEvent": null,
"stackTrace": [
"anonymous(N/serverRecordService)",
"createtionofEnrollPaymentRecord(/SuiteScripts/CreationofEnrollPaymentRecord_SL.js:632)"
],
"notifyOff": false
},
"id": "",
"notifyOff": false,
"userFacing": false
}b
battk
02/01/2022, 2:43 PMand which line of code is causing this?
s
sai
02/01/2022, 2:44 PM"2022-02-01T080000.000Z" this date I'm trying to setting after parsing
var formattedDateString = format.parse({
value: exp_date,
type: format.Type.MMYYDATE
});
b
battk
02/01/2022, 2:44 PMthats not a line that can throw an error
battk
02/01/2022, 2:44 PMnor is it an attempt at getting the value
battk
02/01/2022, 2:44 PMim telling you that you are getting the types of the value and text wrong
battk
02/01/2022, 2:45 PMget the value or text of a record that already has that field filled in
battk
02/01/2022, 2:45 PMso you can see what valid values look like
s
sai
02/01/2022, 2:45 PMno I'm not getting any values,trying to setting
b
battk
02/01/2022, 2:45 PMand im telling you that your data types are wrong
battk
02/01/2022, 2:45 PMand that you should get an existing value to see how you are wrong
s
sai
02/01/2022, 2:46 PMyes, but how to format my value to that type
b
battk
02/01/2022, 2:46 PMget an existing value to find out
s
sai
02/01/2022, 2:48 PM'01/2023' this format I'm getting
b
battk
02/01/2022, 2:49 PMusing getValue or getText?
s
sai
02/01/2022, 2:50 PMgetSublistValue()
b
battk
02/01/2022, 2:53 PMwhat did your actual logging code look like