ContributionsMost RecentMost LikesSolutionsRe: How to use a formula field to count number of users selected in a list user field? Also this formula would work, replace with the name of your list user field var UserList myUserList = ; var Text users = SearchAndReplace(SearchAndReplace(Trim(ToText($myUserList))," ;", ";"),"; ",";"); Count( Part($users,1,";"), Part($users,2,";"), Part($users,3,";"), Part($users,4,";"), Part($users,5,";"), Part($users,6,";"), Part($users,7,";"), Part($users,8,";"), Part($users,9,";"), Part($users,10,";"), Part($users,11,";"), Part($users,12,";"), Part($users,13,";"), Part($users,14,";"), Part($users,15,";"), Part($users,16,";"), Part($users,17,";"), Part($users,18,";"), Part($users,19,";"), Part($users,20,";") ) Re: Automatically create a parent record when info saved in the child reference fieldYes, this can be done using automations. I just learn this from Harrison today. You can create a lookup field(named: has-parent)on the child record to the parent's formula checkbox field that has the formula value of true. This lookup will be true if the parent exists false otherwise. Then in the automation when a child record is modified/added and its lookup has-parentfield is unchecked then create a new parent record using the child content for the reference field value.Re: Automatically creating master to detail recordsThis also can be done with an automation :)