Enforcing Uniqueness on a Formula Field
I have created a formula field on my Project Status record to concatenate Project record id (totext version of it) and a date field on the project status record (child of project). I would like to...
Forum Discussion
Try changing the formula to
ToText([related project]) &
Mid(ToText([Status Week Of]),7,4) & Mid(ToText([Status Week Of]),1,2)
& Mid(ToText([Status Week Of]),4,2)
ToText([related project]) &
Mid(ToText([Status Week Of]),7,4) & Mid(ToText([Status Week Of]),1,2)
& Mid(ToText([Status Week Of]),4,2)