do a lookup and populate related fields in form

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
dmac411
Posts: 10
Joined: 2014-04-21 01:06

do a lookup and populate related fields in form

Post by dmac411 » 2014-04-21 04:52

Noob help.

0. I have a form where I do a look up for a customer code.
1. I select the customer id from a customer look up
2. I want to auto populate the last, first, address, city, st,..fields on the form after the customer code is selected.
3. I looked around the videos, etc.. either I'm missing it or can't find a reference to this on the forums.
4. Any direction is much appreciated.

Dmac411

AhmedBR
AppGini Super Hero
AppGini Super Hero
Posts: 327
Joined: 2013-09-19 10:23

Re: do a lookup and populate related fields in form

Post by AhmedBR » 2014-04-21 10:54

What you need is Auto-fill fields:
http://www.bigprof.com/appgini/tour03.php
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper

dmac411
Posts: 10
Joined: 2014-04-21 01:06

Re: do a lookup and populate related fields in form

Post by dmac411 » 2014-04-23 03:07

Ahmed,

Thank you I tried the autofill with the default bootstrap and I fields are not filling in. I am going to try to use a diff theme for testing.
I created the parent look up and had the child fields to be populated on the form linked to same parent and with autofill check box enabled.
My form has about 50 fields in it and there are at least 4 sections of the same form that will require the same autofill behavior with different parents.

Ill test a sample form as well but wanted to give you my feedback.

dmac411

dmac411
Posts: 10
Joined: 2014-04-21 01:06

Re: do a lookup and populate related fields in form

Post by dmac411 » 2014-04-23 06:10

I got it to work!
I think the issue was related to the key not being auto incremented.

Once I set the form key and reestablished parent and child auto fill fields then everything populated.

Dmac411

AhmedBR
AppGini Super Hero
AppGini Super Hero
Posts: 327
Joined: 2013-09-19 10:23

Re: do a lookup and populate related fields in form

Post by AhmedBR » 2014-04-24 22:40

Glad it is working. have a nice day.
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper

Post Reply