Using Data Preloads with Google Drive as Server

1. What is the issue? Please be detailed.

I have created a simple form with a section that pulls data from a preloaded file and uses the information in other subsequent questions.

I have uploaded my preload and the form to google drive but on odk collect the pre-loaded data is blank.

2. What steps can we take to reproduce this issue?
I have attached the excel file and the csv preload . Status and previous factory are supposed to be pulled from the preload, then previous_week_factory_status is a note which uses the pulled data

3. What have you tried to fix the issue?
I have tried to use an excel file as preload with same result

4. Upload any test forms or screenshots below.
factory_preaload_week_115.csv (8.9 KB)
factory_update_survey.xlsx (101.1 KB)

Hi @Carolk
First of all please add the missing column name in your csv file (the first one which is empty) otherwise the file won't be loaded properly in ODK Collect.

You are trying to find the value from column not_work_reason and factory_recodes from the csv file where answer for question respid should match values from respid column from the same csv file. Unfortunately as I can see values you have in that respid column in the csv file are not the same as you have in the choices sheet for respondent. That seems to be the issue. Those values need to match.