Remember a selection in a dropdown list until next time the schedule opened

[Former Member]

Dear All

I have an issue that I hope you can help me with.

I have an account where I report u201Cnumber of accidentsu201D. The problem is that I can not separate between if a unit has reported zero accidents or if the unit has forgotten to report the current month. To solve this, I created a second account were the units first have to report if they have any accidents or not, (dropdown list with the options YES or NO). If they have accidents then they need to report the number of accident on the first account called u201Cnumber of accidentsu201D, and if they don't have any then they just select NO in the second account. Something should always be sent into the system.

The validations is:

If they have selected YES in the second account (drops down list) then they need to report the amount on the first account. Now I want the system to remember the initial selection in the drop down list until next time the schedule is open. If they have reported YES, then it should be save and if they have selected NO then the system should remember that this specific unit has reported NO accidents. How can I solve this so the system remembers the selection in the drop down list?

The first time they open the report the drop down list should be set to YES, as default.

Thanks in advance for your support

Best regards

Zaher Ashiq

[Former Member · Accepted solution]

I would add a EVCOM to send the text of the cell to the DB. When the template is reopened it will populate the cell with the previous selection.

[Former Member]

Yes I see what you mean, I will try this.. thanks!!

Best regards

Zaher

[Former Member]

Thanks a lot Anton,

I thought of using a EVCOM but then thought the drop down list would look nicer. I might go with the EVCOM instead, much easier.

Thanks again and regards

Zaher

[Former Member]

You should be able to do both. The dropdown will populate with the value of the evcom. Also, you should be able to use the dropdown to change the value. Hope this makes sense.