Could this Solution be added to the "Text Help Piece"?

[TimMan]

I have no idea how hard this would be but do you all think this Solution from @kishanprmr could somehow be added to the TEXT HELPER piece?

Personally, I can see doing this over and over.

Reformatting Data before sending it on to Google Sheets

Hi Folks… I have data coming from a webhook (Formaloo is the original form) and I need to reformat it before sending it on to Google Sheets. Here’s two examples… The incoming text data is the word “Transportation” but I need it to say “ID:3” The incoming text data is the word “Housing” but I need it to say “ID:4” Is Data Mapper what I should be using? And if so, are there any tutorials on this somewhere? Thanks, Tim

What do you think @ashrafsam ?

TimMan

[ashrafsam]

@TimMan Maybe change the Replace action, instead of having 1 search and 1 replace value to a list of searches and replace values like this?

If it makes sense we can ping our pieces team to see what they can do about it

[TimMan]

That was exactly what I was looking for before I turned to the Code Piece!

[GunnerJnr]

@ashrafsam, similar to the above request, is there any chance we could add ‘slugify’ to the text helper piece, I think it would be beneficial for when specifying blog URL’s.

For the time being, I just use a key:value pair, and put the title from whatever piece as the value, then target it in a code piece. I will paste the code here in case it helps anyone else:

export const code = async (inputs) => {
  // Extract the title from inputs
  const title = inputs.title;

  // Function to slugify text
  const slugify = (text) => {
    return text
      .toString()
      .toLowerCase()
      .trim()
      .replace(/\s+/g, '-') // Replace spaces with hyphens
      .replace(/[^\w-]+/g, '') // Remove non-word characters except hyphens
      .replace(/--+/g, '-'); // Replace consecutive hyphens with a single hyphen
  };

  // Generate the slug from the title
  const slug = slugify(title);

  // Return the slug
  return slug;
};

Result:

I feel this addition would be great. (I know we can just use the reg-ex too, but hey why not expand the text helper to make it even more awesome than it already is).

Kind regards,
GunnerJnr