Hide Select Item if Already Selected

1. What is the problem? Be very detailed.
I have A list of schools to be visited and inspected but i need it to be selected only 1 item per form , any way to achieve that so if any one select item ,the second employee cant select it , or have an indicator that its selected before

2. What app or server are you using and on what device and operating system? Include version numbers.
latest copy of collect and Aggregate

3. What you have you tried to fix the problem?
search all over manual and cant find it

4. What steps can we take to reproduce the problem?
fill list of drop down (A/B/C/D), answer form , With select A , next time A Expected to be not shown

I'm not quite sure I fully understand so I'm going to lay out the scenario I think you're trying to get to:

Employee 1:

  1. Visits School A
  2. Opens form
  3. Selects School A from first question in form - they could have selected School A, B, C or D
  4. Fills out the rest of the form
  5. Submits form

Employee 2:

  1. Visits School B
  2. Opens form
  3. Selects School B - but, they could only select School B, C or D. School A was no longer an option.

Is that correct?

Hi @Ayman_Elarian welcome to the forum! Please introduce yourself here!

unfortunately it's not possible to do that unless it's just one form. You can't just get answers from all already filled forms to determine which options should be used in the current one.

Exactly thats what i need , can we do that ?

Hi @Grzesiek2010 Thank you for your replay , any advice for doing that

I think as @Grzesiek2010 there isn't a way to have results of one instance of a form effect another instance.

1 Like

This is the kind of thing that the relatively new last-saved-instance feature is designed to enable if all data collection happens on a single device. This has not yet been officially announced because there is no XLSForm support yet. I believe the last bits of the specification have just been approved so this should come relatively quickly now. :crossed_fingers: :crossed_fingers: Note that this is not hugely performant and has some limitations.

Unfortunately, as I tried to create a form to demonstrate this, I ran into a couple of bugs filed at https://github.com/opendatakit/javarosa/issues/451 and https://github.com/opendatakit/javarosa/issues/449.

dont-show-options-selected-in-other-instances is a teaser that does NOT work in Collect 1.22 but will hopefully work in 1.23. I'll update this thread once it does.

Thanks for asking this question, @Ayman_Elarian, so that we could identify and fix the bugs!

1 Like