Autofill value from database or excel file

[linux]

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

[Ally]

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

[linux]

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

[Ally]

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

[linux]

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.

[Ally]

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

[Author]

Posts