Formula Field Syntax

[Joemac]

I have a formula field in my table that I want to use some static text combined with data from another field.  Here is an example of what isn't working.  I'm new and the syntax of how to do this is foreign. 

https://app.hubspot.com/contacts/999999/contact/[@field:hubspot_id]

So the  https://app.hubspot.com/contacts/999999/contact/  is the static part and I want to append the hubspot_id field at the end to create a hyperlink.  Thanks!

[Kurumi]

Hi @Joemac,

Is this your expected result?  https://app.hubspot.com/contacts/999999/contact/[@field:hubspot_id]

If yes, you can simply insert this in your Formula Field: 

Result:

For more information, you can check it here:
https://howto.caspio.com/tables-and-views/data-types/formula-fields/
https://howto.caspio.com/function-reference/

I hope this helps!

[Joemac]

@Meekeee - awesome it works.  Thank you!

[Flowers4Algernon]

That was a great solution! These links could be helpful, as well, as you go along:

1. https://howto.caspio.com/tables-and-views/data-types/formula-fields/

2. https://howto.caspio.com/function-reference/

[Queso]

Very nice question and a solution! 

Just to add, we can use static text as an App Parameter, which will shorten the formula. However, App Parameters is only allowed in Calculated Values and Calculated Fields, not in Formula Fields.