Name Lookups

  • Profile Image
    rjh52
    Asked on June 22, 2020 at 06:48 AM

    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

  • Profile Image
    IvayloK
    Answered on June 22, 2020 at 09:06 AM

    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.