Skip to main content

Hello dear community. First time asking a question and learning the basics of scripting.


One part of my script asks the user for a value like this:


let SessionPrice = await input.textAsync (‘Input price per coaching session’);


Then I’m trying to insert that value on a currency field with:

Let CreateField = await MainTable.createRecordsAsync(A{Fields:{“UnitPrice”: SessionPrice}]);


And I get the error:

j: Can’t create records: invalid cell value for field ‘UnitPrc’.

Cell value has invalid format: must be a number


I guess its because its a ‘text’ string and I don’t know how to convert it or make it a ‘currency’.


In advances I’ll appreciate your help.


Thanks…

Welcome to the community, @Nicolas_Hurtado! :grinning_face_with_big_eyes: It’s definitely a tad annoying that there isn’t a direct way to do numeric entry with a script. That aside, converting a string to a number is fairly simple: wrap the Number() type around your string.


As a side note, you don’t need to assign the result of record creation to a variable (unless you need to use the new record ID somewhere else in your code). You can also use the createRecordAsync (singular) variant because you’re only creating a single record, and simplify the data that you’re passing.


With those changes applied, your line looks like this:


await MainTable.createRecordAsync({"UnitPrice": Number(SessionPrice)});

Welcome to the community, @Nicolas_Hurtado! :grinning_face_with_big_eyes: It’s definitely a tad annoying that there isn’t a direct way to do numeric entry with a script. That aside, converting a string to a number is fairly simple: wrap the Number() type around your string.


As a side note, you don’t need to assign the result of record creation to a variable (unless you need to use the new record ID somewhere else in your code). You can also use the createRecordAsync (singular) variant because you’re only creating a single record, and simplify the data that you’re passing.


With those changes applied, your line looks like this:


await MainTable.createRecordAsync({"UnitPrice": Number(SessionPrice)});

Thanks for taking the time to answer and for the extra suggestion. I’m enjoying this learning process of scripting. 🙂

Reply


Terms & Conditions