Hi, Can anyone help me with formula(HTML)? So, there is a field A. and this field consists of 'Company+Name+ID'. I only want 'Name' and 'ID'. Thus, I made a formula like this : {field_name} || {field_ID}. However, I want to also make this formula(HTML) field a link so that you can see the total amount of the items. I typed this '|{field_name}||'%20'||{field_ID}||'&detail=FORMULAHTML&detailname='||{field_name}||'%20'||{field_ID}||' target=_blank'||{field_name}||' '||{field_ID}||'/a' but the above doesn't work... It makes the Formula(HTML) clickable , however, I don't see the correct result.

I'm not sure I understand. You're on a transaction search and want to provide a link to a customer?

Looks like you want to chain link searches together and the link enters another search for that entity. I get it and yes it can be done, but your explanation is a little confusing.

@virtualEncoreTremor Yes, the purpose is to show the subtotal. @Michael McNamara Yes. I'm sorry about that. It was confusing .. I should attach some images to better explain my problem! Actually, I could solve this one after a few hours of trial and error. I used internalID instead of the field name.