Hi, I’m fairly new here, I wanted to know if there is a way to validate whether the data entered into the column starts with a certain character. I’ve tried startwith() but when I use it the validation is done before the number is entered so it doesn’t even show up in the form.
what I tried : STARTSWITH([Number], “+94”)
Solved! Go to Solution.
You can try this :
STARTSWITH([_THIS],"+94")
[_THIS] takes the value of the column in which you are applying the constraint.
Hope this helps.
You can try this :
STARTSWITH([_THIS],"+94")
[_THIS] takes the value of the column in which you are applying the constraint.
Hope this helps.
Thank you Yogesh this really helped
ps. would you happen to know how to set the date of a [Delivered date] column to the date when my [status] column is set to “Completed”.
There are a couple of ways to achieve this.
This way when the user clicks on the action button, it will mark the status as Completed and Delivered date to TODAY.
if you don’t want to have the action button shown, then you can use the workflow to trigger this action.
Hope this helps.
I’ll try that. Thank you for all your help !
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |