Hi all,
My goal is to have some questions survey auto filled, based upon the sample ID that is entered or QR code that is scanned (containing sample ID). I have a CSV that will be updated prior to each field outing, and it is uploaded to the media file within the Survey123. When entering data into this CSV for select one or select multiple questions, I am pulling the name of the desired answer directly from the name column of the list in the choices tab. I hope to have the caseid, sampinfo_type, sampinfo_filterps, sampinfo_bpkserial, sampinfo_reps, sampinfo_prestype, sampinfo_targetsp, and contactinfo_org name fields in my XLS form for the Monitoring project type only, auto populated with the values found within the CSV, as these values are project specific (within the choices that are already determined). My main motivation for this is to mitigate data entry errors and make the survey less time consuming for the field staff.
I can get the auto populate to work using this example calculation pulldata('pulldata2026', 'projectname','sampid',${sampID}) (example for the caseid field). I have customized this equation to each unique field, and they have all worked well, however when there is no sampid found matching in the pulldata2026 file (which will sometimes be the case), the survey returns a blank response during submission, even if a custom value was entered.
After some tinkering and help from ChatGPT, I have discovered that I need to add a calculation that works as a conditional statement to allow for a user submission and actually submit this answer. In the newest version of my XLS, attached in this post, I have utilized several lines creating a lookup key, lookup calculation for each field, as well as a final "answer" for each field, derived from the conditional statements. No matter what recommendations I am given, I can't seem to get the auto populate to even work now to see if I can test for the blank response.
Ultimately, I would really like to have these fields populate in the original question boxes and have the ability to edit the responses and have them actually submit if the auto-populate is wrong or no matches are found. Any recommendations would be greatly appreciated.
