I have a “Category” table with two columns, ‘Category’ and “Tax Rate”.
I also have a “Products” table with two columns, ‘Category’ and “Tax Rate”.
The “Category” column is the associated ‘Category’ table, and the “Tax Rate” column is the corresponding “Tax Rate” in the query “Category” table.
When I want to import the data from the “Products” table in a Excel table, I can’t do the data correspondence because the “Category” column is related.
Text to Linked field is not a supported feature currently. We are working on it & likely will be included as a feature in one of the releases in this quarter.
Table A contains fields linked to form Table B. If I want to import data, does this linked field support excel sheet import.
If the table was exported from NocoDB & if the relation is either has-many or one-to-one – then there is a way by including system fields in your export.
If its an excel which contains text based key (like email) using which you will like to create links, you will have to use API / Scripts for now
If you are using cloud hosted solution, you can use this script.