Visibility for users without profiles

Read through this again:

The very first step is the if then column in the profile sheet. Don’t fill it with the persons name, fill it with the word ‘Name’, or ‘Profile’, or anything really. You are filling with the persons actual name which will not allow this to work, because we need a common value for the relation to work. With this step only the signed in user’s profile will have the word ‘Name’ in their profile row.

Next follow the rest of the bulleted items. Again, create the template with the WORD name. Not the actual persons name. Create the relation to link this column with the if/then column. This will build a relation with on every record where the matching row is only the signed in user. Then create the lookup column against the relation and you can pull back the signed in user’s first and last name. This will be the same signed in user’s name on every profile record. You can then build your visibility to check if the lookup first and last name is not empty.

Again, the key here is to build the templates with the word ‘name’. Not the person’s name.

2 Likes