So, I have a broken link due to an invalid express...
# generalc
Collin Hannah
04/22/2020, 8:59 PMSo, I have a broken link due to an invalid expression in my formula. I assume that it's because {internalid} is not the correct field id? I am trying to get this formula to work to populate a Service Report attachment from the message fields.
b
battk
04/22/2020, 9:00 PMprobably want to share the text of your formula
battk
04/22/2020, 9:00 PMa quick look suggests you are missing a quote in the beginning
c
Collin Hannah
04/22/2020, 9:00 PMIts on the pictures, they just got blurry when i uploaded them
Collin Hannah
04/22/2020, 9:02 PMis that betteR?
g
Gregory Jones
04/22/2020, 9:10 PMWhat type of saved search is this?
c
Collin Hannah
04/22/2020, 9:10 PMit's a customer saved search, but I'm try to grab the message fields attachments id. not the attachment to the customer.
g
Gregory Jones
04/22/2020, 9:11 PMI think that's too many joins.
Gregory Jones
04/22/2020, 9:11 PMCustomer -> Message -> Files
Gregory Jones
04/22/2020, 9:12 PMfiles attached to the message is too far away from customer
c
Collin Hannah
04/22/2020, 9:12 PMI'
Collin Hannah
04/22/2020, 9:12 PMI'm sorry, I should be more specific - it's a case search.
Collin Hannah
04/22/2020, 9:12 PMCase -> communiction -> Message fields -> attachments
g
Gregory Jones
04/22/2020, 9:14 PMYeah, still think the files are too far from the base record. You might have to start with a message saved search
b
battk
04/22/2020, 9:14 PMcopy and paste the text of your formula here
g
Gregory Jones
04/22/2020, 9:15 PM'<a href="<https://XXXXX.app.netsuite.com>'||{file.url}||'"target="_blank">'||{file.name}||'</a>'b
battk
04/22/2020, 9:15 PMimportantly @Gregory Jones has quotes around his anchor element
c
Collin Hannah
04/22/2020, 9:16 PM'<ahref=|{internalid}||'&company='||{internalid}||' target="_blank">Service Reports </a>'
Collin Hannah
04/22/2020, 9:17 PM'<a href=<https://3491530.app.netsuite.com/app/common/entity/custjob.nl?id='||{internalid}||'&company='||{internalid}||'> target="_blank">Service Reports </a>'k
KevinJ of Kansas
04/22/2020, 9:23 PMOpen a file link and use that as your base. You are trying to use the link I sent too literally
KevinJ of Kansas
04/22/2020, 9:24 PMGregory's link is using the same concept of concatenation, but is a different record type
b
battk
04/22/2020, 9:28 PMthe formula
'<a href=|{internalid}||'&company='||{internalid}||' target="_blank">Service Reports </a>'
is a valid formula, it will probably generate a garbage link for a case search, but you shouldnt be getting an invalid expression from it
j
jen
04/22/2020, 9:48 PMit at least needs some more quotes in it
c
Collin Hannah
04/23/2020, 12:22 AM@battk When I put quotes on it, it worked. It generated the customer link though, not the attachments I was hoping to get.
b
battk
04/23/2020, 1:40 AMthats more what @KevinJ of Kansas was trying to tell you. You would need to figure out how urls work for attachments, and what parameters they accept
battk
04/23/2020, 1:40 AMthen find ways to fill in those parameters from the search results
battk
04/23/2020, 1:46 AMi personally would expect approaching this from a different direction would be easier, do a message search to get your attachments and use the appropriate join to filter your results
battk
04/23/2020, 1:48 AMa limitation of saved searches is that it only supports 1 level of joins in either direction. going from case to messages to attachments is too far, starting at message has better chances
c
Collin Hannah
04/23/2020, 1:54 AMThe only issue with that is the data I need is only the case and on the attachment. not the messages. However, I could use the messages & do a join to the case from one end and another join to the attachment on the other end. That should work.