I understand the conditions you don’t allow - referencing record links in primary field formulas - but it it far too limiting. This is a huge, very frustrating issue for me. I’ve gone at length looking at solutions to get around it, but honestly, they’re all so much more data entry and work that it’s not worth the time or effort.
All I want is for the record name, in other tables, to be searchable and addable by a formula-able name, or there’s no point. And I’m never trying to do anything that would create a circular reference anyway. (That I’m aware of)
It would make things so much simpler if you just threw an error in the field when it tried to calculate and it actually created a circular reference, instead of refusing any situation that might possibly create one.
If not… I need a simple solution/tutorial, that actually fits those needs, and doesn’t require 6 records for every record I want entered and searchable on other tables by a formula-based name.