columns' default value based on other columns
This is a MUST HAVE feature for us to create COMPOSED PRIMARY KEYS in a list.
Let's say one has a list with Name and Year text columns among others and the PK must be Year + Name. One could then create a new unique value column whose default value would be the concatenation of those 2 strings.
I see no big issue to implement this since columns' VALIDATION field always allowed to refer other list columns. What to say a mere default value field.
Being able to have composed PKs in lists is a cornerstone to any SERIOUS use of SPO.
Please make this available, even if at the form level to not deal with schemas would be a pain relief! Enough of HAVING to CODE in forms to just throw a unique default value to ensure tuples' uniqueness! Average business users DO NOT CODE! "powerapps" to them is just scaring and this hampers SPO ADOPTION.