Help

Creating Linked Records for Project Management with Formula Field

1343 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Nnenna_Anwara
6 - Interface Innovator
6 - Interface Innovator

Good Morning!

I have a project field that is synced externally and uses a formula. I wanted to use that same project field (with the formula), to link to a tasks field. For some reason, I cannot link the Project Field to my Tasks field. The Projects field does have automation as well. Any tips?

5 Replies 5

Hi @Nnenna_Anwara ,

I think you need to screenshot your tables so we can understand better.

Sure!

image
Here is the primary field with “fxName”

It is in this Table “PM Testing”
image

image
More from “PM Testing Table”

I then tried to link The “FxName” field to “tasks” in the “PM Testing Tasks” table. Where the Projects in “FxName” are a one to many (tasks) relationship
image
image

Im still confused, sorry :grinning_face_with_sweat:

You need to have a Linked To Another Record field in the Tasks table to link it to the Projects table.

Is the Tasks Testing field in the PM Testing table linked to the correct table? If so, then you just create whatever record you want in Tasks Testing table and copy paste the Projects to the tasks

I know it is very confusing. I might need to start from scratch. The field with the “fxNames” is actually the field I wanted to link to “Tasks”, however I am not allowed to (the option is not provided). Then every time I link to a new field, the field comes up blank.

Nnenna_Anwara
6 - Interface Innovator
6 - Interface Innovator

might have found my answer:

Within automations, you can link records using the primary field value for any of the primary field types—except the formula field type.

The field type has an automation and formula. Is there a workaround, or a way to assign projects?