Count from multiple submitted forms

Question

Hello ESRI survey123 consultant

We are working on a project for retail business , and one of their requirements to have form for their sales representatives onsite visits who have a daily visit target number ,they want to calculate the number of visits and compare it with the daily visit target ,if it is => daily target visits number then the total visits should be visible in the form in green color of font else red color font should visible.

We have tried to use repeate function ,but we found that it only works for counting withing the group of the same form  while we are looking to count the total visits from multiple forms submitted.

Please help us in order to protect this deal.

With regards

Jawhara Taha AlAdimi

NATCO

ESRI YEMEN

email jawhara.aladimi@natco.com.ye

dougbrowning · Answer

If you want it in the form then I think a javascript function could do it.  You would need to be online of course.  Sorry I am always offline so never tried it.  Someone else on here could answer better.  Or just search the help and the boards and you will see posts on this.

Jawhara_Aladimi · Answer

Hi Doug

Thank you for your prompt reply.

Actually,  the form is survey123 form which is used by medical sales representative daily in when he visits the targeted doctors in order to peeform marketing tasks for their produced medicines.

Each sales representative has a target of number of visits daily and his manager wants us to show a note on the survey123 for. Showing the number of performed visits in the same day and mark it on green colour if its is => target and red color if it is < target in order to encourage him to visit more doctors.

For example

Let us assume that the visit target of the sales Rep. is 10 and till now he visited 5 doctors and filled 5 forms .

Here ,we need the count of the submitted visits (submitted forms) to be appeared as a note when the sales rep open new visit form of survey123.

Also we need to calculate the number of visits div number of doctors at the working days in a month.

I wish ,I explain the idea.

Regards

Jawhara_Aladimi · Answer