Copy lead gen property single line text to Number property

[Afd-mark]

We use lead generation forms, in which we also ask for the number of employees. This value is stored in HubSpot as a single-line text property. We use this number in HubSpot for lead qualification, but that requires a numeric property because we use the "is greater than" condition. In the workflow itself, you can't copy a single-line text field into a numeric property.

Does anyone have an idea how I can copy the number from the lead gen property (single-line text) into a numeric property?

In the single-line text field, you can specify that only numbers may be entered, but this doesn’t work, and I can’t really do anything with it.

Hopefully, someone has a solution for this.
Thanks!

Leanne

[karstenkoehler · Accepted solution]

Hi @Afd-mark,

I would do this with a calculation property and the string_to_number function: https://knowledge.hubspot.com/properties/create-calculation-properties

Choose output as a number and then apply the aforementioned function on your text property.

Best regards!