Name Lookups

Hi,

I've started working as a volunteer for a charity in Africa who got themselves into a complete mess using Excel as a data capture solution.

Briefly they want to track the health and education of children in various villages they are funding

There are two main issues.  Internet access is very patchy so Jot Form use would be brilliant as they can work off-line then update an Airtable

The other issue is data cleanliness so I would much prefer them to choose from a dropdown list of names rather than typing it in - same with birthdays etc

However - there is an almost certain chance of people having the same name so I could calculate a uniqie ID in Airtable but I can't see for the life of me how to pass this into a new JotForm

Any ideas?

Sorry if this is a bit long

Thanks

You can use the Unique ID widget on your form. You can find it here:

https://www.jotform.com/widgets/unique-id

This widget will let you attach an alphanumeric code to every form submission you receive. With a unique identifier for every booking, purchase or order, it will be easier for you to organize submissions and quickly access them in your records.

Let us know if you need any further assistance.