I know this questions has been asked many time before, but I am looking for any Ideas that might fit my scenario.
Basically, I am creating a monitoring form for the shelter activities.
the team is required to visist each house more than one time (in some cases up to 10 times). and they will fill the question in the form, the questions are about the completion percentage for (carpentary works, electricity works. swege … etc).
so I would like to display a hint about the precentage that was entered in the last visit to avoid any inconcestances
for example in the second visit the completion percentage for the electricity works was 30 per, so in the third visit a I would like to display a hint " the percentage in last visit was 30 per"
till now, I wa able to link my kobo DB to google Sheet using the code suggested in this thread.
https://community.kobotoolbox.org/t/kobotoolbox-google-sheet-sync/622
and the Sheet will be updated using trigers every 1 hours, now I would like to pull the data from this sheet to complete my mission.
I red @stephanealoo suggestion about using folderSync app for Android in this thread
https://community.kobotoolbox.org/t/rest-request-to-retrieve-a-value-from-an-external-source/9899
but I can’t use this app because I have 7 partners and each partner has about 15 employees will work using this form, and also the form folder on the mobile will also contain pictures (about 500 pics) so it is time consuming to sync the whole folder every time.
any experts’ thoughts on how to complete this ?
thanks so much