Triggered action how to convert from text255to number/integer/currency ?

[CapNcook]

Hi Everyone,

I have a field that is text 255 that contains number and letters. Ex.


I place them in a variable and I use replace to remove the text and only retain numbers(All good).



But the problem is when I use this variable to and store the value in a currency,integer, or number field I get Datatype mismatch error. What should I do? 

[ianGPT]

Hi,

A workaround for this is to use an absolute field so it would convert the variable to a number datatype.

Ex.


Hope this helps!

 

[NiceDuck]

What I do here is that I create a table with 3 fields.

A text 255, an ID field, and a formula field with a formula that converts the contents of the text field to float or int (remove the nun numerical values as well.)

I used an insert block to pass the value to that table's text255 field and pull the value of the formula field. 

 

[Flowers4Algernon]

Hello! You may also use this how-to article for Triggered Action reference: https://howto.caspio.com/triggered-actions/triggered-actions-2/