teableio
Unable to import linked records when importing excel/csv
Describe the bug When importing records in an existing table, I am unable to import values in a field if it is linked to another table.
To Reproduce
Create a Client table and Tasks table, and link them:
Client table would look like this:
Tasks Table would look like this:
Notice that the Tasks in Tasks Table are linked to a client. Based on that linked client, the "Mapped to" is being lookedup from Client Table.
When I import additional tasks from Excel file into the Tasks table, I am unable to specify "Clients".
Screenshot of input file below:
Screenshot of import menu below:
Expected behavior As long as I have correct Client names, I should be able to import this. As a work around I create a "temp_Client Name" column where I import "Client Name" and then I copy paste values form "temp_Client Name" column to "Client Name" column. This copy pasting correctly links the relevant client from Client table in Tasks Table.
Screenshots Screenshots in line above.
** Client (please complete the following information):**
- OS: Windows
- Browser Firefox
- Version 126.0b8 (64-bit)
Platform (Please tell us which deployment version you are using) Teable.io and Docker-Standalone both
Additional context I do copy paste (workaround noted above) from Microsoft Edge, since firefox does not support it yet.
Appreciate for feed back. It is necessary for in-place import link type field. We'll support it soon.
