⚙ Operations Hub

PBaxter
Contributor

Text to Value

SOLVE

Hi,

 

Using Ops Hub to transform some incoming string data (in a text field) like:

 

"25% increase"

"-10% decrease"

 

I can easily use the replace function to strip the " % increase" and " % decrease" text to create data "25" and "10"

 

But then I want to copy that output into a number field, and I can't see a function in Ops Hub to do a simple text to number transformation - e.g. value() or parseInt()... etc

 

Any suggestions?

 

Thanks!

0 Upvotes
1 Accepted solution
Teun
Solution
Recognized Expert | Diamond Partner
Recognized Expert | Diamond Partner

Text to Value

SOLVE

Or with even less code:

exports.main = async (event, callback) => {
  callback({
    outputFields: {
      newNumberValue: Number(event.inputFields['formula_result_output'])
    }
  });
}


Learn more about HubSpot by following me on LinkedIn or YouTube

Did my answer solve your issue? Help the community by marking it as the solution.


View solution in original post

4 Replies 4
Teun
Recognized Expert | Diamond Partner
Recognized Expert | Diamond Partner

Text to Value

SOLVE

@PBaxter You could achieve this with a coded action, simply use the value you got from your format data action in your coded action and try the following:

exports.main = async (event, callback) => {
  const valueToConvert = event.inputFields['formula_result_output'];
  const newNumberValue = Number(valueToConvert);
  callback({
    outputFields: {
      newNumberValue: newNumberValue
    }
  });
}

 

Schermafbeelding 2022-11-03 om 20.11.14.png



Learn more about HubSpot by following me on LinkedIn or YouTube

Did my answer solve your issue? Help the community by marking it as the solution.


0 Upvotes
Teun
Solution
Recognized Expert | Diamond Partner
Recognized Expert | Diamond Partner

Text to Value

SOLVE

Or with even less code:

exports.main = async (event, callback) => {
  callback({
    outputFields: {
      newNumberValue: Number(event.inputFields['formula_result_output'])
    }
  });
}


Learn more about HubSpot by following me on LinkedIn or YouTube

Did my answer solve your issue? Help the community by marking it as the solution.


PBaxter
Contributor

Text to Value

SOLVE

You guys on here are so awesome. I'd wondered if a bit of code could address this, but it would have taken me hours to work out how to do those input/output pieces - thanks so much for the screenshots!

 

I have my solution working now after a couple of hours doing and testing the workflows.  

 

Thanks again. 

0 Upvotes
christopher-RVO
Key Advisor | Diamond Partner
Key Advisor | Diamond Partner

Text to Value

SOLVE

@PBaxter  HubSpot will prevent you from copying fields of different types over to one another. 

Alternatively, you could change your initial string data to be in positive or negative value formats - and change the text field to a number instead. you could assume that positive values mean increases and negative values mean decreases. That would then allow you to copy the value to a number field.


Christopher Barnett - VP of Revenue at Aptitude 8


0 Upvotes