lookup autofill shows integer instead of data in editing mode

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
G Belgrado
Veteran Member
Posts: 61
Joined: 2017-03-12 09:24

lookup autofill shows integer instead of data in editing mode

Post by G Belgrado » 2019-12-10 07:56

Lookup autofill shows integer instead of data in editing mode.

field 1 lookup dropdown shows data
field 2 lookup autofill shows integer
field 3 lookup autofill shows data
field 4 lookup autofill shows integer

Instead in "new insert" mode, shows the data all.


I do not understand why

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: lookup autofill shows integer instead of data in editing mode

Post by jsetzer » 2019-12-10 15:49

Please check if your fields have been updated correctly in Admin Area, Utilities, Rebuild fields. Otherwise fix all fields.

If problem remains:
Can you please add screenshots of the settings for field1, field2, field3 and field4 and also a screenshot of the output.
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

G Belgrado
Veteran Member
Posts: 61
Joined: 2017-03-12 09:24

Re: lookup autofill shows integer instead of data in editing mode

Post by G Belgrado » 2019-12-10 16:29

in rebuild fields I have no errors.
Perhaps the problem is because the fields in the table to which the lookups refer are also their lookups for 2 more tables.

Now I can't put images of the output
because there are real data with names.
Later I try to make a scheme to explain myself better

thank you Jan

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: lookup autofill shows integer instead of data in editing mode

Post by jsetzer » 2019-12-10 16:49

If the autofills themself are pointing to lookups, I do not know any "out-of-the-box" solution.
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

G Belgrado
Veteran Member
Posts: 61
Joined: 2017-03-12 09:24

Re: lookup autofill shows integer instead of data in editing mode

Post by G Belgrado » 2019-12-10 17:11

yes, maybe it's better to create 4 more fields in which to insert the values in hooks before_insert and before_update

but between me and javascript there is no real friendship

:mrgreen:

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: lookup autofill shows integer instead of data in editing mode

Post by jsetzer » 2019-12-10 19:11

You don't need Javascript to fill additional fields in before_insert / before_update hook, just plain PHP.
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

Post Reply