In invoice i have pdf to be print . In that How do...
# advancedpdfs
shree sashti
02/21/2023, 10:54 AMIn invoice i have pdf to be print . In that How do I get a custom field from address subrecord (shipping address) from customer ?
record.entity.addressbook.addressbookaddress.customfield did not work.
Please help
n
NElliott
02/21/2023, 11:50 AMhow are you referencing the shipping address currently it might be as simple as shippingaddress.my__custom_field
s
shree sashti
02/21/2023, 11:52 AMHi @NElliott taking the 'shipaddress' field in invoice for the shipping address value .
But this custom field is in the address subrecord and not a part of 'shipaddress' in invoice right ?
n
NElliott
02/21/2023, 11:54 AMHow are you outputting the address details currently such as post code / city?
NElliott
02/21/2023, 12:00 PMAlso if you flip to the WYSIWYG editor it might help you figure out the field id. If it's visible in the list, select it and then switch to the editor and you should see the detail you need.
👍 1
s
shree sashti
02/21/2023, 12:05 PMI'm just taking the value from the Ship To address field (type : address, Id : 'shipaddress') in the invoice. Not particularly taking zip code or City
n
NElliott
02/21/2023, 12:09 PMAh so you're just plugging in "shipaddress" as a blob of text.
Sorry without going off and looking at a ADV PDF template myself I'm not sure.
Have you tried looking at the WYSIWYG editor though as I suggested? I cannot recall if the object you need is included, it might not be.
If not, you may need to wait for someone else to reply or go the custom field route using a UE script.
s
shree sashti
02/21/2023, 12:11 PMIll try and update .
n
NElliott
02/21/2023, 12:11 PMAlso have you tried just using "record." + your custom field id?
NElliott
02/21/2023, 12:12 PMWHen I hover over this it shows record.shipaddr2 for instance...
s
shree sashti
02/21/2023, 12:13 PMGot it @NElliott. I think this way I could search for the custom record id directly
n
NElliott
02/21/2023, 12:13 PMDo you mean custom field?
s
shree sashti
02/21/2023, 12:14 PMYeah custom field in address subrecord.
👍 1
shree sashti
02/21/2023, 12:15 PMI did the same way you sent the screen shot .
Im getting ${record.shippingaddress.custrecord_custom_message}
shree sashti
02/21/2023, 12:15 PMIll print this and update you
n
NElliott
02/21/2023, 2:06 PMHow'd it go?
s
shree sashti
02/21/2023, 2:10 PMGot the field . But the value in it doesn't show up 🥲
n
NElliott
02/21/2023, 2:14 PMAnd it's definitely the correct shippingaddress record being referenced with a value in that custom field?
s
shree sashti
02/21/2023, 2:25 PMI tried to get the zip value by record.shippingaddress.zip. and I got the right value . But not this custom field . Fishy!
shree sashti
02/21/2023, 2:26 PMYeah it's the right address.
n
NElliott
02/21/2023, 2:40 PMIf you navigate to the record directly through the UI can you see teh value.
I'm wondering if there's something related to the form used on that record, maybe it's not exposed on the form. I could be over thinking it though, there might be a simpler reason...