Forum Discussion
So you'll need to adjust this for how you actually close out your record / submit it - but the idea is to create some kind of 'validation passed' field. That field is just a big checkbox that lists out all the fields you want completed and checks if they have a value. So something like:
if(
[Field 1] != "" and
[Field 2] != "" and
[Field 3] != "" and
[Field 4] != "" and
[Field 5] != "",
true,false)
With that field - it will be unchecked until all of you fields are entered. You can then use form rules, or other ways depending on how they are 'submitting' and say something like:
When validation passed if not checked, make read only or hide your submission field.
So if you have something like a 'Submit' checkbox - then you would make the form rule hide or make that field read only until validation passed is true.
You could also do something similar - and make a formula-rich text field that makes a bulleted list that spells out which fields they actually need to still complete as well.
Just make sure in your if statement that you're accounting for data types for things like dates, numbers, etc.
------------------------------
Chayce Duncan
------------------------------
Related Content
- 9 months ago