Hi @Urvashi Sharma ,

Just create one server action to validate all fields Like PanCard Value etc.

And check if it is passed and return a true value otherwise false.

And whenever you create a record in DB before add this validation based on the condition True/False.

Hi Urvashi,

Just with an addition to Rahul's solution, you can use Text Module's Regex_Search function to validate the data in Server Action and based on it's result you can proceed with the decision of committing your transaction into the database.

Also you can simply search the Regex patterns online for your concerned fields for validations.

Regards,
Nikhil Purohit

Hello @Urvrashi Sharma ,

all you have to do is on the submit action of the import excel you can add a server action where you pass the excel record and validate the inputs their, using for example the regex_search as referred by Nikhil above. Since you are saving the data after the validation is successful I advise you to do the validations on the server side for security reasons. And you can also create a structure where you have a boolean attribute named Success and a text attribute named ErrorMessage. You will create an output variable for the server action with the data type set to the structure we just created. Whenever the validation fails you assign the Success attribute to False and add a meaningful error message to the Errormessage attribute. Then show this message as an error message to the user. This will help the user identify what he/she has to fix.

Hope this helps you.

Best regards,

Lourenco Matalonga