Hi there,
I have created an inventory app for a carpenter to record the lengths of their woods. I have created two fields, one for the user to input the lengths in cm and the other to sums the values.
Since majority of the lengths are 300 cm I want to also allow the user to type 3L instead of 300. Therefore, I need to give the letter "L" the value of 100 and code the Total Quantity (cm) field to perform 3*100 when eg 3L is in the input. However, since I am new to coding, I don't know how to do this. Could you please help me include this code in my formula section within my sum function below?
User input
Field Name: Quantity (cm)]
Type: LongText (since user want each value entry to be on the next line)
Formula: none
Calculation field
Field Name: Total Quantity (cm)
Type: Decimal
Formula: SUM(EXTRACTNUMBERS([Quantity (cm)]))
LinkedIn
Twitter
