I’ve been building my app, and when I wanted to make a data type “Employee” with a relation to the Users database, and link it using ‘email’ as a primary field, it appears it doesn’t want to save the email of the User type.
When I change it to a custom field “UserID” (text) and set the Primary Field for Users to UserID, it does make that connection.
Funny thing though. When I set the Primary Field to UserID, link the “Employee” to a “User”, and then switch the primary field to Email, it does list the email in App Data view, but when I edit the record it cleans out the field.
I would love to be able to use the Users data type along with my Employee’s records so I don’t have to store their email twice, since they will be logging into this app using their email anyway.
Here’s a screenshot showing that it’s not working as I expect it to. If login details are required, please let me know so I can provide everything you need to determine if this is a bug, or just me being plain silly and overlooking something.