Hi, would someone be able to point me in the right...
# suitescriptm
May
11/15/2023, 4:19 PMHi, would someone be able to point me in the right direction with ue scripting for customer record address, i want to locate the right address using a postcode, once the address record in the customer's addressbook is located i want to set it as the default billing.
where i'm stumbling is 'how does one figure out the line id of the address record'
i need it know the line id in order to edit the address record, this block of code i have requires the right line number
var subrec = rec.getSublistSubrecord({
sublistId: 'addressbook',
fieldId: 'addressbookaddress',
line: 0
});
please guide me on how one searches a customer record's address book with a post code, to retrieve the line number for me to use in my code above.
much appreciated
b
battk
11/15/2023, 4:47 PMsafe way is to go through each addressbook address and check the zipcode field for the one you are looking for
battk
11/15/2023, 4:48 PMyou also probably want to be more precise in your usage of line id
battk
11/15/2023, 4:48 PMthere is an actual id for the line, and its not the same as the line sequence number
battk
11/15/2023, 4:49 PMthe line parameter used in suitescript is the 0 indexed, line sequence number
m
May
11/15/2023, 5:01 PMi could grab the address id, but to update the address default billing flag i believe i'm limited to using getsublistsubrecord, meaning i must get the line id.
b
battk
11/15/2023, 5:06 PMagain, the line in
Copy code
var subrec = rec.getSublistSubrecord({
sublistId: 'addressbook',
fieldId: 'addressbookaddress',
line: 0
});battk
11/15/2023, 5:06 PMits the index
m
May
11/15/2023, 5:06 PMyep, that's what i'm struggling to get
b
battk
11/15/2023, 5:06 PMwhich means the first addressbook is line 0
m
May
11/15/2023, 5:06 PMa saved search can't get line no
b
battk
11/15/2023, 5:06 PMthe second is line 1 and so on
m
May
11/15/2023, 5:06 PMUntitled
May
11/15/2023, 5:06 PMi attempted the loop
May
11/15/2023, 5:07 PMit doesn't work though, i was using the finali as my 'line' number
May
11/15/2023, 5:08 PMi didn't manage to make this block work, couldn't retrieve the postcode successfully
b
battk
11/15/2023, 5:08 PMas in you couldnt loop through the addressbook lines
m
May
11/15/2023, 5:08 PMit looped, but it didn't return the postcode to be validated
May
11/15/2023, 5:09 PM'i' variable did increment
b
battk
11/15/2023, 5:09 PMthat more likely to be a code problem
m
May
11/15/2023, 5:09 PMbut never managed to retrieve the postcodes
b
battk
11/15/2023, 5:09 PMmy guess is that you dont know how to inspect the value in cus_pc
m
May
11/15/2023, 5:09 PMyeah its my loop problem, in theory the finali variable will be able to act as the line number?
b
battk
11/15/2023, 5:09 PMstart logging cus_pc, or use the debugger to inspect its value
m
May
11/15/2023, 5:10 PMi believe it's this bit i need to tidy
cusRec.getSublistValue('addressbook', 'postcode', i)
May
11/15/2023, 5:10 PMit returns undefined
b
battk
11/15/2023, 5:10 PMcorrect, there is no postcode field on the addressbook sublist
m
May
11/15/2023, 5:11 PMprob zip
b
battk
11/15/2023, 5:11 PMits the wrong place to look
battk
11/15/2023, 5:11 PMand the wrong id
m
May
11/15/2023, 5:12 PMhow so?
May
11/15/2023, 5:13 PMi was hoping for a simple call like findsublinewithvalue()
May
11/15/2023, 5:13 PMcouldn't find the equivalent, seeing as the postcode hides in a sub list within a sublist
b
battk
11/15/2023, 5:18 PMits called a subrecord, and you will have to go in there to get to the zip code
battk
11/15/2023, 5:19 PMi mean, if you wanted to be hacky and use internal fields, you can probably find one for the zip, but thats not really sane when there is a perfectly acceptable non hacky solution
m
May
11/15/2023, 5:20 PMyeah, i'll try fix my loop then and see if that works
May
11/15/2023, 5:20 PMthanks battk
2 Views