So then I tried to do a simple math equation to move decimal spaces but I think because the values both contain the “%” sign, when I use the “Get product of” function to multiply numbers, I get the error message:
Impossible to convert some types. We were not able to automatically convert a value from type ‘1.74%’ to type ‘Number’. This error is usually encountered if a playbook action is given a field value of a previous command, for which there were no straightforward conversion possible.
Thanks @Jess! I was able to create that action but I am unable to then map it into the Airtable field because the Airtable field type is a number but this is now “text”. When I click into an Airtable field that is a “text” type, I have the option to map it in, but that’s not what I need.
@Jess the issue is that I cannot map the result from the “find values from regular expression” step into that field. But for example, if I needed it to go to “Main List Subs” above it, it does appear as an option. It seems the issue is that I can map it in a text field but not a numbers field. And I need it in the “number” type field.