Auto populate a form offline with multiple layers

Hello,

I run a cookstove project in Africa. We need our field staff to inspect the stoves regularly. Each staff member has their villages to manage. And each of their villages have approx 200 houses.

When checking the stoves, we need the user to select their village on the Smartsheet form. It is easy enough for each user to have their own unique URL query string.

But then, when the user selects the village they're inspecting, we need some basic details to auto-populate in blank fields on the form, such as date of last inspection.

How do we get this additional layer of data to auto-populate?

And as we're usually out of network coverage, is it possible at all?

Many thanks to anyone who can assist.

Rgds,

Dave

Best Answer

Answers