Hey guys, how do I reference a PO internal ID as a...
# generali
Isabella
10/28/2021, 5:10 PMHey guys, how do I reference a PO internal ID as a link? We have an external platform that uses an API connection to bring over SOs/POs. I need to put a link on the email form that gets emailed out from NS when that PO is created in NS to link to the external platform. The link is super easy it's just https://example.example/orders/purchase-orders/{internalid} in the curly brackets I need to put the right reference. So this has to go into the formula that is going on the field that I am putting on the PO form so I can later grab it and put it in the email. But it keeps telling me my formula is bad....
k
KevinJ of Kansas
10/28/2021, 5:11 PMis this in a saved search result?
i
Isabella
10/28/2021, 5:12 PMNo
Isabella
10/28/2021, 5:12 PMIts just a field I am creating to go on the PO to link to the external page
Isabella
10/28/2021, 5:12 PMso its just a dynamic link basically
k
KevinJ of Kansas
10/28/2021, 5:12 PMoh. you have the right field but you need to concatenate it
i
Isabella
10/28/2021, 5:13 PMnot sure how to do that
k
KevinJ of Kansas
10/28/2021, 5:15 PM'URL Text'||{internalid}i
Isabella
10/28/2021, 5:16 PMdo I want the bangs around it?
Isabella
10/28/2021, 5:17 PMwell it didnt give me an error this time!
Isabella
10/28/2021, 5:21 PMwell no error but it's not showing up on the field
Isabella
10/28/2021, 5:22 PMthat should grab the internal ID of the PO I'm on and insert it into the link right?
Isabella
10/28/2021, 5:22 PMor am I thinking about this wrong..,.
k
KevinJ of Kansas
10/28/2021, 5:25 PMthat's what it should do - but you need the field to not store value
KevinJ of Kansas
10/28/2021, 5:25 PMand yes - you want the quotes around it
i
Isabella
10/28/2021, 5:32 PMso I turned off store value
Isabella
10/28/2021, 5:32 PMand now the error Im getting on the PO <error: Field %27internalid%27 Not Found|ERROR: Field 'internalid' Not Found>
Isabella
10/28/2021, 5:34 PMIsabella
10/28/2021, 5:34 PMbut the || instead of the weird characters lol
k
KevinJ of Kansas
10/28/2021, 5:45 PMmaybe try {ID}?
KevinJ of Kansas
10/28/2021, 5:45 PMyou should note - internal ID isn't populated until the record is actually saved
i
Isabella
10/28/2021, 5:46 PMID worked!
Isabella
10/28/2021, 5:46 PMThank you
3 Views