Oct 31, 2022 07:48 AM
Table A = projects, with a linked record of “Property” to table B
Table B = property, with a collaborator field
Previously had a rollup field in Table A to pull a Property based collaborator into a project, then have an adjacent field in Table A to override this rollup with a manual collaborator as needed, and then an automation to update the actual collaborator field with the final result (override, or standard assignment). Total = 3 fields and 1 automation, and no single field for easy management.
Preferred setup: When property is selected for a project, automation runs to lookup the collaborator in the Table B, and assign on the single collaborator field in Table A. If the project lead needs to change this assignment, they can then just remove and reassign collaborator. Total = 1 field and 1 automation.
HOWEVER… when I go to setup automation:
The problem is that when I do the find records actions, I can not use the Dynamic value of the property selected in step 1 to find the correct record in Table B, perhaps because its a linked record? Choosing this field all options become greyed out and has a “ :no_entry_sign: ” emoji on mouse pointer. Is there a way to find this record without creating yet another field for the linked record as a string?
Jun 13, 2023 10:48 AM
Commenting to hopefully expand reach.