How to combine more than 2 fields into one option as lookup

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
User avatar
urichard
Veteran Member
Posts: 87
Joined: 2018-11-01 12:11

How to combine more than 2 fields into one option as lookup

Post by urichard » 2022-11-27 13:46

Hi,

I see Appgini does have an option to combine 2 lookup field options from one table into another table as a lookup field option but how do I combine more than 2 fields into one lookup field option?

For example the lookup field options: Colour: Blue, Green & Weight: 1kg, 2kg & Category: Flight, Ground & Type: Single, Double

So the table options to lookup to combine more than one field for example would be:
1. Blue 1kg Flight Single
2. Blue 1kg Flight Double
3. Blue 2kg Flight Single
4. Blue 2kg Flight Double
5. Blue 1kg Ground Single
6. Blue 1kg Ground Double
7. Blue 2kg Ground Single
8. Blue 2kg Ground Double
9. Green 1kg Flight Single

And so on and on...

So the options to choose from would then be from these 9 mentioned above (which has been compiled by other fields)

How to do this please?

This is related to post of viewtopic.php?f=8&t=4951&sid=ff62150f3e ... 31929cc0ce

Thanks for the help,

Kind Regards,
Richard
[email protected][/color]

Kind Regards
Richard

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: How to combine more than 2 fields into one option as lookup

Post by pbottcher » 2022-11-28 21:45

Hi,
you can use the advance SQL setting within appgini to concatenate whatever information you want to display on the lookup.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

Post Reply