Import data into a lookup field with multiple values
I've searched through all documentation/forums and nowhere is this simple use case adequately explained or documented
I want to import data into a form that contains a lookup with multiple values with a form linked by lookup relationship. The classic example is I want to import data of students who have multiple courses.
- I have a form for students.
- I have a form for courses.
- In the student form, the courses field is a multi-select lookup from the courses form.
I have a .csv file that has all the student data with the course data included, and I can format in any way to fit Zoho Creator so it can understand it. I can even swap courseid with a zoho system id if I need to.
This is blocking me from upgrading my subscription to Zoho Creator because I need to know this is possible before I can commit to this product.