I need to have value in USD.

[niveditakumari]

Hi, 

I have created field in catalog item that is single line text and it should only take value in USD. 

Can anyone please help me to achieve that. 

Regards, 

Nivedita 

[Sohail Ahmed · Accepted solution]

Hi @niveditakumari 

Can you try using this on-change client script on the field 

function onChange(control, oldValue, newValue, isLoading) {
    // If the form is loading, don't validate
    if (isLoading) {
        return;
    }

    // The value of the field being validated
    var value = newValue;

    // Regular Expression to match the US currency format: $13,000.00 or 13,000.00
    var regex = /^\$?\d{1,3}(,\d{3})*(\.\d{2})?$/;

    // Test if the value matches the regex
    if (!regex.test(value)) {
        // Show an error message if the value does not match the pattern
        g_form.showFieldMsg('your_field_name_here', "Please enter a valid amount in USD format (e.g., $13,000.00).", "error");
        g_form.setValue('your_field_name_here', '');     }
}

- Thank you ,

Sohail Ahmed Syed

[sunil maddheshi · Accepted solution]

@niveditakumari 

Hi You can follow below example:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue === '') {
        return;
    }

    // Regular expression for USD format (e.g., $100.00, $1,000,000.99, $0.50)
    var usdRegex = /^\$\d{1,3}(,\d{3})*(\.\d{2})?$/;

    if (!usdRegex.test(newValue)) {
        alert("Please enter a valid USD amount in the format: $1,234.56");
        g_form.clearValue('your_field_name'); // Clears incorrect input
    }
}

Please marl correct/helpful if this helps you!

[Ehab Pilloor]

Hi @niveditakumari, 

You can create regex for this variable to add '$' in the beginning and followed by number which will be ^\$\d+(\.\d{2})?$ and add it to Validation Regex in Type Specifications section of Variable record.

If you found my reply helpful, please mark it as Solution and Helpful.

Thanks and Regards,

Ehab

[niveditakumari]

Hi @Ehab Pilloor, 

Any step that you can help with. 

Can you please help me with step for that. 

Regards, 

Nivedita 

[Ehab Pilloor]

Hi @niveditakumari,

1. You can navigate to All -> Variable Validation Regex.

2. Create a new record.

3. Fill in the mandatory details like adding Name, Validation Regex and Validation Message.

4. Save it. 

5. Use the Validation Regex in the Type Specification Section of Variable record.

6. Save the record and test on the catalog view.

Note: This is the no code solution for this requirement and follows best practice.

Regards,

Ehab

[Sohail Ahmed · Accepted solution]

Hi @niveditakumari 

Can you try using this on-change client script on the field 

function onChange(control, oldValue, newValue, isLoading) {
    // If the form is loading, don't validate
    if (isLoading) {
        return;
    }

    // The value of the field being validated
    var value = newValue;

    // Regular Expression to match the US currency format: $13,000.00 or 13,000.00
    var regex = /^\$?\d{1,3}(,\d{3})*(\.\d{2})?$/;

    // Test if the value matches the regex
    if (!regex.test(value)) {
        // Show an error message if the value does not match the pattern
        g_form.showFieldMsg('your_field_name_here', "Please enter a valid amount in USD format (e.g., $13,000.00).", "error");
        g_form.setValue('your_field_name_here', '');     }
}

- Thank you ,

Sohail Ahmed Syed