I have a members area on my site which people can create an account via the standard username/password which gets saved in the Wix CRM (PrivateMembersData collection). After they click submit to create the account, it automatically takes them to another page which has form fields connected to my 2nd database which are used to create their dynamic profile page. The 2nd database has a reference field which points back to the 'loginEmail' column of the PrivateMembersData collection.
The problem I'm having is that when the member fills out the form (2nd database), all their data gets saved correctly, but the reference field ('loginEmail') is left blank. Unless I manually go in and set it via the Wix Live Database manager. [SCREENSHOT BELOW]
How can I have the users' loginEmails get automatically passed to the 2nd database so that I don't have to do this manually?
Because if a user logs out and logs back in, they're unable to see their data as the connection from PrivateMembersData and the 2nd database is broken, when this field is blank for their row.
Thanks in advance!