Validate submissions in central server

Welcome, @jeffbundi! When you have a moment we'd love to learn more about you and your project. Check out the introduction thread for others doing work similar to what you're doing, too.

First, I assume that the follow-up 2 and follow-up 3 assessments are different from each other, is that right? If not, perhaps you can edit the follow-up number from Central or maybe not even ask for a follow-up number but instead order follow-ups based on date.

There is no concept currently in ODK of the server doing validation at time of submission. That's because the system is designed to work well in disconnected environments where submissions may be sent significantly after data was collected. The ODK way to address the need that you have would be to try to prevent the error in the first place. In this case, it should be possible to do something like calculate the assessment number or have a constraint on it.

Do you know ahead of time what months the assessments will take place in? If so, you could use the date to validate the assessment number. If each facility is on a different schedule, you could include the target date/month in an attached data CSV.

If you don't know the schedule ahead of time and your assessors have fairly frequent internet access, you could use entities to help manage the workflow. The general idea would be to create an assessment entity each time an assessment is complete. Each assessment would include the facility that the assessment is for, the date, and the assessment number. Then you could use that information in your forms to show a summary of completed assessments and/or only show the assessment(s) that still need to be done.

If any of these techniques seem like they would be helpful to you, please let us know and we can provide worked examples.