Text Length & Pattern Checks: LEN, LEFT, SEARCH
This lesson is part of the course
In this lesson
You check new customer records before they go into Larkspur's system: ID pattern, email shape and name length – and count the records that are ready to import.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Number & Date Rules as Check Formulas Locked
- List Rules: Allowed Values with COUNTIF & MATCH Locked
- Dependent Lists: Category → Item with INDEX/MATCH Locked
- Text Length & Pattern Checks: LEN, LEFT, SEARCH Locked
- Duplicate Prevention: COUNTIF & COUNTIFS Rules Locked
- Cross-Field Rules: End ≥ Start and Shares = 100% Locked
- Input Form with Error Messages & an Error Summary Locked
- Template Protection Checklist & Completeness Dashboard Locked