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 sp...
I want to build an automation in Airtable where the user creating the record, will have their domain auto-populated based on the separate table in which each person has their own domain defined.For example, if John is creating the record and the John...
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...
@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...
Thanks Brian, this solution does work but the only problem with this is that if users want to update the Domain manually then they won't be able to do so. As it's a lookup field based on the linked field on the People.
