Hi.
I have 2 tables (based on Google sheets).
1)is users sheet. With name and email for each user.
2) tasks sheet. With data and information about each task.
I want to create this flow:
1)User create new task (easy, I know how to do it).
2) while creating the task, the user chooses relevant owner from the users table (based on the user name). (Easy, I know how to do it).
3) the name of the relevant user (the owner) and the email save in the tasks sheet, in two different columns.( I don’t know how to do it).
For example, Jim create new task for Jack.
Jom will choose the name of Jack while creating a new task.
On the tasks sheet, the name would be saved on the “owner” column, and Jack’s email would be saved on the “owners email” (without anyone will choose the email manually).
Any ideas?