Convert any field to `link_row` (Link to table) and vice versa
Convert Text to Link Row and vice versa without losing data.
Requirements
- It must be possible to convert any text based field to a
link_rowfield. - When converting, the cell text values must be compared to the primary field cell value in the related field. If the value is equal, we must make a relationship to it. If it's not equal it must be ignored.
- The primary field value can be of different types. We want to make it compatible with as many types as possible.
- When converting from a
link_rowfield to another field, the text values of the related primary field must be set.- Note that this means in an edge case, it should be possible to change the related table of the field, and it tries to keep the relations if the values are the same.
- When converting to text, the values must be joined by a
,. - When converting from text, the values must be split by a
,. - The conversion process is similar to the multiple select field, but than with the requirement of having dynamic primary field cells instead of select options. We have figured out a lot of edge cases there, so please take a look how that works.
Community
Another request on this feature is to convert linked records into multiple select: https://community.baserow.io/t/convert-linked-records-into-multi-select-drop-down/1623.
Edited by Bram Wiepjes