- April 14, 2021 at 6:55 am #32821
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 youApril 14, 2021 at 9:47 am #32825April 14, 2021 at 10:04 am #32826
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 youApril 14, 2021 at 11:02 am #32828April 15, 2021 at 3:51 am #32829
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.April 15, 2021 at 9:22 am #32830
- You must be logged in to reply to this topic.