Forum Discussion
ShaneSelasky
5 years agoQrew Cadet
So i had a table in which all the employees were listed. Tried to create a relationship and it only work once. By this i mean when i built my relationship between the two tables (employees and onboarding), and made the employee field a proxy reference, then i could create a rule that if the employee field was not equal to blank, then the field date and time would change. However, i will have multiple fields in which i need to select an employees name to be assigned a task. So this won't work.
------------------------------
Shane Selasky
------------------------------
------------------------------
Shane Selasky
------------------------------
- ShaneSelasky5 years agoQrew Cadeti figured it out. Had to create a text - formula field called Full Name in the table that converted the user field into a text. Used the command UserToName. Then i created the relationship between the employee table and onboarding table. User Field as the reference and the Full name field as reference proxy. Lastly i have to recreate this relationship several times so i have multiple fields i can select the user.
------------------------------
Shane Selasky
------------------------------