Default current record value on CSV import

oriol

Hi,

Is there a feature to add a default value on a column during a CSV import? For example, I have a relation of classes, another one of students, and a many-to-many student_classes relation. If I'm on a class record, and I'm browsing through the list of students in that class (by filtering student_classes by class), let's say I want to import a CSV of new students in the current class (creating new rows in the student_classes relation, using record lookups to populate the students). The CSV doesn't contain info about what class they're in, but I know what class the user means since they're doing this operation through the current class record. Could I add the current class ID (like app.get_record_id(0)) to one of the CSV columns, instead of having to add the class ID on every row on the CSV before importing?

gabriel

Unfortunately not. The CSV importer can only handle things that are in the file. So you would need to either include the class ID, or better still, a unique class name so that you can use record lookups to get the correct class by name.

I´ve talked with a colleague and it is technically possible to store a context value in the backend (when visiting a particular form for example) and then use that value as context info to automatically fill in the class during a CSV import via trigger function. It is possible but it would be a huge hassle.