i have a automation that builds out new records, and depending on the project being created in Table A it connects to different linked records on other tables, for ex Table B and Table C.
Table B uses a text field as primary field, so anytime i am connecting to this table with Update Record, it easily links to existing or creates new.
however Table C uses a a formula as a primary field. When i use the update record it is not connecting due to computed field. i dont want to create new records, i just want to connect to existing. I have a formula on my recoird creation that determines the correct linked record, and it does exist, but it still fails.