Is it possible to use the Formatter to pull the first letter of each word from an input?

Question

Hello!

Thinking about proposing something new, but would like to see if it’s possible first. We work in a competitive industry and have had a problem with a low level employee trying to sell a customer list they obtained from order forms. I think we can help prevent this in the future by using the first letter of each word of the customer’s name as the identifying field instead of using the customer’s full name.

The orders are entered on Quickbooks, and are sent to their respective workflows in Zapier. Would it be possible to change an order name from: Albert Berns Company:1234 to: ABC:123 using the formatter? If so, how? I’ve experimented with the idea, but haven’t had any success.

Thank you so much!

Troy Tessalone · Accepted Answer

Hi @KBSThat would likely involve using a custom Code step.https://zapier.com/apps/code/helplet Name = inputData.Name;let Abbreviation = getFirstLetters(Name);function getFirstLetters(text) {    return text.split(' ')              // Split the string into an array of words               .map(word => word[0])    // Map each word to its first letter               .join('');               // Join all the first letters together}output = [{Abbreviation, Name}];

KBS · Answer

This worked great! Thank you so much!

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded