can we associate task to one project with URL formula button ?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have two tables Project and Tasks.

One project has many tasks and One task associated with many Projects.

Scenario is:

Projects Table:                                         Tasks Table

Project 1 -                                                 Task 1,Task2, Task3, Task4 and Task5

Task 1
Task 2

 can we add task 3 to project 1 with a click of button.

All tasks are the unique. they can associate with many projects.

Photo of Gaurav Sharma, Certified Builder and Expert

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
So, you mention that each Task is unique, but that they can be part of many Projects. Can you provide a bit more of an example so that I can better understand the relationship between the Projects and the Tasks?
Hi Blake,

Thanks for your reply.
Yes, this is a scenario of many many relationships I workaround on this and create a 3rd table to do this.It works for me.

Thanks,
Gaurav Sharma
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
Ok, yes, that's what I was getting at. So you basically end up with one table as a "Library" of sorts for the possible Tasks