Required Input for Lookup Fields & All Upper/Lower Case Formulas
I'd really like to see an option in form creation where you can make a look-up field for a parent-child record required. Also, it would be great if we had toupper and tolower formulas that we could use in calculated text fields. These formulas would ensure all characters are either all upper or all lower case respectively. Both of these suggestions would greatly improve our data consistency and accuracy.
Both items in this request have been implemented. The upper() and lower() functions were released earlier this year and you can now make relationship fields required in forms.
John McGarvey commented
I also need the option to make the link-to-parent field required.
We are releasing the upper() and lower() functions tonight to enable you to return characters in either all upper or all lower case letters. They will be available when you login tomorrow morning!
Thanks for the suggestion!
Jake Marwil commented
We can understand how it would be useful to make a look-up field for a parent-child record required. We will certainly pass this information along to our product team. As for the upper and lowercase functions, these will be available in the upcoming release in the next couple weeks. Please let us know if you have any further questions and thanks for the suggestions!