Hello, I am looking to build automation.
I have 2 tables: Task and Sub Task (both are linked). If a subtask is created under the task record, then the project selected on the task should be auto-populated in the subtask project field related to the specific task.
Thanks in advance!
You shouldn't need an automation. You can just create a lookup field for the project from the task table.
@BobbyNoCode wrote:Hello, I am looking to build an automation.
I have 2 tables Task & Sub Task (Both are linked), if a sub task is created under the task record then the project selected on the task should be auto-populated on the sub task project field that's related the specific task.
Thanks in advance!
@BillH : Just to clarify, I already have a project lookup field on the task table, if a project is selected under the task table and after that a sub task is created under the task then the project selected in the task should be auto populated on the sub task record.
Can't you then add a lookup in the subtask table to the task table? I generally try to keep my bases normalized so I avoid lookups unless they're absolutely necessary, but for tools (such as Documint) I've needed to pass lookups through several levels.
Buddy, I can add a lookup to the task table from the subtask table but in that scenario task needs to selected to be able to pull the project that's selected in the task.
I want if Task is created with a project selected then sub task is created that project name should auto populate on subtask.
I guess I'm not understanding the question. Good luck.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.