I have a form where the Title field is calculated from a formula. I've done this before and thought it would be easy, but I was so wrong.
I want the Formula to be IDLastName02122020
[Context].[Item ID] + userProfileLookup([Context].[Item Created by Display name],"LastName") + formatDate([Context].[Item Created],"MMddyyyy")
But it does not populate.
I tried with just one element - ID, and still, I get an empty field.
Attaching a screenshot of ID Formula
@EuanGamble any idea?
Solved! Go to Solution.