Timestamp a field when it isn't blank
I have two fields, employee (which is field type user) and Date and time (which is field type date and time formula). My objective is that when an employee is selected from the drop down of the emplo...
Forum Discussion
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
------------------------------
- i 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
------------------------------