How to populate value in inputbox on form load from Database?

Follow

Rakesh Burde

• January 02, 2020 10:43

I want to fill some filed (Input boxes ) of form from database table entry. I do not find a way to achieve this. 

0

• 

  sysberry GmbH

  • January 02, 2020 13:27

  Hi Rakesh,

  You need autolookup control for that.

  Regards,
  Alexey

  0

  Comment actions Permalink
• 

  Rakesh Burde

  • January 03, 2020 07:41

  Thanks Alexey,
  I use the auto lookup activity and configure my table in it. 
  But How can I configure this auto lookup activity with my input field?

  0

  Comment actions Permalink
• 

  sysberry GmbH

  • January 03, 2020 09:07

  Hi Rakesh,

  The autolookup have lookups of 2 types: name/value (for dropdowns or other controls of this type) and multiple columns for other controls (for example text boxes). If you choose multiple columns you will need to check the column you want to put inside the text box and right to the column name you shoud put the internal name of the text box (drag and drop from form fields).

  Regards,
  Alexey

  0

  Comment actions Permalink
• 

  Rakesh Burde

  • January 03, 2020 09:51

  Thanks.

  0

  Comment actions Permalink
• 

  Khadar Hassan

  • May 20, 2025 07:39

  Can you please give an example how to do that.I am also struggling with the same issue.

  For example, 

  Column name DB = Col1

  textbox name = Textbox1

   

  It would be great if example screenshot were share.

  0

  Comment actions Permalink

Please sign in to leave a comment.