Autofill value from database or excel file

Home Forums Quform WordPress Autofill value from database or excel file

This topic is: not resolved
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #32821
    linux
    Participant

    Hi,

    I have master data on table “masterdata” in database or excel. The table 1500 entries data, and have field structure below
    – fullname => text
    – phone number => autofill, read only
    – email => autofill, read only

    I want to create a new form. When user fill name “John”, another read only phone number and emaill will autofill from database or excel.

    It is possible ? How to create autofill that value retrieve from database or excel ? Thank you

    #32825
    Ally
    Support Staff

    You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

    #32826
    linux
    Participant

    Hi,

    Thank you for fast respond. How to autocomplete ? Example when i type “Jh..” on fullname field will show nam suggestion from database Jhon, or Jhonny or Jonny Andrea.

    Thank you

    #32828
    Ally
    Support Staff

    You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

    #32829
    linux
    Participant

    Hi Ally,

    Autofill is work, but it make my visitor confuse. Condition,all elements using logical. [quform-field-1_4] and [quform-field-1_5] is readonly.

    When i fill fullname [quform-field-1_3], my sql query will select data and autofill next element phone number [quform-field-1_4] and email [quform-field-1_5]. Because quform-field-1_4 get value from sql, it will automaticaly show.

    But for next element quform-field-1_5 will not show. It will show if i click quform-field-1_4 and click another place on page. Also, for quform-field-1_6 will not show. It will show if i click quform-field-1_5 and click another place on page.

    #32830
    Ally
    Support Staff

    You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.
Be inspired. © 2020 ThemeCatcher Ltd. 20-22 Wenlock Road, London, England, N1 7GU | Company No. 08120384 | Built with React | Privacy Policy