The formulae mentioned are simply javascript inline scripts. To generate any other formulae one can just ask chatgpt to generate the same.

Pro tip : You can use the below prompt for this:

Give me the inline JavaScript code for the use case mentioned below, 
context: @column_name is the variable holding the string. 
return format: I want the result in this format: {{ @column_name }}.operation based  on use case. example format: {{ @column_name }}.split(",")[0]
use case: mention what you want to do here

​

Operations based use cases

​

1. Split Full Name into First & Last Name

Sometimes you may come across a scenario where your prospect list only has the full name available as a data point, but while sending an outreach addressing the person as their full name might not sit right with you. In that case a simple formula can be employed to split the full name into separate first name and last name data points.

getting first name:

      {{ @Full Name }}.split(" ")[0]

getting last name:

      {{ @Full Name }}.split(" ")[1]

​

2. Find a specific technology from BuildWith Tech Stack

Our Tech Stack action tools provides a comprehensive list of technologies being employed by a company via buildwith but sometimes it may become tedious to find whether a specific technology is being used or not.

For this a simple formula can help you out(am checking if shopify is there or not):

      {{ @Tech Stack }}.technologies.toLowerCase().includes("shopify") ? "yes" : "no"

​

3. Find the current experience from the Linkedin Enrichment

While users can use the add column button available next to all enrichments in any sales action tool. They can also write this from scratch.

Here’s an example:

      {{ @Linkedin Enrichment }}?.experiences[0].title + ' at ' + {{ @Linkedin Enrichment }}?.experiences[0].subtitle
      

​

Content based use cases

​

1. Create Templatized Emails

Our formula columns also allows our user to create static mail templates, with an option to embed different aspects of the mail. Such as, icebreakers, salutations, signoffs etc.

check out the below example:

      Hi @FirstName,

      @Icebreaker

      We are making strides in the outreach space, feel like getting on board?

      Best,
      Team Bitscale

​

2. Appending two columns

Maybe you already have the first name and last name of 1000s of prospect available in your grid but your use case requires your to have their full name as well. While using a gpt mini across all these use cases may seem like an easy way out, for large grids that might not be the best scenario. So why not employ the trusty formula column for this?

you can easily append 2 or more columns using the formula below:

    @FirstName + " " + @LastName

​

Further crude formulae

{{ @col1 }} + " " + str2
{{ @col1 }}.concat(" ", str2)

{{ @col1 }}.split(",") // Split by comma
{{ @col1 }}.split(",")[n] // nth split starting from 0

{{ @col1 }}.trim() // Trim spaces from start and end

{{ @col1 }}.length

{{ @col1 }}.toUpperCase()
{{ @col1 }}.toLowerCase()

{{ @col1 }}.replace("oldSubstring", "newSubstring")

{{ @col1 }}.substring(5, 10) // Extract characters from index 5 to 10

{{ @col1 }}.repeat(3) // Repeat {{ @col1 }} three times

{{ @col1 }}.split("").reverse().join("")

{{ @col1 }}.charAt(3) // Get character at index 3

{{ @col1 }}.indexOf("substring")

{{ @col1 }}.padStart(10, "0") // Pads with zeros at the start
{{ @col1 }}.padEnd(10, ".") // Pads with periods at the end

Array.from({{ @col1 }})

{{ @col1 }}.trim() === ""