XLSForm - can VBA modules be included to control actions?

325
1
Jump to solution
01-28-2021 01:26 PM
LeonardBarnhill
Occasional Contributor

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.

0 Kudos
1 Solution

Accepted Solutions
JamesTedrick
Esri Esteemed Contributor

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

View solution in original post

1 Reply
JamesTedrick
Esri Esteemed Contributor

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