Skip to main content
Question

How can I extract text from Service Fusion description field and add to Smartsheet row?

  • Oct 11, 2024 10:14 PM UTC
  • 4 replies
  • 70 views

Im using the Service Fusion app and adding data to Smartsheet row. I want to extract just the qty of windows and doors from the description so that it can be added to my zap and in turn to my Smartsheet row

 

 

 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Oct 14, 2024 5:18 AM UTC

Hi @LAndersen2210,

You can use Formatter by Zapier to extract the text that you’re looking for. Here is the list of the Formatter by Zapier functions: https://help.zapier.com/hc/en-us/articles/8496030096013-How-to-use-Formatter-functions

Additionally, you can use RegEx to find text in Zaps. More about that here: https://help.zapier.com/hc/en-us/articles/8496278106637-Use-regular-expressions-RegEx-to-find-text-in-Zaps#h_01HKMCV6BA480X58EPVA8TJTQF

Hopefully, this helps.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Oct 22, 2024 12:27 PM UTC

Hey there, @LAndersen2210! 👋

How did you get on with that Formatter action Ken suggested? Did it allow you able to extract the quantity of windows and doors from the Description field?

We’d love to know whether that fixed the problem so we can mark it as the best answer. And if you’re still facing challenges, just let us know—we’re happy to assist further!


I haven't had a chance to try it yet but I hope to get to it this week 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Oct 23, 2024 6:49 AM UTC

Hi @LAndersen2210,

Please keep us posted on this! If my suggestion didn’t solve the issue, we’re more than happy to troubleshoot further! 🤗