Validation after Excel upload

Dipali_Pawar
Tera Contributor

3 weeks ago

Hi, I have requirement to populate data on MRVS via excel upload that is working. but validation part I need to do suppose i have fields x , y and in MRVS x has regex which accept 9 digits and y has regex 2 decimal places so same validation should take place after uploading excel. 

suppose user enters only 3 digits in x column in excel then after uploading it should show error like please enter up to 9 digits. 

please let me know if anyone worked on similar requirement. 

Thanks

0 Helpfuls
  • 1,009 Views
20 REPLIES 20

Ravi Gaurav
Giga Sage
Giga Sage

3 weeks ago

Hi @Dipali_Pawar 

If you’re parsing Excel with a Script Include + GlideAjax and populating the MRVS rows, you can run validation before inserting into MRVS.

After parsing each Excel row, run a RegEx test on each column value.

If invalid, don’t push it into MRVS → instead, return an error to the user.

--------------------------------------------------------------------------------------------------------------------------


If you found my response helpful, I would greatly appreciate it if you could mark it as "Accepted Solution" and "Helpful."
Your support not only benefits the community but also encourages me to continue assisting. Thank you so much!

Thanks and Regards
Ravi Gaurav | ServiceNow MVP 2025,2024 | ServiceNow Practice Lead | Solution Architect
CGI
M.Tech in Data Science & AI

 YouTube: https://www.youtube.com/@learnservicenowwithravi
 LinkedIn: https://www.linkedin.com/in/ravi-gaurav-a67542aa/
0 Helpfuls