Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Insert into database if text field holds data starting with (Product Type*)

(0) ShareShare
ReportReport
Posted on by 20

Form Text Field: 

Want to allow user just to insert data that start with "PRODUCT TYPE" 

and further they can add as below

Product Type

Product Type-1

Product Type-91

Product Type-33

Product Type-BAX

Product Type-UAT

  • Suggested answer
    Martin Dráb Profile Picture
    233,305 Most Valuable Professional on at
    RE: Insert into database if text field holds data starting with (Product Type*)

    Assuming that you're talking about a form, the input control is bound to a table field and you want the same logic in all forms, you can override validationField() and/or validateWrite() method on the table and check if the value starts with the given text (with strStartsWith()).

    validateField() is called immediately when a field value changes in a form.

    validateWrite() is called before saving a record to database.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 185

#2
Martin Dráb Profile Picture

Martin Dráb 147 Most Valuable Professional

#3
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 130 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans