Hi all,
I'm wondering if this is possible in Survey123.
We have a survey that has about 30 say vehicles in a drop down list. The user selects a vehicle fills in some info on it then submits the survey.
Is it possible for that vehicle to drop of the list once it's been submitted, so when the user goes back into the survey the list is getting smaller and smaller?
To further complicate things I could have multiple users and ideally they wouldn't see the vehicles that have dropped off the list. I don't know how that could work when everyone downloads the survey to their own device.
The survey would then need to reset at say midnight with all the vehicles back on the list for the next day.
Any ideas, much appreciated.
Rachel
Nothing "off-the-shelf" like this, as far as I know. I think you'd need to start with something like this:
You'd need to extend it in such a way that when a record is submitted with one value, that sets a flag on that value so its no longer returned in future search() results. For example, a "used" field on your lookup table that defaults to 0, gets set to 1 when submitted, and have your search() filter set to something like "used = 0".
The trick will be flipping that zero value to a one. I can think of a few ways:
None of these are foolproof though, like if two users are working on a survey simultaneously, they could pull the same values off the list. This is especially an issue if users will have drafts hanging around for a while. Also, search() won't work at all if you need to do offline surveys.
A couple of different approaches you could take:
I can maybe think of one way to do this. But it is far to convoluted to lay out in detail. Short answer is that isn't supported at this time.
This sounds like the Inbox may be more useful to you. If you haven't considered that feature yet, that may be a more reasonable solution.
Thank you @MobiusSnake and @abureaux for your replies.
As I thought it's not very straightforward at all. I'll look into your suggestions.
Regards
Rachel