What is the proposed idea/solution?
In the configuration screen for a linked record field, show the name of the backlink field. This could be either read-only or editable.
For same-table links, state that the field is a same-table link and does not have a backlink field.
When creating a new linked record field to a different table, state that a backlink field will be created and display the name that will be used (or let the user enter a name for the backlink).
How does is solve the user problems?
- Many novice creators do not realize that a back link field is created when they create a new linked record field. This would let them know.
- Once users are accustomed to the creation of backlink fields, some are surprised and confused when same table links do not have backlink fields. This would make things clearer for them.
- Creators often don't think about naming the backlink field, as the default name usually works when there is only one linked between two tables. However, sometimes the default name doesn't work and should be changed, especially when there are multiple links between tables. Showing the name reminds creators to pay attention to the backlink field name.
- When deleting a linked record field, the backlink field also often needs to be deleted as well (versus hanging around as a single line text field). Showing the name of the backlink field will make creators more aware that they should delete the backlink field, and also make it easier to find the backlink field to delete it.
- When there are multiple links between tables, especially in legacy bases where backlinks were not named well, it can be difficult to figure out relationships.
- Although the Base Schema extension shows which linked record fields go together, in a large base, the diagram is a huge tangled mess and too hard to work with.
- It is also possible to identify backlinks by looking at field data, but this is cumbersome and depends on knowing the data values or having the ability to put in test data.
- The "Show Dependencies" tool lists the backlink field among all the other field dependencies. This is probably the easiest way to see the name of the backlink field, but the nature of the dependency is not obvious to new users.
- Scripting is another way of identifying backlinks, but that is also a niche skill.
How was this validated?
Personal experience maintaining bases.
Who is the target audience?
People with creator permissions who will be creating and maintaining linked record fields, including both novice and experienced creators.
