Thanks, @peterdykstra and other staff, for considering my question about CSV during today's office hours. As I mentioned, I've reviewed the various help articles you mentioned, as well as searched the community forum. I don't find an answer to my challenge--which I assume is not an uncommon use case--although I also acknowledge I may be missing or misinterpreting the reference information available.
Anyway, here's the concrete question again since you said you'd follow up with more direct guidance.
I need an "import CSV" action from a parent table row to populate child table rows (child rows should have parent ID column automatically populated). My challenge is figuring out how to populate the child row's parent ID when the child row is created via CSV import.
By way of illustration:
- In my app, a single row in the Lists table is the parent of many rows in the Contacts table.
- A user will create a new entry in the Lists table, at which point the new Lists row's List ID column is assigned a UNIQUEID() by AppSheet.
- The user will have a csv file that they export from another data source they use (and to which my app cannot connect directly). The csv file will have data for the Contacts table, but will not have the parent Lists row's List ID.
- I'm having trouble figuring out how to populate the List ID column as the csv is imported to the Contacts table even though the user is triggering the import from the context of the parent row.
LinkedIn
Twitter
