I have a working Survey123 form for inspecting stream crossings. It connects to an existing Portal feature to show existing crossings and past collected data about that crossing. Now the users would like to see the ratings updated as they are inspecting the crossing - rating are currently calculated after the fact in the office.
Can VBA code module be included in XLSForms and triggered by and Boolean question near the bottom of the form to read the inputs of the current inspection only and populate the Ratings fields. These Rating would yhen become part of the survey and saved with all other inputs.
Suggestions? I think this might be better served with a JavaScript but I am deficient at JavaScript - VBA also - but I know people that have done VBA that could help.
Solved! Go to Solution.
Hi @LeonardBarnhill ,
While Survey123 uses the XLS file format to create forms, it doesn't use Excel-specific features like Excel functions or VBA in a form
Hi @LeonardBarnhill ,
While Survey123 uses the XLS file format to create forms, it doesn't use Excel-specific features like Excel functions or VBA in a form