I do a lot of surveys that are similar to each other and I’m trying to build some “memory” into my survey form to save the surveyor some time and increase accuracy.
I use MAXROW(Survey, _RowNumber) in a VC to allow Initial Value dereferences to pre-populate a new survey form with options used in the previous survey.
This “memory trick” works OK when a single asset was surveyed but doesn’t work after a multiple asset survey.
I’d like to use a similar “memory trick” so that if a surveyor selects the multiple assets button [survey_type] an expression will return the most recent [previous] column value where [previous] column has more than 1 item in it.
- Survey 10 data cables in cable route (1 survey form + OnSave action to generate 9 additional rows)
- Stop to survey single wi-fi access point where 1 data cable ends
- Survey 9 remaining data cables
- Repeat step 3 until next wi-fi access point is reached
I’m busy playing with versions of the following but it clearly doesn’t work:
([_THISROW].[previous] = COUNT([previous] > 0))
Thanks in advance for any assistance…
Samples of survey form and survey table below