Small and medium business | Business Central, N...

How to validate Phone No field

(0) Share

Report

Posted on by Nalin.karu

120

Hi All,

I have a requirement to add extra Phone no field on Customer card. I want to display error if a letter is entered as in default Phone no field.can you help me with writing custom validation code?

(when trying to copy same validation code from within the validation trigger in default Phone field , it give error message.'')

Thanks,

Nalin.

I have the same question (0)

All responses (6)

Answers (0)

Lars Lohndorf-Larsen on at

Like (0)

Report

RE: How to validate Phone No field

Hello,

I see this is odd, since the same code works OK in the standard app. But for extensions you are not allowed to make use of local external resources unless you set the project to be for OnPrem. You can do that in App.json by setting target = onprem:

Or you can maybe do the validation without the need for a .net variable like this:

                    if StrLen(rec."Phone No.") <> 0 then

                        if not evaluate(i, rec."Phone No.") then

                            Error(StrSubstNo('Invalid %1', FieldCaption(rec."Phone No.")));

    var

        i: Integer;

I have not tested this code, so no guarantees offered :-).

Was this reply helpful? Yes No
Nalin.karu 120 on at

Like (0)

Report

RE: How to validate Phone No field

Hi Lars,

Thanks for the reply.

sorry for not mentioning platform for which I'm developing. It's Cloud platform. so, Is it safe to set "target":OnPerm".?.

Appreciate your explanation.

Regards,

Nalin.

Was this reply helpful? Yes No
Lars Lohndorf-Larsen on at

Like (1)

Report

RE: How to validate Phone No field

Hi Nalin,

Sorry no, in that case you cannot set target to OnPrem. Then your challenge is to not use .net variables. Keep in mind that .al code as default runs server-side, so when hosted on a MS server, it is not a good idea (for MS) to allow access to the local OS. There are built-in datatypes that you can use. For example here, were it uses the built-in Char and Variant datatypes:

                    for i := 1 to StrLen(rec."Phone No.") do begin

                        Char := rec."Phone No."[i];

                        vari := Char;

                        if not Vari.IsInteger then

                            error('Bad number, please enter a better number.')

                    end;

    var

        i: Integer;

        Vari: Variant;

        Char: Char;

I hope you can use that instead?

Was this reply helpful? Yes No
Nalin.karu 120 on at

Like (0)

Report

RE: How to validate Phone No field

Hi Lars,

Thanks for your explanation and code. appreciate it.

Regards and Thanks,

Nalin.

Was this reply helpful? Yes No
Suggested answer

JAngle 125 on at

Like (0)

Report

RE: How to validate Phone No field

One small consideration here being phone numbers can contain + so just checking for integer won’t be enough. You can can do if not Rec.”Phone No.” in [‘+’, ‘0’ .. ‘ 9’] then

good explanation on controlling this here: https://youtu.be/cr9UCF-jEz0

Was this reply helpful? Yes No
Suggested answer

Giambattista Malvasi 195 on at

Like (0)

Report

RE: How to validate Phone No field

LOCAL PROCEDURE IsNumeric@1(p_gText@1000 : Text) : Boolean;

VAR

i@1001 : Integer;

BEGIN

FOR i := 1 TO STRLEN(p_gText) DO

IF (FORMAT(p_gText[i]) IN ['0'..'9']) OR (FORMAT(p_gText[i]) IN ['.']) THEN

IF STRLEN(DELCHR(p_gText, '=', DELCHR(p_gText,'=', '.'))) <= 1 THEN

EXIT(TRUE)

ELSE

EXIT(FALSE)

ELSE

EXIT(FALSE);

END;

Was this reply helpful? Yes No