How to get the "Created by" value from system info...
# advancedpdf
m
How to get the "Created by" value from system information to be printed in a custom layout?
s
depends on the record but it should be
recordcreatedby
${record.recordcreatedby}
m
how to get the name instead of the ID?
message has been deleted
thanks @Scruffy
s
assuming that youre talking about transaction records, you can also use ${record.salesrep}
it prints a name for me. Im also assuming these are advanced pdfs lol
m
i'm using Advanced PDF/HTML Templates
s
if you ever need to find specific field values from any record, you an append the URL of the record with
&xml=t
and it will show the .xml of the record with all its values.
m
wow. nice. thanks a lot
tried
${record.salesrep}
but it's a different name. not the creator's name.
will keep looking in the xml
@Scruffy do you know if I can join the ID i'm getting from
${record.recordcreatedby}
to a list so I can get the name field?
s
i would test digging another layer into that record.
${record.recordcreatedby.entityid}
. i dont think you can dig that many layers in advanced pdfs though but i dont have the time to verify.
m
it doesn't work; but what I currently know is
${record.recordcreatedby} == entity.id
and I need either
entity.altname
or
entity.entitytitle
s
Yea not to sure. Not the best work around but you could make a custom text field within the record to reference. Theres probably a more better way to do it but thats all i got. 😄
m
that's what other admins have done for other records. workflow to write current record user to a custom created by field.
i've always wondered if there's a more straightforward way of doing it by getting system info data
s
From what ive seen and experienced (only been admining NS for almost a year now), not really lol.
It s a limitation that has been acknowledged in their manuals so doesnt look like they'll be fixing it any time soon
m
I can see a
${companyInformation.addressText}
variable in the code (that can't be seen in the xml record); I'm confident there must be something similar for system information
s
Possibly. That information is in Setup -> Company -> Company Information
Good luck on your digging. Let me know if you find a solution as im not sure myself.
m
my workaround which is only possible if expecting a small list of record creators:
Copy code
<td><#if record.recordcreatedby == "3023">
		test1
	<#elseif record.recordcreatedby == "3024">
		test2
	</#if></td>
lol. using workflow to write to a custom field might be easier
s
yea the method above would be a lot of upkeep
n
would something like ${record.recordcreatedby.name} return text?
m
no, it wouldn't