Skip to main content

Automation to populate field from different table

  • April 25, 2024
  • 5 replies
  • 34 views

Forum|alt.badge.img+3

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!

5 replies

BillH
Forum|alt.badge.img+24
  • Brainy
  • 180 replies
  • April 25, 2024

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!


 


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 3 replies
  • April 25, 2024

@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. 


BillH
Forum|alt.badge.img+24
  • Brainy
  • 180 replies
  • April 25, 2024

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.


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 3 replies
  • April 25, 2024

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.


BillH
Forum|alt.badge.img+24
  • Brainy
  • 180 replies
  • April 25, 2024

I guess I'm not understanding the question.  Good luck.